This handy tool compares the 5000 most common surnames in the US in 1990 and 2000. And Hispanic names are becoming more and more common (though nobody is going to challenge Smith any time soon).
My last name is surprisingly common, considering how many people mispronounce it. It’s moving up the ranks, from the 400 range to the 300 range. My siblings are doing their part on that score.