In Supernatural Season 6, Episode 4, "The French Mistake," the song playing while Bobby Singer (Jim Beaver) drives is "Long Black Train" by The Kentucky Headhunters. The track appears on their 1989 self-titled album and the compilation Pickin' on Nashville.
The episode is a meta-fictional romp where Sam and Dean are transported to "our world," where they are actors Jared Padalecki and Jensen Ackles. Bobby, however, remains in the show's reality—driving his truck, grounded, a tether to the supernatural world. The Southern rock/country vibe of "Long Black Train" fits Bobby's hunter/trucker aesthetic perfectly: gritty, weary, and unshakable.