Boeing

idModelNumber_of_seatsManufacture_yearLastMaintenanceDate
173718020002022-06-01
274740019902021-09-01

Airbus

idModelNumber_of_seatsManufacture_yearLastMaintenanceDate
1A32018020102022-07-01
2A38080020072021-12-01

Flight

idairplaneIddepartureTimearrivalTimedestination
(→ Airbus.id)
112022-08-01 08:00:002022-08-01 12:00:00New York
222022-08-02 09:00:002022-08-02 13:00:00Los Angeles

Pilot

idnamelicenseNumberexperienceYears
1John DoeABC123410
2Jane SmithXYZ789015

Maintenance

idairplaneIdmaintenanceTypedatePerformedtechnicianName
(→ Airbus.id)
11Engine Overhaul2021-05-01Mike Brown
22Landing Gear Repair2021-06-01Lisa Johnson