The following firearms were used in the film Super Troopers:
All of the Vermont State Police troopers, including Rod Farva (Kevin Heffernan) and Capt. John O'Hagen (Brian Cox) use Glock 17s. The Spurbury Police, including Grady (Daniel von Bargen), Ursula (Marisa Coughlan), and later Farva, also use Glock 17s. This is unrealistic, as the actual Vermont State Police Department issues its officers SIG-Sauer P229s chambered for the .40 S&W cartridge and are switching to the Smith & Wesson M&P, also chambered in .40 S&W.
Each police force uses a Remington 870 shotgun, seen in the hands of Farva, Ursula, and a town official. Note that the magazine tube on all the 870s in the film are stainless, indicating the same gun was used for all scenes due to budget constraints.
Marksman Repeater BB gun
When Spurbury police captain Grady draws his pistol inside the trailer, it appears to be a Marksman Repeater BB pistol, possibly a Marksman 1020.