Currently, I live in SW Missouri. It definitely gets hot here, but my car has always been the one only I drive, and the wife's car is the one with AC. I bought this Pilot specifically to use as a traveling car for us and 3-4 kids, so now that it's warming up again I need to make it cool inside. I won't mind driving a car with AC though, don't get me wrong.
I haven't specifically diagnosed the compressor as being faulty, but I've replaced all the fuses and relays for the AC system and the compressor still won't kick on. Whether the R-134a in the system is good or not I couldn't tell you, but the system maintains pressure. There aren't too many things it can be at this point, so I'm replacing the compressor, the expansion valves, and the drier dessicant and fittings. We're going to blow out the lines and the condenser, so any debris should be gone for the most part. I don't think the compressor blew up or anything, it spins freely and makes no noise or anything. Once we recharge the system, if it still doesn't kick on, I think there might be one or two more things to check, but I'd be surprised if that doesn't fix it.
I kinda debated this before (on these forums, btw) and decided that I'd pretty much just go ahead and replace the bulk of the system due to the 2006 having over 200k miles on it. If it's good now, it might still crap out in another month and I'd have to replace the parts anyway. I kinda see it like the timing belt...might as well just go ahead and make sure. Hopefully it will last a good long time after I fix it.