I found this website while doing some research on airhorns. It has some general information on a partucular horn’s use on a particular prototype railroad, and includes sound samples of various different horns.
http://atsf.railfan.net/airhorns/index.html
This kind of information might be useful to someone superdetailing a diesel and/or trying to select the right horn sound on a sound decoder.