I believe the scene you are talking about is when they are at the filling station. It is about 17 minutos and 40 segundos into the pilot episode. It is when Sam is chastising Dean about his Cassette Tape collection. Sam calls the collection "The Greatest Hits of Mullet Rock." Hehe. Anyway Dean picks up a tape case that says metallica on it and puts the Tape in. This makes you think that the band is Metallica, but the song actually playing is "Back in Black" por AC/DC. It is an error I noticed after I watched the episode several times. On the clip I have attached the section in perguntas starts at 8.15 if you would like to see it.
Back in Black por AC/DC gotta amor them one of the best rock bands of all time. Well to me. I think it is. there is also in "Pilot" another AC/DC song near the end of the epiosde called Highway to Hell.
I don't know off the topo, início of my head but if you go to: www.supernatural.tv you can click on an episode and the name all of the songs played in that episode. It's really cool. Pluse they have a bunch of pictures.
If you go back and watch the Pilot episode on Netflix and turn on subtitles it says the song name and artist. It's "A Gift to The World" por Lovless. I tried figuring this out for ages and then my mom started watching it from the beginning and she watches with subtitles and I saw it, looked it up and it was the actual thing.