Great resource for NC (and SC) siren hunting

[JasonC]

http://fdmaps.com/

Most (but certainly not all) sirens in NC are fire sirens, so this helps out a ton whether hunting for real or just using Street View. Enjoy!

Also, for SC hunters, While not as good as the site above, this can be helpful as well:
http://www.carolinasfirepage.com/members/sc_ctys.html

[Batman]

Good stuff. You can also usually find fire district maps by county, which often have station locations on them. That's my primary method of finding sirens, since most east coast sirens are found at fire stations.

[JasonC]

Here is an official list for SC including addresses and coordinates: https://www.state.sc.us/forest/scfirestations.pdf