Here is a link to the Supernatural Music Guide on Supernatural.TV link It has Seasons 1-4 and lists the music played in each episode. I think the S4 listahan is incomplete but I'm sure they'll finish it eventually.
My paborito ones in the ipakita are carry on my wayward son-Kansas (all seasons) You Shook Me-AC/DC (Season 4) Lonely Is The Night-Billy Squire (Season 4) In A Gadda La Vida- Iron paruparo (Season 1 haha old I know but I pag-ibig that song) Crystal Ship-The Doors (Season 2)
And none of these songs could be played with out the Metallicar.