Our House - Madness
My Wife - The Who Who’s Next
Just about anything by the Brian Setzer Orchestra, but especially BSO’s version of Rock This Town.
Some Australian classics:
The Saints - Know Your Product (1978) - sneering snotty first generation punk rock with a great horn section part.
The Saints’ guitarist, Ed Kuepper, went on to lead the Laughing Clowns, who had a cult hit with this post punk classic featuring a magnificent sax part from Louise Elliot:
Laughing Clowns - Eternally Yours (1984)
Robert Cray, Nothing But A Woman has some nice saxy parts and a good horny section.
I wouldn’t call it a pop song, but the Supersuckers’ “My Victim” lifts the horns from Otis Redding’s “Try A Little Tenderness”, and that song rocks!
http://www.artistdirect.com/nad/window/media/page/0,,213605-2683609,00.html
(that’s not a full version, and it’s not the part with the horns. Jeez, that’s a tough song to find. No you tube of it, either. A live version will not feature any horns, by the way.)
I’ve always loved the rising horns in the theme to “Jonny Quest.” (Part of why I loved the ending theme to “The Incredibles” so much).
The trumpet bit in “Thrift Shop” by Macklemore really makes the song, at least for me. That, and the line “Damn, that’s a cold-ass honky!”
I also love that song, but more because of the line “this is fucking awesome.”
This is my number 1 pick. Nothing else even compares. No point in even listing a 2nd pick.
Go here for Kenny Chesney’s cover of “Tush” by ZZ Top from their tribute album named Sharp Dressed Men. 
God bless you and Kenny and ZZ Top always!!!
Holly
Otis Redding - Try A Little Tenderness
Rolling Stones - Rocks Off/ Rip This Joint from Exile On Main St
Violent Femmes - I Held Her in My Arms
US3 sampled Herb Alpert in Cantaloop (Flip Fantasia)
Ignorant Mob Jackson’s Jam
From Marquette Michigan
Are you sure it’s Herb Alpert? “Cantaloupe Island” is by Herbie Hancock, and the cornet player doing the main riff is Freddie Hubbard.
Candy Dulfer - Lily Was Here
(saxomophone)
Everything by Cake… specifically War Pigs
Live album: Little Feat Waiting for Columbus backed by the Tower of Power horn section.
If you don’t own this album… well you should get it! Asap! Play it loud and often and thank me later.
I like the horns in “Spinning Wheel” by Blood, Sweat & Tears.
Brick House, The Commodores
That’s The Way (I Like It), KC & The Sunshine Band
The Blues Brothers lifted the horn part from this song and made it their intro music. A great riff.
Other nominees…
“I Got the Blues”-- Stones, on Sticky Fingers
Possibly my favorite all-time horn part is technically just the background during the piano solo in Lynyrd Skynrd, “Call Me the Breeze”. But it’s awesome.