Skip to content

Registered aircraft · 784

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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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.

N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667 N148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N FM-12 N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592 N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023 N151QDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-59 N154KFRegistered aircraftBuilt 2016 · S/N FL-1054 N156LAFresno Beverage Co Inc DBA · Fresno, CABuilt 2018 · S/N FL-1153 N156TMWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N FL-518 N15WCDakota Aviation LLC · Santa Ana, CABuilt 2016 · S/N FL-1063 N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226 N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215 N161VDepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N FM-52 N162GDepartment Of Homeland Security · Washington, DCBuilt 2017 · S/N FM-72 N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165 N166CLKa Partners LLC · Thomson, GABuilt 2000 · S/N FL-298 N167CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N FM-86 N173BDept Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-84 N173MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1151 N175PLTp Air LLC · Laredo, TXBuilt 2019 · S/N FL-1187 N177GATippen Steel Services Inc · Boyd, TXBuilt 1997 · S/N FL-160 N179WBShaken Aviation LLC · Madison, ALBuilt 2011 · S/N FL-773 N17CELdc Air LLC · Rochester, NYS/N FL120 N17GGJ Aviation LLC · Boca Raton, FLBuilt 2004 · S/N FL-419 N17WCHm Aviation Holdings LLC · Fort Pierce, FLBuilt 1997 · S/N FL-168 N17YLYowell Legacy Aviation LLC · Killeen, TXBuilt 1990 · S/N FL-1 N1867State Of Alaska · Anchorage, AKS/N FL-815 N187VDepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N FL-679 N188KAErostar LLC · Wilmington, NCBuilt 2024 · S/N FL-1333 N189MDCae III Ltd · Wilmington, DEBuilt 2014 · S/N FL-931 N1923TTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N FL-1266 N192FDepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N FL-770 N193RAWilmington Trust Co Trustee · Wilmington, DEBuilt 1993 · S/N FL105 N195CAJp Aero LLC · Dayton, OHBuilt 2003 · S/N FL-364 N196BDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-79 N198AGAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2015 · S/N FL-1005 N199YMicnic King Air LLC · Port Richey, FLBuilt 1991 · S/N FL66 N1SCState Of South Carolina · West Columbia, SCBuilt 2018 · S/N FL-1130 N1TRTrinity River Authority Of Texas · Arlington, TXBuilt 2013 · S/N FL-876 N1VACommmonwealth Of Virginia · Richmond, VABuilt 2007 · S/N FL-549 N1WVState Of West Virginia · Charleston, WVBuilt 2007 · S/N FL-527 N204MBGreen Top LLC · Reidsville, GABuilt 2015 · S/N FL-1022 N204WState Of Wisconsin · Madison, WIBuilt 1998 · S/N FL-204 N20ERN20er LLC · Snellville, GABuilt 2011 · S/N FL-778 N20EWTriple H Aviation LLC · Milton, WVS/N FL-260 N210EXUnited States Navy · Patuxent River, MDS/N FL-388 N2112VRegistered aircraftS/N FL-501 N214ML1st Franklin Financial Corp · Toccoa, GAS/N FL-475 N217USDavis Aviation Inc · Brandon, MSBuilt 2007 · S/N FL-519 N218QDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-62 N219BSG Force Air LLC · Las Vegas, NVS/N FL-411

Back to AD 91-20-14 R1