Lost_Property

IDItemFoundAtDescriptionDate
1WristwatchGate A1Silver wristwatch with black leather strapJanuary 5, 2024
2Mobile PhoneFood CourtiPhone X with a cracked screenDecember 31, 2023

Customer_Complaints

ComplaintIDCustomerNameFlightNumberIssueResolutionDate
1John DoeAA123Late boardingApologized and provided meal voucherJanuary 5, 2024
2Jane SmithDL456Luggage mishandledDelivered luggage within two hoursDecember 30, 2023

Flights

FlightNumberAirlineDepartureTimeArrivalTimeOriginAirportDestinationAirport
AA123American Airlines08:00 AM10:00 AMLAXORD
DL456Delta Airlines09:00 AM11:00 AMATLMCO

Aircraft

RegistrationModelManufacturerYearOfManufactureSeatCapacity
N123ABBoeing 737-800Boeing2010160
N345CDAirbus A320Airbus2012180

Employees

EmployeeIDFirstNameLastNameJobTitleHireDate
1AliceSmithSecurity OfficerOctober 1, 2022
2BobJohnsonPilotSeptember 1, 2022