There for awhile the Explorers had some serious problems including transmission failures. I don't dought it can be hard to find parts.
I knew someone that had one and the transmission failed with less than 50K miles on it.
The V6 and V8 ones used a different transmission, and depending on the year there were I think 2 different trans behind the V6. The early was the A4LD which was not awesome. Later was something else which I honestly know nothing about. V8 models got a 4R70w, same thing used in pickup trucks and Crown Vics. It was fairly tough.
Mostly they don't exist around here because they are 25+ years old and rotted away, or just abused to death. They only got a 5.0 from 96-01, and it was way less common than the V6 engine.
