And is black powder so scary? You can get it out of firecrackers, which are sold (here) without ID, although I guess you might have to prove your age to buy fireworks. It doesn't detonate, so it can't be used to prime a high-explosive like ammonium nitrate fertilizer.
As for why your experiments weren't as spectacular as you hoped: the particular charcoal you use is really important. Its best to make your own with a paint can, some willow, a nail, and a campfire.
Adequate crushing of components into floury powder follows, then adequate mixing, and ideally wet-pressing and corning.
Source: an extremely misspent youth.
Its actually quite fun to read the labels on stuff when browsing shops, you find all kinds of bizarre shit.
What I did have more success with is smoke bombs. Mix sugar and KNO3, heat up slowly in a non-stick pot until molten, pour into appropriate molds, let cool and ignite as desired.
We eventually gave up and graduated to shoplifting model rocket engines, which we powdered with vice grips.
The door to my house was open, and we were sure no-one would enter.
There are parts of the world (Compton, for instance) where crime rates are so high houses get broken into no matter what.
Except close friends, who could just walk in. Sometimes after a quick knock.
Tinkering with chemistry also motivated me to look for sources of hydrochloric and sulphuric acids, but in New York state the guy at the pharmacy said I needed parental permission. Wasn't gonna happen.
Sulphuric acid: No, hardware stores don't sell that here. You can get it from car batteries, and builders use the strong stuff for clearing drains. I have no idea how I could legally buy fuming sulphuric acid.
Nitric acid: Even less. Fuming nitric and sulphuric acid mixed gives you nitrating acid, which in turn is the gateway to nitrocellulose (and I suppose nitroglycerine), fulminate of mercury, and ghod knows what.
It's just as well that these latter two acids are restricted; if they weren't, I'm quite sure I'd have tried to make guncotton, and probably blown myself up.
The happily provided both... with a minimum order quantity of around 250 gallons.
And Duda Diesel sells a liter of 67.2% nitric acid for $60.43, or $101.69 for 2.5 (plus shipping ofc).
I also recall a cousin had one of these Cox planes and almost gave me a haircut with it one day.
[Spanish] https://www.lavozdegalicia.es/noticia/vigo/2014/12/21/jugand...