Although you can enter a password to get the Heckler and Koch Mk.23 SOCOM pistol (handgun from the first Metal Gear Solid), you can easily pick one up from underneath the transport truck at Shadow Moses Island's Helipad.