reportfurther the answer to your question would be close to the proverbial knife fight in a phone booth.
Personally I think the only one in the cabin who should be armed is a sky marshal also known to the crew. And the cockpit crew should have a last line of defense beyond the secure flightdeck door.
Handgun, stungun, pissed off ex-wife or a rabid feral cat! I don't care just give me the ability to make a last stand before Abdulla Omar bin Swalahillie slits my throat with a packet of coffee creamer wrapped in tinfoil and then drives my jet into the side of the local seven-eleven...
Thanks for the answer Guv. I had no idea who they were.