Seat Guru usually shows you pretty accurately which rows are missing windows. But, if you forget to check it can be pretty annoying to expect a window seat and get the wonderful view of the wall. I like looking out the windows and always try to book them on short haul flights. Delta really fails on their CR9s with the misaligned windows