Might I direct your attention to a site I haven't seen mentioned much:
IMCDb.org. Like IMDb except with, you know, cars.
Here's the
Supernatural page. Of course we know what the
Metallicar is. But also, according to them,
John's truck is a Chevrolet K-10,
Andy's van is a Dodge Tradesman, and
Rumsfeld's doghouse is a 1968 Ford F-350. Also,
the ghost truck from Route 666 is a 1962 Dodge Somethingoranother,
the semi from Devil's Trap is a Western Star 4964, and they even list the
Hollywood Babylon golf carts.
And:
The
De Lorean.
KITT and
Dwight Schrute's (vomit warning) and how is it that I already knew they were the same car omg. I looked up the original Italian Job because I wondered about the Minis, and
aren't they cute! Also
Mr. Bean's. And
Marie's from The Bourne Identity. The
snowcat from The Shining and
all the street sweepers ever, hee! (Sadly, though, no one has yet identified the Bluths' staircar.) Arthur Weasley's
enchanted Anglia. The
fogged-glass handprint car from Titanic. Mike Damone's
Gremlin. Dale Gribble's
Dead Bug van. And ack, I cannot tear myself away from this site...
ETA: Apparently I wasn't done. The Spaceballs
Winnebago. Boocoodles of
Simpsons cars. The Ice Truck Killer's
ice truck.
Christine. Urkel's
Isetta (no screencap, woe). The Ghostbusters
ambulance. The Griswold family
wagon. The
Spice Harvester.
ETA2: I've come to the conclusion that "boocoodles" ought properly to be spelled "beaucoodles."