Well, military, sure. I hear it from children (who are children now) in certain parts of the country more than others. Like in parts of the South, and perhaps parts of the Northeast....
growing up as a teenager now, born in early 1990s, and living in New England i can't say it is rather common that i or my friends call their Dads 'sir.' but that might have been common ten or so years ago but i can't comment on that