Registered aircraft · 5,443

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

N9256DGonitzke Ross J · Detroit Lakes, MNBuilt 1995 · S/N 2890227 N9257CAcorn Aviation LLC · Saint Charles, ILBuilt 1978 · S/N 28-7890395 N9258CBack Forty Flying Club Inc · Roanoke, INBuilt 1995 · S/N 2843002 N9258NKma Aircraft Dream LLC · Osteen, FLBuilt 1995 · S/N 28-43014 N925PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843288 N92605Sarratt Curtis H · Annapolis, MDS/N 2844002 N9260TCanoace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8616033 N9262CRick Aviation Inc · Newport News, VABuilt 1978 · S/N 28R-7837183 N9263LSkyhawk Flying Club Inc · Franklin Grove, ILBuilt 1996 · S/N 2843023 N9265PWard Benny · Raleigh, NCS/N 2843024 N9266KRestrepo Aircraft Corp · Fort Lauderdale, FLBuilt 1996 · S/N 2844004 N9269GLauterbach Dean C · Newton, IABuilt 1996 · S/N 2843021 N9269QAero-Tech Services Inc · Lititz, PABuilt 1996 · S/N 2843031 N926CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 2881040 N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327 N926PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843289 N9270BKenneson Jack A · Clarion, PABuilt 1996 · S/N 2843032 N9272LValira Aviation II LLC · Oakland, CABuilt 1997 · S/N 2843077 N9274NOkuda Hideki · Rncho Pls Vrd, CABuilt 1996 · S/N 2844008 N9274YFlight Club 502 Inc · Louisville, KYBuilt 1985 · S/N 28-8616020 N9276CRegistration Pending · Kissimmee, FLRegistration pendingBuilt 1978 · S/N 28-7816454 N9277DBird Acquisition LLC · Phoenix, AZBuilt 1996 · S/N 2843047 N9279JAndromeda Air LLC · Houston, TXBuilt 1997 · S/N 2843068 N927GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881075 N927PADuncan Michael J · Danville, VABuilt 1977 · S/N 28-7716082 N9280AApm Leasing LLC · Casper, WYBuilt 1985 · S/N 28-8616040 N9282CRegistration Pending · Augusta, KSRegistration pendingBuilt 1978 · S/N 28-7816455 N9284AGriffith Nathan · Boston, MABuilt 1985 · S/N 28-8616041 N9284MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1985 · S/N 28-8616042 N9285CSunset Flights LLC · Azusa, CABuilt 1978 · S/N 28-7890396 N9285GRockafellow Air LLC · Lubbock, TXS/N 2843073 N9285M5 M Leasing LLC · Englewood, COBuilt 1985 · S/N 28-8616043 N9286MWiley Aviation LLC · Murfreesboro, ARBuilt 1985 · S/N 28-8616044 N9287ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 1997 · S/N 2842019 N9288KCoug Air LLC · Oregon City, ORBuilt 1976 · S/N 28-7690240 N9289CSmallwood Chadwick D · Newnan, GABuilt 1978 · S/N 28-7890397 N928BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881767 N928PPSwair LLC · Denver, COS/N 2843298 N928TAPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116180 N928WAChapman Martha P · Rogersville, TNBuilt 1976 · S/N 28-7790142 N9290CMym Air LLC · Pattison, TXBuilt 1978 · S/N 28R-7837184 N9290NFlight Vision 1 LLC · Lake Mary, FLBuilt 1997 · S/N 2843108 N9290UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020281 N9293BCludy Skies LLC · Wildwood, MOBuilt 1997 · S/N 2843100 N9294QPlane Training LLC · Rapid City, SDBuilt 1998 · S/N 2843122 N9297QTequila Sunrise LLC · Anniston, ALBuilt 1997 · S/N 2843097 N9298JSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1997 · S/N 2843107 N9299BBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843116 N929AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843803 N929PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843299

Back to AD 2016-07-21