## Lost_Property

ID | Item | FoundAt | Description | Date
--- | --- | --- | --- | ---
1 | Wristwatch | Gate A1 | Silver wristwatch with black leather strap | January 5, 2024
2 | Mobile Phone | Food Court | iPhone X with a cracked screen | December 31, 2023

## Customer_Complaints

ComplaintID | CustomerName | FlightNumber | Issue | Resolution | Date
--- | --- | --- | --- | --- | ---
1 | John Doe | AA123 | Late boarding | Apologized and provided meal voucher | January 5, 2024
2 | Jane Smith | DL456 | Luggage mishandled | Delivered luggage within two hours | December 30, 2023

## Flights

FlightNumber | Airline | DepartureTime | ArrivalTime | OriginAirport | DestinationAirport
--- | --- | --- | --- | --- | ---
AA123 | American Airlines | 08:00 AM | 10:00 AM | LAX | ORD
DL456 | Delta Airlines | 09:00 AM | 11:00 AM | ATL | MCO

## Aircraft

Registration | Model | Manufacturer | YearOfManufacture | SeatCapacity
--- | --- | --- | --- | ---
N123AB | Boeing 737-800 | Boeing | 2010 | 160
N345CD | Airbus A320 | Airbus | 2012 | 180

## Employees

EmployeeID | FirstName | LastName | JobTitle | HireDate
--- | --- | --- | --- | ---
1 | Alice | Smith | Security Officer | October 1, 2022
2 | Bob | Johnson | Pilot | September 1, 2022