## Airports

id | Name | IATA_Code | ICAA_Code | Latitude | Longitude | Elevation | Timezone | Direction_Indicator | Surface_Area | Movement_Area | Runway_Length | City | State | Phone_Number | Website | Email | Year_Established
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | John F Kennedy International Airport | JFK | N7988 | -73.6954 | -40.6452 | 13 | -5 | R | 1627.4 | 1627.4 | 3147.0 | New York | Queens | +1-800-222-1222 | https://www.jfkairport.com/ | info@jfkairport.com | 1943
2 | Los Angeles International Airport | LAX | LACI | -118.4053 | 33.9435 | 279 | -8 | W | 2560.0 | 2560.0 | 9899.0 | Los Angeles | Los Angeles County | +1-855-463-5252 | https://www.flylax.com/ | information@flylax.com | 1937

## Flights

Flight_ID | Origin_Airport | Destination_Airport | Departure_Time | Arrival_Time | Carrier_Airlines | Aircraft_Type | Number_of_Passengers | Flight_Status | Gate_Number
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | JFK | LAX | 2023-01-01 08:00:00 | 2023-01-01 11:00:00 | American Airlines | Boeing 787 Dreamliner | 250 | On Time | 10
2 | Dallas/Fort Worth International Airport | Heathrow Airport | 2023-01-02 14:00:00 | 2023-01-02 19:00:00 | British Airways | Boeing 747 Jumbo Jet | 300 | On Time | 15

## Pilots

Pilot_Id | FirstName | LastName | License_Number | Date_Of_Birth | Total_Flight_Hours | Rating | Current_Assignment | Hire_Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
1 | John | Smith | ABCD1234 | 1985-06-15 | 5000 | ATP | Captain | 2015-01-01
2 | Jane | Doe | EFGH5678 | 1990-09-20 | 4000 | ATP | Co-pilot | 2018-01-01

## Passengers

Passenger_Id | FirstName | LastName | Date_Of_Birth | Nationality | Passport_Number | Contact_Phone_Number | Seat_Preference | Special_Assistance
--- | --- | --- | --- | --- | --- | --- | --- | ---
1 | Alice | Johnson | 1985-07-25 | USA | US123456789 | +1-555-123-4567 | Window | 0
2 | Bob | Williams | 1990-03-10 | UK | GB987654321 | +44-777-123-4567 | Aisle | 1

## Baggage

Bag_Id | Flight_Id | Owner_FirstName | Owner_LastName | Size_Inches | Weight_Kgs | Description | Status
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Flights.Flight_Id) |  |  |  |  |  |
1 | 1 | John | Smith | 22x15x10 | 10.0 | Business suit and laptop | Checked
2 | 2 | Jane | Doe | 21x14x9 | 8.0 | Personal items and toiletries | Carry on

## Aircrafts

Aircraft_Id | Model_Name | Manufacturer | Registration_Mark | Type | Capacity | Range_Miles | Maximum_Speed | Cruise_Speed | Service_Ceiling | Operator_Id
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  |  |  |  | (→ Airlines.Airline_Id)
1 | Boeing 787-8 | Boeing | N123BA | Passenger | 265 | 7000 | 0.85 | 0.8 | 41000 | 1
2 | Airbus A320neo | Airbus | F-HSEZ | Passenger | 180 | 3100 | 0.85 | 0.8 | 43000 | 2