“Now, Pussy, you know a lot more about planes than guns. That’s a Smith and Wesson 45, and if you fire at me at this close range, the bullet will pass through me and the fuselage like a blowtorch through butter. The cabin will depressurize, and we’ll both be sucked into outer space together. If that’s how you want to enter the United States, you’re welcome. As for me, I prefer the easy way.”...007 to Pussy Galore in GOLDFINGER
That's a great scene and line from a really cool movie. However, the scenario Bond is describing is pure Hollywood myth and BS. This myth of a single small-caliber puncture in the fuselage automatically resulting in "explosive decompression" is simply nonsense.
While no one should claim that such an occurrence would be desirable, the fact is that all pressurized airplanes are, by design, constantly leaking air. The pressurization status is maintained just by having the pumps maintain the desired differential between the inside pressure and the outside pressure. I have read somewhere that on a large airliner the fuselage exhaust hole for this system is about the size of a basketball.
If you shot a hole through the fuselage wall with a pistol you could probably seal it by slapping one of those magazines from behind the seats over it.... /grin