Concerthotels.com developed this great chart on the vocal ranges of some of the world’s most well-known vocalists. It’s an interactive chart, so when you hover over a singer, it will tell you the highest and lowest note and attribute it to a song. You can also find who has the highest and lowest range as well by selecting the sort button at the top.
I think it’s interesting that Axel Rose holds the record (according to the chart, anyway) for both the highest and lowest note for males, while less surprisingly, Mariah Carey holds it for females.