NYPD Detective's Javier Esposito (Jon Huertas) and Kevin Ryan (Seamus Dever) use a Glock 17 as their primary sidearms throughout the series. Detective Kate Beckett (Stana Katic) uses one until "Home is Where the Heart Stops" (S1E07).
Glock 19
Detective Kate Beckett (Stana Katic) starts carrying the more compact Glock 19 during the events of "Home is Where the Heart Stops" (S1E07). Castle (Nathan Fillion) also uses Kate's while at the range, pretending to be completely inexperienced, then showing extreme proficiency after he's offered crime scene photos. Det. Tom Demming (Michael Trucco) also carries one.
Glock 26
A Glock 26 serves as Det. Beckett's backup gun, it's most notably seen when she hands it to Castle to defend himself from the "Tick, Tick, Tick..." & "Boom!" killer when they enter the warehouse he's hiding in. He uses it to shoot Kate's Glock 19 out of the killers hand. After wards Castle reveals that "he was aiming for his head".
Noteworthy is that his "Aiming for the head" remark is the third Firefly/Serenity reference in the series. The first two took place during the episode "Vampire Weekend" when Castle wore his Mal costume, and the second was a catalyst sitting on his bookshelf. A catalyst is required for any Firefly class ship to run, and was a large part of Out of Gas' story arc.
M1911
In "The Third Man" (S2E14), Noel du Preez (Michael Enright) uses a compensated M1911-type to shoot at the team when he thinks they're robbers stealing from his store. Former NYPD officer, and Esposito's former partner Ike Thornton (Aaron D. Spears) is seen with a 1911 during in "Den of Thieves" (S2E21), off camera Esposito uses it to wound dirty IA Lt. Holliwell. A 1911 is found to be the murder weapon in Season 3's premiere "A Deadly Affair" (S3E01).
Safari Arms Matchmaster 5
A murder suspect named Roland D'Andre (Randal Reeder) is found to have a [Safari Arms Matchmaster]] 5 on him in "Punked" (S3E04).
Heckler & Koch USP
A two-tone Heckler & Koch USP was used by the killer to threaten Castle, then by Beckett after she disarms him in "Deep in Death" (S2E01).
Jericho 941 R
Earl (Craig Gellis) is seen using a stainless Jericho 941 R to fire on Castle and company in "A Deadly Affair" (S3E01).
Ruger P90
The killer uses a Ruger P90 during his activities in "Boom!" (S2E18). FBI Special Agent Jordan Shaw (Dana Delany) briefly uses it near the end of the same episode.
SIG-Sauer P226
NYPD officers are occasionally carrying the SIG-Sauer P226 (in reality, this weapon is not authorized by the NYPD to carry onduty). After disarming an officer, Rathborne holds Castle hostage with one in "Sucker Punch" (S2E13).
SIG-Sauer P232
In "Under the Gun" (S3E03), Gayle Carver (Sophina Brown) is seen wielding this gun during a confrontation between the detectives Mike Royce (Jason Beghe) and Clifford Stuckey (James Handy).
SIG Pro SP 2009
Jack Coonan (Justin Alvarez) had a 9mm SIG Pro in his waistband when he was killed in "Sucker Punch" (S2E13).
Harrison Tisdale (Brian Avers) uses a stainless Star Firestar M-43 in the series premiere "Flowers for Your Grave" (S1E01).
STI 2011 Edge
An STI Edge is seen being handled by Ben Conrad, then used by Scott Dunn (Dameon Clarke) to execute him off camera in "Tick, Tick, Tick" (S2E17).
Walther PP
Scarlett Price (Michaela McManus) used this pistol in "Love Me Dead".
Walther PPK
IA Lt. Stan Holliwell (Scott Cohen) uses a suppressed PPK near the end of the episode "Den of Thieves".
Desert Eagle
One of Hal Lockwood's men uses a Desert Eagle to attempt to shoot out one of Ryan's kneecaps in "Knockdown" (S3E13).
Bond Arms Snake Slayer IV
Montgomery uses a Bond Arms Snake Slayer IV Derringer as his holdout weapon during his confrontation with Lockwood in Season 3's finale "Knockout" (S3E24). It is the IV version of the Snake Slayer as noted by its longer barrel, and although normally chambered in .45 this pistol appears to use the .38/.357 barrel, as Montgomery loads it with the same rimmed rounds he uses in his revolver.
Smith & Wesson SW1911
A stainless steel Smith & Wesson SW1911 can be seen in "Cops and Robbers" (Season 4, Episode 7).
Montgomery uses this revolver during his last stand against Lockwood.
Semi-automatic .22 Pistol
While searching Kyle Cabot's apartment in the pilot, Esposito finds this compact pistol. Could be a Jennings J-22.
Stainless Snubnose Revolver
Castle is seen holding a snubnose revolver as Beckett, Ryan & Esposito clear a murder victims apartment.
Antique Revolvers
Castle is seen wielding one while bursting through his front door and catching his daughter snogging her boyfriend. Irwin Finkelstein is seen holding two antique revolvers in pictures on a antique firearms social networking page.
Flintlock Pistols
In Punked, Daniel Goldstein and Adam Murphy are found to have each used flintlock pistols in a duel to impress a woman. Later, while trying to determine whether to charge Adam with murder or manslaughter, they hilariously succeed at hitting everything in the range but the targets. After several failed attempts, Castle uses duct tape to attach a scope, and laser sight in a last ditch attempt to hit the target. Other models are also seen being held by Ivan Podofski (Muse Watson) in photos on a antique firearms social networking page.
Nail Gun
Detectives arrive at the crime scene to find a female victim with multiple flat-head nails protruding from her skull. Behind a nearby chair they find a nail gun. It appears to be a cosmetically altered KitPro series judging by the shape of the butt, housing assembly (screws pointing aft), housing vents on the side and top, and the 'over/under' 'muzzle'. I think the 'over' is a nail depth gauge.
Submachine Guns
Heckler & Koch MP5A4
An MP5A4 with a weapon light, and Navy trigger group was used by a drug dealer while stealing a victims body in the season 2 premiere, "Deep in Death".
Heckler & Koch MP5K
During the events of "A Deadly Game", an MP5K is found in Roger Farraday's (Dean Cates) car. It was issued to him as part of a "spycation" where Farraday, under the guise of CIA hitman Sean Caldwell, was supposed to "assassinate" a foreign minister with it.
Assault Rifles
Heckler & Koch HK416
While not clearly seen, several FBI HRT agents use HK416's with 10" barrels.
M4A1
Esposito (Jon Huertas), as well as most NYPD ESU officers use M4A1's when needed. FBI HRT agents can be seen wielding both M4A1's and HK416's during the episodes "Tick, Tick, Tick..." & "Boom!".
MGC M16A1 Replica
Esposito (Jon Huertas) is seen with one during Castle's Halloween party, dressed up as his Generation Kill alter-ego Sgt. Antonio Espera.
Shotguns
Remington 870
Esposito (Jon Huertas) uses a Remington 870 on multiple occasions throughout the season. In Sucker Punch, the victim Jack Coonan (Justin Alvarez) had one loaded with hollow point slugs in his apartment.
Mossberg 500AT Shotgun
Mike Royce (Jason Beghe) is seen wielding what appears to be a Mossberg 500AT shotgun during a confrontation between the detectives, Gayle Carver (Sophina Brown) and Clifford Stuckey (James Handy).
Hal Lockwood (Max Martini) uses a suppressed Mk 14 EBR kill John Raglan, and later attempts to kill Beckett with it. It appears to have a Harris bipod and AN/PEQ-2/5. It is supposedly chambered in .338, despite the round being much too large for fit the 7.62x51mm chamber.
Knight's Armament SR-25
A Knight's Armament SR-25 can be seen in "Rise". It is recovered after the attempted assassination attempt on Becket. Esposito refers to it as a Mk 11, which is correct as this particular rifle was a Navy SEAL issue weapon.
Remington 700 AICS
A Remington Model 700 AICS fitted with a suppressor and a Harris bipod is used in "Kill Shot" loaded with 165 grain .308 Winchester ammo.