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.
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.