Hi Jeff,
Here are my thoughts on this problem. What if the database had a Reservations table that held the Flight#, date and Seat# for those seats that were already reserved? Then you only need to retrieve the seat numbers for that equipment type for that flight on that day that re not in the Reservations table. Or we can retrieve that info. from the stored itineraries since we have to persist them anyway.