OpenAirDocs.org
AD 2023-12-24

Registered aircraft · 58

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-12-24')
    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-12-24')
  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.

N12NTNovember Tango LLC · Ketchum, IDBuilt 2005 · S/N LIV-566N166CFCarlson Farms Inc · Plentywood, MTBuilt 2018 · S/N H80-215N190XTNextant Aerospace LLC · Cleveland, OHBuilt 1984 · S/N LJ-1066N212JCMatrix Sea Air And Land Brokerage LLC · Hypoluxo, FLS/N 045N293RGVintage Aero Collection Inc · Wilmington, DEBuilt 2006 · S/N LIV-269N3025ZDirrheimer 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-216N331BKWtpi Services LLC · Blue Mounds, WIBuilt 2015 · S/N H80-177N357AVVasenden Arnold · Midlothian, TXBuilt 2020 · S/N 9205N3644YRainbow Sports Inc · Enid, OKBuilt 2005 · S/N LIV-554N3WQSymbiotic Assets LLC · Winnemucca, NVBuilt 2004 · S/N 048SS52728N476EAMid Continent Aircraft Corp · Hayti, MOBuilt 2016 · S/N H80-190N486EAKamikaze Air LLC · Lake Mary, FLBuilt 2016 · S/N 115N509DSJohnson 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-176N51AROlsem Aerial Application Services LLC · Westbrook, MNBuilt 1970 · S/N 1523RN532NCDiscover Resources LLC · Norman, OKBuilt 2003 · S/N LIV-532N5538PAerial Crop Care Co · Hebron, NDBuilt 2017 · S/N H80-197N555XTTriple Five Air LLC · Sioux Falls, SDBuilt 2013 · S/N LIV-324N5UCR V Stich Construction Inc · Richmond, CABuilt 2004 · S/N LIV-524N601PFPernell Andrew B · Meridian, IDBuilt 2004 · S/N LIV-503N609HSCrop Duster Kings LLC · Hutchinson, MNBuilt 2018 · S/N H80-221DCN6116AGollott Dale A · Biloxi, MSBuilt 2001 · S/N 008237N619LFRcl 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-192N63EAvag Inc · Richvale, CABuilt 1977 · S/N 305BN661CMBristol Bay Capital Partners Inc · King Salmon, AKS/N LIV-538N666EXSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N BUEX0001N682KALott Dalton Leon · Duncanville, TXS/N LJ-682N7012QThaggard 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-211DCN717XBanana Hill LLC · Ashland, ORBuilt 1973 · S/N LJ-581N747TFMkm LLC · Anchorage, AKBuilt 2003 · S/N 111TN750BTN750bt LLC · Crested Butte, COBuilt 2004 · S/N 4229N750DLSteve Jackson Racing LLC · Helena, MTBuilt 2003 · S/N 001N753MVita Clean Services Inc · Wenatchee, WABuilt 2005 · S/N LIV-507N777DGBlue Chip Enterprises Inc · Clayton, NCBuilt 2010 · S/N LIV-452N808RTIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1976 · S/N 499
Back to AD 2023-12-24