I thought this topic would turn into a whining match, but this is FUN!
Kirk -- "The early morning stoned pimp is here." Gotta be the gold-colored titanium oxide .50AE Desert Eagle Mark XIX, with a chrome plated Walther PPK in 7.65mm "with delivery like a brick through a window." for backup (for no bulge in the gold-trimmed dress uniform...alien babes notwithstanding)
Spock -- Glock 22. It has no redeeming features except that it works.
Scotty -- Tricked out 1911 that he built himself from bare metal forgings. Mixed the alloys and polymers himself. Sold the rights to Wilson Combat as the KZ-45.
Chekov -- Two Red Army-issue PM Markovs!
Sulu -- Nobody in their right mind would use Japanese WWII firearms if they had a choice. He's seen the meaning of firepower from the helm position, so...Smith&Wesson Model 29.
Uhura -- Kahr K9 in polished stainless steel (hey, she likes New Shaft!)
Bones -- .45LC pepperbox derringer.
Picard -- Classy and history-conscious, Jean-Luc carries an early-production Browning High-Power, a.k.a. "Grand Pussiance" complete with original holster stock and elevation-adjustable sights.
Riker -- A pimp wanna-be. Chrome-plated Beretta .25ACP.
Worf -- You are all wrong. He would carry a Magnum Resarch BFR in .45-70, with a Colt 3rd Model Dragoon for concealed carry.
Troi -- She would carry two hot 38's...I am referring, of course, to two S&W Ti AirLites in .38 Special +P. Perverts!!!
Dr. Crusher -- Too much of a mewling pacifist to carry a firearm. At least Bones uses harsh language!
Wesley -- Special Edition Red Ryder BB gun that Borg gave him without mom knowing about it. "We will make you a warrior yet!"