USSS Agent Frank Horrigan (Clint Eastwood) uses a Smith & Wesson Model 19 at the start of the film to arrest Mendoza (Tobin Bell) and kill his two henchmen. Later on, A Secret Service agent holds a Model 19 on Horrigan before he disarms him.
SIG-Sauer P228
USSS Agents Frank Horrigan (Clint Eastwood) and Al D'Andrea (Dylan McDermott) carry SIG-Sauer P228 pistols as their sidearms in the film, as do all the other Secret Service Agents.
At the start of the film, Mendoza (Tobin Bell) hands Frank Horrigan (Clint Eastwood) a nickel plated Llama III-A to kill Al D'Andrea (Dylan McDermott) after he discovers he is a Secret Service agent. Frank weighs the gun as he approaches and convinces Mendoza he isn't Secret Service by clicking the gun to D'Andrea's head, aware it was in fact empty.
We see John Malkovich's character constructing this two shot, reloadable handgun in the movie. The weapon is used to great effect blowing a toy boat out of the water and killing the two duck hunters mid-way through the flick. Though seen only briefly the weapon appears to take .38 Special rounds. (Looks like .32 S&W cartridges to me.)
When the DC Metropolitan Police attempted to arrest the assassin, the DC ERT officers were armed with Uzi submachine guns with stock extended. Unfortunately, it turned out that the assassin scrambled the trace and lead the Secret Service and the police to a completely different address.The IMI Uzi is also seen when the secret service agents are rushing the president out of the hotel after the assassination attempt (the agents by the kitchen door have them).