The following firearms were used in the film Super Troopers:
Glock 17
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 equips its officers with SIG P229's chambered for the 40S&W cartridge.
Remington 870
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.
Someone said it was a Marksman 1020, but don't quote me on that. - Gunmaster45