It is a Whelen dual tone unit, unsure of which model, but I believe any of their units with programmable tones will produce that. Here is a video showing the airhorn from your video:
Unfortunately, I do not know what they name that particular airhorn tone