Skip to content

Registered aircraft · 2,912

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.

N196DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28453 N196FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63126 N196NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 6965 N196PASandy Wings LLC · Wilmington, DES/N 321 N197DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28454 N197FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63127 N197NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7063 N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901 N198DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28455 N198FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63128 N198NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7138 N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482 N199ANAersale Inc · Doral, FLBuilt 2001 · S/N 32393 N199DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28456 N199FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63129 N199NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7207 N1XPDuggy Foundation · Page, NDBuilt 1942 · S/N 4733 N2000Global Avionics LLC · Downey, CAS/N 56 N200NVAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33341 N201FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3389 N202ACBank Of Utah Trustee · Salt Lake City, UTS/N 1308 N202FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2008 · S/N 3431 N202NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5440 N202PXZ & L Consulting LLC · Midland, TXS/N 17 N203NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5384 N204NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5166 N205NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5724 N206FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4272 N206NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5289 N207AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30438 N207FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4307 N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638 N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640 N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540 N21108United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27298 N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442 N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498 N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N21723United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28790 N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N219CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24358 N219KABank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B192 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N220MJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-220 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262

Back to AD 74-08-09 R2