Skip to content

Registered aircraft · 2,913

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3756Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30493 N3757DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30813 N3758YDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30814 N3759Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30815 N375DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29623 N375NCDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1789 N375UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66810 N3760CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30816 N3761RDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29628 N3762YDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30817 N3763DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29629 N3764DDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30818 N3765Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30819 N3766Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30820 N3767Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30821 N3768Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29630 N3769LDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 30822 N376DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29624 N376NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1812 N376UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66811 N37700Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29631 N3771KDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29632 N3772HDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30823 N3773DDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30825 N377DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29625 N377MQAcc Integrated Services Inc · Milwaukee, WIBuilt 1986 · S/N SH3699 N377NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2082 N377UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66812 N378CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27184 N378DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30265 N378MQAir Cargo Carriers LLC · Milwaukee, WIBuilt 1986 · S/N SH3700 N378NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2092 N378UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67920 N379AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25200 N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349 N379UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67968 N380ACUmb Bank Na Trustee · Salt Lake City, UTS/N 3383 N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266 N380UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67969 N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350 N381FLIfl Group Inc · Waterford, MIBuilt 1953 · S/N 276 N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703 N381UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67970 N38257United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30612 N38268United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31587 N382DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30345 N382HTCardinal Services Corp · Kalispell, MTS/N 5032 N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704 N382UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67971 N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346

Back to AD 74-08-09 R2