The highest note on record is a G10 sung by Georgia Brown, a Brazilian dance/electric singer. You can hear it here (it's really something!). While a G10 is extreme, many of the coloraturas I know sing up to the 7th octave.