A nice collection of all available siren sounds in a NYPD police car can be found at the NY Times. The "Air Horn" sound going through a horn loudspeaker should give the typical horn sound of ambulances.