I think it is pretty tough to get a really accurate picture of that. Because resale is actually a derived from a % of purchase price you need to know what was paid for it. Cruising Machinery Trader will give you an idea of what asking price for machines are and that has some but perhaps limited value since you don't know what the sale price is. Auction results are if helpful but condition especially on compact equipment is a big driver into what something brings. Lastly a machines reputation good or bad does often not reflect the current status of a machine. An example would be The Kubota 95-2. The first series was pretty well received, the newest version is not so much. Continued emission issues as well as incompetent dealer service have changed a lot of minds in a negative way. So I am not sure what your goal is, but the information you get back will likely be problematic. I think it is better to look at it like this, a new machine regardless of color will cost you 18% of purchase price in the first year/500 hours in depreciation. I made up the number but I think it is likely pretty close. As to what machines run well and what doesn't, pick your used machine and visit the dealer that works on them, talk to the service manager and mechanics, get on the net and seek feedback and when you see a machine working, stop and talk to them if possible. You can learn a lot from the guy that runs it everyday.