AD 2016-12-01

Registered aircraft · 1,377

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:2016-12-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:2016-12-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.

N33DRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 2185N33JAMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 261N33NEKatmai Air LLC · Anchorage, AKBuilt 1999 · S/N 282N33NXSilver Lake Ne LLC · Park City, UTBuilt 2017 · S/N 1733N33ZBSpot And Stalk LLC · Missoula, MTBuilt 2014 · S/N 1476N341WAGeosouthern Energy Corp · The Woodlands, TXBuilt 2012 · S/N 1341N342PEMfrg LLC · Plymouth, MNBuilt 2012 · S/N 1342N343LHLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2024 · S/N 2343N345JWJ W Didado Electric LLC · Akron, OHBuilt 2013 · S/N 1434N345NXSlipstream Aviation Partners LLC · Benton, KYBuilt 2012 · S/N 1345N345PJk Aero LLC · Gilbert, IABuilt 2023 · S/N 2271N345RFClaire Air LLC · Carol Stream, ILBuilt 2021 · S/N 2075N347KCEz Rydr LLC · Huntsville, ALS/N 347N348AFKirkland Messina Inc · Portsmouth, NHBuilt 2023 · S/N 2348N348PCGuardian Flight LLC · Lewisville, TXS/N 348N349GXSilver Aviation LLC · Deerfield Beach, FLBuilt 2024 · S/N 2349N34LRLr2 Holdings LLC · Columbia, MDBuilt 2024 · S/N 2369N34MJN34mj LLC · Des Moines, IABuilt 2019 · S/N 1856N351PCEag Aviation LLC · Council Bluffs, IABuilt 2000 · S/N 351N353KMPapareenie LLC · Pismo Beach, CABuilt 2003 · S/N 534N353PTCooper Aviation LLC · Lincoln, MABuilt 2000 · S/N 353N354WA235pt LLC · Cape Girardeau, MOBuilt 2012 · S/N 1354N355AF355af LLC · Naples, FLBuilt 2000 · S/N 345N356BKBk Albatross LLC · Lilburn, GABuilt 2020 · S/N 2041N357ERErf Flight Services LLC · Corpus Christi, TXBuilt 2012 · S/N 1357N357ETCajun Industries Holdings LLC · Baton Rouge, LABuilt 2024 · S/N 2384N357FTFaith Technologies Inc · Menasha, WIBuilt 2024 · S/N 2357N357HEHaynie Enterprises Inc · Henderson, NVBuilt 2010 · S/N 1203N357JKDodson International Parts Inc · Rantoul, KSBuilt 2013 · S/N 1451N359CVWen LLC · Spokane, WABuilt 2000 · S/N 382N359FCPc-24 LLC · Park City, UTS/N 1483N359VFLegacy Air LLC · Johnson, KSBuilt 2012 · S/N 1359N35ASFlight Level Services LLC · Danville, KYBuilt 2013 · S/N 1412N35WAMontana Jet LLC · Monterey, CAS/N 770N35WHN75ax LLC · Tulsa, OKBuilt 2015 · S/N 1546N35WYImp Inc · Coatesville, PABuilt 2009 · S/N 1180N361AFAspen Imaging LLC · Portsmouth, NHBuilt 2024 · S/N 2361N368NGWeems Air LLC · Dalton, GAS/N 1368N368PCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2001 · S/N 368N36GXCarolina Cardinal Holdings LLC · Wilson, NCBuilt 2023 · S/N 2244N36LTDohertys Toys Second LLC · Lakeland, FLBuilt 2024 · S/N 2425N36NGBsl Transport LLC · Salem, ORBuilt 2016 · S/N 1636N36PJSteelman Aviation Assets LLC · North Las Vegas, NVBuilt 2021 · S/N 2114N36ZMStauf Air LLC · Germantown, TNBuilt 2016 · S/N 1640N370AFRigi Inc · Portsmouth, NHBuilt 2024 · S/N 2370N371LLCritical Care Services Inc DBA · Blaine, MNBuilt 2010 · S/N 1240N373EZHawkins Aviation LLC · Boise, IDBuilt 2016 · S/N 1654N373KMHobble Creek Transport LLC · Spanish Fork, UTBuilt 2000 · S/N 373N374PMMclean Air LLC · Ketchum, IDBuilt 2013 · S/N 1438N376AECmd Holding LLC · Fresno, CABuilt 2019 · S/N 1858
Back to AD 2016-12-01