Skip to content

AD 2009-21-10 R1

Registered aircraft · 4,274

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:2009-21-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1') 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:2009-21-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1')
  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:2009-21-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1')
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.

N195AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5195 N195DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28452 N195FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63125 N195NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 6939 N195PGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 1953 N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899 N195UWAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3633 N196AAWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32390 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 N196UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3879 N1979LCabana Air LLC · Frederick, MDS/N 1480 N197BDAfc Management LLC · Englewood, NJBuilt 1996 · S/N 1284 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 N197UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3928 N198DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28455 N198FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63128 N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098 N198NVAllegiant Air LLC · Las Vegas, NVBuilt 2016 · S/N 7138 N198UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5444 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 N199UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5475 N1BGGlobal Empire Trust LLC · Dover, DEBuilt 2001 · S/N 1436 N1DWac I LLC · Fort Lauderdale, FLBuilt 1992 · S/N 1209 N1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 1534 N1TDThreshold Ventures Inc · Scottsdale, AZBuilt 1990 · S/N 1133 N1TMMarsico Aviation LLC · Denver, COBuilt 2002 · S/N 1490 N200LCSn 1067 LLC · Wilmington, DEBuilt 1988 · S/N 1067 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 N203NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5384 N204NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5166 N204UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 28713 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 N206UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30212 N207AXOmni Planes LLC · Tulsa, OKBuilt 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

Back to AD 2009-21-10 R1