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.

N383MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3706 N383UPCc & Ei LLC · Louisville, KYBuilt 2023 · S/N 67972 N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347 N384UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67973 N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348 N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707 N385UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67974 N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373 N386UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67975 N38727United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28797 N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374 N387UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67976 N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375 N388HGBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 5956 N388MMAc Travel LLC · Palm Beach, FLBuilt 1986 · S/N 490 N388UPC.C. & E.I LLC · Louisville, KYBuilt 2025 · S/N 67977 N389AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 26915 N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376 N389UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67978 N390CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32973 N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536 N390UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67979 N391CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32975 N391DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30560 N391FLIfl Group Inc · Waterford, MIBuilt 1955 · S/N 278 N391RCIal Corp · Lewes, DES/N SH3665 N391UPCargo Aircraft Management Inc · Wilmington, OHS/N 28039 N39297United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34003 N392DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30561 N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041 N393DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30377 N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228 N394DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30562 N394UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25136 N395AWIntercoastal Aviation · Fort Lauderdale, FLBuilt 1997 · S/N 549 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773 N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378 N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364 N39726United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28796 N39728United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28944 N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537 N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363 N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988 N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774 N399CLBeta Fleet LLC · South Burlington, VTBuilt 1996 · S/N 340B-399

Back to AD 74-08-09 R2