What is the answer to 'Large number upset after US detective produces weapon'?

Question

Accepted Answer

The answer is PISTOL. The definition is 'weapon'.