Shotgun with #8 shot. Much louder, deeper boom, falling projectiles are a little bigger than a grain of sand. Problem solved. Firing a handgun into the air in an urban area is just plain stupid.
You may be technically correct but getting your jollies by firing any gun into the air strikes me as a bit odd (I'm being polite here).