A service of the always great TripAdvisor.com, SeatGuru has a hell of a mission statement:
"In October 2001 frequent flyer Matthew Daimler launched SeatGuru.com with a single color-coded interactive airplane seating chart. Having realized the vast differences between airline seats, he was determined to build a repository of this useful information and share it with other travelers. Over ten million visitors later, SeatGuru has enjoyed incredible success and has expanded to over 275 airplane seatmaps from over 40 different airlines."
With it, I was able to book seats for an upcoming Texas trip on American Airlines, avoiding the "Poor Seats" and "Be Aware" seats with complete confidence. Interestingly, even some of the First Class seats on my flight were marked to "Be Aware." Thanks, SeatGuru!