Why the Red Delicious No Longer Is (2005)

Orange Pippin (http://www.orangepippin.com/) has a ridonkulous amount of info on other apple varieties.

Among the commonly available types, my favorites are Honeycrisp and Pink Lady.