Skip to content

Registered aircraft · 3,462

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

N855FEAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0203 N855KMBurnette Consulting Inc · Tallahassee, FLBuilt 2017 · S/N EVO-0080 N856FAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1986 · S/N 856 N856FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0176 N856TCCly Aviation LLC · Bellevue, WABuilt 2010 · S/N 100-0041 N857FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0177 N858FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0178 N858MAMess Aero Inc · Grand Forks, NDBuilt 1997 · S/N 20800262 N859FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0181 N85CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0125 N85DVJohnson Jeffrey L · Fargo, NDBuilt 2016 · S/N 100-0185 N85EVEvo Enterprises LLC · Mcalester, OKBuilt 2014 · S/N EVO-0085 N85FDWileman Bros & Elliott Inc · Cutler, CABuilt 2011 · S/N LJ-2021 N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498 N85LGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N LJ-1487 N85TBCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N LJ-833 N85TKStreamline Aviation LLC · Leawood, KSBuilt 2002 · S/N 4697128 N860AR412 Jw Aviation LLC · Dover, DEBuilt 1990 · S/N 36019 N861FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0183 N861MAAerodynamics Worldwide Inc · Wilmington, DEBuilt 2000 · S/N 208B0825 N861PPIrlbeckbruch Plane LLC · York, NEBuilt 2003 · S/N 510 N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N862FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0184 N863FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0186 N863MAMartinaire Aviation LLC · Addison, TXBuilt 2004 · S/N 208B1049 N864PFSnowghost LLC · Whitefish, MTBuilt 2025 · S/N 100-0354 N864SFAlaska Skypower LLC · Fairbanks, AKBuilt 2000 · S/N 208B0864 N865FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0188 N865MASchuman Carriage Co Ltd · Honolulu, HIBuilt 2002 · S/N 208B0996 N865MGSugair LLC · Corpus Christi, TXBuilt 2012 · S/N 502B-2865 N866FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0189 N866KMMac Aviation LLC · Fargo, NDBuilt 2003 · S/N 528 N867BMMoen Aviation LLC · Plymouth, MNBuilt 2016 · S/N 100-0168 N867FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0191 N867HPCaravan International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0252 N869FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0195 N869JVTailwind & Blue Sky LLC · Sisters, ORBuilt 2015 · S/N 100-0146 N869XATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0869 N86BMEvergreen Flying Service Inc · Dover, DEBuilt 2016 · S/N 100-0189 N86JLAircraft Assembly LLC · Paradise Valley, AZBuilt 2014 · S/N 056 N870A & S Aviation LLC · Chesterfield, MOBuilt 1993 · S/N 607 N870CBRaci Management Company Inc · Ogden, UTBuilt 2005 · S/N 657 N870FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0196 N871FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0198 N872FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0200 N873FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0202 N874FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0205 N874MRLoewen Air LLC · Park River, NDBuilt 2011 · S/N 402B-1239 N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354 N875FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0206

Back to AD 2002-23-13