This always seemed like the definition of "tight and funky" to me, the snare on "Papa Don't Take No Mess": link
Too lazy to look up who the drummer is. I'm sure the guy who wrote "Give the Drummer Some" would know what size snare this is.
I am totally agreed that a 14" Supraphonic will sound extremely tight and funky, so will a Dynasonic, etc., a 5 or 5.5 deep metal snare (although some wood ones would also work if you can crank the tension high).
However, on the above track, it seems to be a piccolo snare, maybe a 14x3.5 or something?
In any case it's one bad and funky snare sound.
Okay, just looked it up...it's John "Jabo" Starks, recorded Aug. 23, 1973, according to "Give the Drummers Some!" by Jim Payne. However, according to the book's index for that particular song, there is no discussion of the type of snare used.
There's a huge drum forum out there, forget the name right now, that might be a better place to look