OpenAirDocs.org
AD 2023-01-07

Registered aircraft · 31

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

N166CFCarlson Farms Inc · Plentywood, MTBuilt 2018 · S/N H80-215N190XTNextant Aerospace LLC · Cleveland, OHBuilt 1984 · S/N LJ-1066N3025ZDirrheimer Maximo Hernan · Flora, ILBuilt 2013 · S/N H80-115N3037RDavidson Richard E · Tchula, MSBuilt 2013 · S/N H80-123N30454Registered aircraftBuilt 2013 · S/N H80-138N3062DDewitt Flying LLC · Morven, GABuilt 2012 · S/N H80-114N318SWSciara Flying Service LLC · Eudora, ARBuilt 2018 · S/N H80-216N31YZDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2016 · S/N 001-APF-2016-VACN331BKWtpi Services LLC · Blue Mounds, WIBuilt 2015 · S/N H80-177N476EAMid Continent Aircraft Corp · Hayti, MOBuilt 2016 · S/N H80-190N509DSJohnson Lynn L · Grafton, NDBuilt 2012 · S/N H80-110N510HHJohnson Lynn L · Grafton, NDBuilt 2018 · S/N H80-218N510KKKingsley Kiman J · Miller, MOBuilt 2015 · S/N H80178DCN511DSDirrheimer Maximo Hernan · Katy, TXBuilt 2015 · S/N H80-176N5538PAerial Crop Care Co · Hebron, NDBuilt 2017 · S/N H80-197N609HSCrop Duster Kings LLC · Hutchinson, MNBuilt 2018 · S/N H80-221DCN619LFRcl Farms Leasing LLC · Wilmington, DEBuilt 2019 · S/N H80-230N6204MDuck Hill Air Service LLC · Grenada, MSBuilt 2014 · S/N H80-145N6211HLowry Flying Service Inc · Grinnell, IABuilt 2015 · S/N H80-168N62135Hohl Enterprises LLC · Donnellson, IABuilt 2015 · S/N H80-165N6214FHaynes Flying Service LLC · Forrest City, ARBuilt 2015 · S/N H80-175DCN6216DHound Dog Enterprises LLC · Terre Haute, INS/N H80-181N6216KHound Dog Enterprises LLC · Terre Haute, INBuilt 2016 · S/N H80-182N6216UThrush Aircraft LLC · Albany, GABuilt 2017 · S/N H80-192N7012QThaggard Aviation LLC · Leesburg, GABuilt 2012 · S/N H80-105N715GFGeorgia Forestry Commission · Macon, GABuilt 2017 · S/N H80-204DCN716GFGeorgia Forestry Commission · Macon, GABuilt 2017 · S/N H80-211DCN775THGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1955 · S/N 75N808RTIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1976 · S/N 499N816MTTwo River Airspray LLC · Cavalier, NDBuilt 2017 · S/N H80-188N85RDDavidson Richard E · Tchula, MSBuilt 2018 · S/N H80-214
Back to AD 2023-01-07