Skip to content

Registered aircraft · 1,335

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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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.

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 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 N377ACBank Of Utah Trustee · Salt Lake City, UTS/N E2346 N377DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29625 N378DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30265 N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349 N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309 N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266 N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350 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 N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346 N383ECAeronave Corp · Kalispell, MTBuilt 2007 · S/N C-177 N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322 N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347 N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348 N385RSAeronave Corp · Kalispell, MTBuilt 1991 · S/N C-042 N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373 N38727United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28797 N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374 N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281 N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375 N388MMAc Travel LLC · Palm Beach, FLBuilt 1986 · S/N 490 N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376 N38TVLs Mobile LLC · Weatherford, TXBuilt 1988 · S/N 37 N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536 N391DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30560 N39297United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34003 N392DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30561 N393DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30377 N394DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30562 N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773 N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228 N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378 N396JR396jr LLC · Macon, GABuilt 2005 · S/N 341 N39726United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28796 N39728United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28944 N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537

Back to AD 99-23-22 R2