I’ve planted Honeycrisp and Cortland in my orchard, and they do really well in our zone. Honeycrisp is especially a hit with the deer in late September. Winecrisp is also a great choice for extending your drop season into November.

I'd avoid Yellow Transparent if you want late drops. Fireside and Winecrisp should give you good coverage from September through November. Maybe try a mix to see what the deer prefer?