Registered aircraft · 77

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

N12NTNovember Tango LLC · Ketchum, IDBuilt 2005 · S/N LIV-566 N151PKN63e LLC · Fallon, NVBuilt 2008 · S/N 028 N166CFCarlson Farms Inc · Plentywood, MTBuilt 2018 · S/N H80-215 N171MKBulldog Aero LLC · Kalispell, MTBuilt 2009 · S/N LIV-562 N173JDiemert Flying LLC · Roseburg, ORBuilt 2021 · S/N LIV-574 N193CGLeading Edge Air LLC · Highlands Ranch, COBuilt 2009 · S/N LIV-487 N212JCMatrix Sea Air And Land Brokerage LLC · Hypoluxo, FLS/N 045 N293RGVintage Aero Collection Inc · Wilmington, DEBuilt 2006 · S/N LIV-269 N3025ZDirrheimer Maximo Hernan · Flora, ILBuilt 2013 · S/N H80-115 N3037RDavidson Richard E · Tchula, MSBuilt 2013 · S/N H80-123 N30454Registered aircraftBuilt 2013 · S/N H80-138 N3062DDewitt Flying LLC · Morven, GABuilt 2012 · S/N H80-114 N318SWSciara Flying Service LLC · Eudora, ARBuilt 2018 · S/N H80-216 N331BKWtpi Services LLC · Blue Mounds, WIBuilt 2015 · S/N H80-177 N357AVVasenden Arnold · Midlothian, TXBuilt 2020 · S/N 9205 N3644YRainbow Sports Inc · Enid, OKBuilt 2005 · S/N LIV-554 N3WQSymbiotic Assets LLC · Winnemucca, NVBuilt 2004 · S/N 048SS52728 N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813 N401NEBender Jace Edwin Fredrick · Humphrey, NEBuilt 1994 · S/N 401B0960 N476EAMid Continent Aircraft Corp · Hayti, MOBuilt 2016 · S/N H80-190 N486EAKamikaze Air LLC · Lake Mary, FLBuilt 2016 · S/N 115 N509DSJohnson Lynn L · Grafton, NDBuilt 2012 · S/N H80-110 N510HHJohnson Lynn L · Grafton, NDBuilt 2018 · S/N H80-218 N510KKKingsley Kiman J · Miller, MOBuilt 2015 · S/N H80178DC N511DSDirrheimer Maximo Hernan · Katy, TXBuilt 2015 · S/N H80-176 N51AROlsem Aerial Application Services LLC · Westbrook, MNBuilt 1970 · S/N 1523R N532NCDiscover Resources LLC · Norman, OKBuilt 2003 · S/N LIV-532 N54XESaxe Michael · College Station, TXBuilt 2025 · S/N L-IV-PT-511 N5538PAerial Crop Care Co · Hebron, NDBuilt 2017 · S/N H80-197 N555XTTriple Five Air LLC · Sioux Falls, SDBuilt 2013 · S/N LIV-324 N598RMRoofmasters LLC · Wilmington, DEBuilt 2007 · S/N LIV-598 N5UCR V Stich Construction Inc · Richmond, CABuilt 2004 · S/N LIV-524 N601PFPernell Andrew B · Meridian, IDBuilt 2004 · S/N LIV-503 N609HSCrop Duster Kings LLC · Hutchinson, MNBuilt 2018 · S/N H80-221DC N6116AGollott Dale A · Biloxi, MSBuilt 2001 · S/N 008237 N619LFRcl Farms Leasing LLC · Wilmington, DEBuilt 2019 · S/N H80-230 N6204MDuck Hill Air Service LLC · Grenada, MSBuilt 2014 · S/N H80-145 N6211HLowry Flying Service Inc · Grinnell, IABuilt 2015 · S/N H80-168 N62135Hohl Enterprises LLC · Donnellson, IABuilt 2015 · S/N H80-165 N6214FHaynes Flying Service LLC · Forrest City, ARBuilt 2015 · S/N H80-175DC N6216DHound Dog Enterprises LLC · Terre Haute, INS/N H80-181 N6216KHound Dog Enterprises LLC · Terre Haute, INBuilt 2016 · S/N H80-182 N6216UThrush Aircraft LLC · Albany, GABuilt 2017 · S/N H80-192 N63EAvag Inc · Richvale, CABuilt 1977 · S/N 305B N661CMBristol Bay Capital Partners Inc · King Salmon, AKS/N LIV-538 N666EXSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N BUEX0001 N682KALott Dalton Leon · Duncanville, TXS/N LJ-682 N7012QThaggard Aviation LLC · Leesburg, GABuilt 2012 · S/N H80-105 N703THMunich Hans W DBA · Yakutat, AKBuilt 1966 · S/N 456 N715GFGeorgia Forestry Commission · Macon, GABuilt 2017 · S/N H80-204DC

Back to AD 2020-23-01