I just traveled with an aerosol can in my checked luggage. You won't be able to bring them in carry on. The airlines (at least Spirit) are now allowing 3 oz or less travel size bottles of shampoos and things. Ladies, you can't have mascara in your carry ons either.
For the aerosol cans I remove the cap so that something doesn't get pushed down on the top and spray all the contents out.
FWIW when I fly Spirit I haven't had a problem with aerosol cans. The last two times I flew NorthWest my aerosol can was missing when I got to my destination

It's only a can of bathroom spray so I'm not sure what the fascination is