Skip to content

Registered aircraft · 2,916

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.

N91BUBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 5967 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N920FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 325 N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165 N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366 N9218Omega Air Inc · Selma, TXS/N 48218 N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522 N921FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 319 N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229 N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367 N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523 N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574 N922TSAero Micronesia Inc DBA · Barrigada, GUBuilt 1990 · S/N 24845 N922UPBoeing Co · Renton, WABuilt 2026 · S/N 68368 N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524 N923FDFederal Express Corp · Memphis, TNS/N 26266 N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167 N923TRCareer Aviation Co Inc · Wilmington, DES/N 28923 N923UPBoeing Co · Renton, WABuilt 2026 · S/N 68369 N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525 N924FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26267 N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486 N924UPBoeing Co · Renton, WAS/N 68370 N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526 N925FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27238 N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169 N925UPBoeing Co · Renton, WAS/N 70801 N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527 N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321 N926UPBoeing Co · Renton, WAS/N 70802 N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077 N927FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27220 N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171 N927UPBoeing Co · Renton, WAS/N 70803 N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528 N928KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 47928 N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322 N929UPBoeing Co · Renton, WAS/N 70804 N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529 N930CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47363 N930NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33487 N930UPBoeing Co · Renton, WAS/N 70805 N931ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30079 N931BCBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B-187 N931NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33230 N931UPBoeing Co · Renton, WAS/N 70806 N932ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29530 N932CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1970 · S/N 47465

Back to AD 74-08-09 R2