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.

N248MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2011 · S/N 1287N249GXWildcat Aviation LLC · South Salt Lake, UTBuilt 2023 · S/N 2249N24XZ31dodge Air LLC · Kernersville, NCS/N 1657N250KKNeed For Speed Aerospace LLC · Downers Grove, ILBuilt 2024 · S/N 2383N251JJTvpx Ars Inc Trustee · North Salt Lake, UTS/N 701N251NGJa Investments Inc · Toledo, OHBuilt 2010 · S/N 1251N253PCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1999 · S/N 253N254DLCrimson Phoenix LLC · Kalispell, MTBuilt 2019 · S/N 1917N256BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 1648N256TWTw Leasing LLC · Oxford, CTBuilt 2008 · S/N 1056N257TWTw Leasing LLC · Oxford, CTBuilt 2024 · S/N 2377N257WBRoyal Gorge Management Consulting LLC · Canon City, COBuilt 2023 · S/N 2309N259PCNew Mfis Holdings LLC · Topeka, KSBuilt 2010 · S/N 1259N259TWTw Leasing LLC · Oxford, CTBuilt 2025 · S/N 2446N25MTMiss Liberty LLC · West Hartford, CTBuilt 2024 · S/N 2338N25NGWood River Aviation Partners LLC · Hailey, IDBuilt 2013 · S/N 1425N25NXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 1125N25UCHarns Pc-12 LLC · Perris, CABuilt 2025 · S/N 2473N25WAir Watkins LLC · Alpharetta, GABuilt 2002 · S/N 476N25XMMccluer Aviation LLC · North Las Vegas, NVBuilt 2019 · S/N 1896N260HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 260N261HBChamonix Air LLC · Boulder, COBuilt 2010 · S/N 1261N261NXCitizens National Bank Of Texas · Waxahachie, TXBuilt 2020 · S/N 2061N263RSNorthern Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 112N264SGAdventaire LLC · Minot, NDBuilt 2021 · S/N 2149N264WFWilliams Tim DBA · Knoxville, TNBuilt 1999 · S/N 264N265NXCmr3 Holdings LLC · Newark, DEBuilt 2011 · S/N 1265N266NGBlue Horizon Ventures LLC · Gadsden, ALBuilt 2011 · S/N 1266N267PTBlades & Bars LLC · Montrose, COBuilt 2022 · S/N 2169N267WFNeljo LLC · Charlottesville, VABuilt 1999 · S/N 267N269CTAero27 Tn LLC · Cookeville, TNS/N 547N269LGCoffin Simon P · RemseckBuilt 2005 · S/N 633N269NGRebel One LLC · Dover, DEBuilt 2010 · S/N 1243N26KHConcord Jet Service Inc · Concord, CAS/N 592N26NGAgb Warranty Services LLC · Warrenton, VABuilt 2013 · S/N 1426N26WRWonderful Orchards LLC · Shafter, CABuilt 2022 · S/N 2181N26XMAm Aviation LLC · Henderson, NVBuilt 2023 · S/N 2312N270AFRigi Inc · Portsmouth, NHBuilt 2023 · S/N 2270N2710BDrglfg LLC · Denver, COBuilt 2018 · S/N 1809N271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 622N2727KRegistered aircraftBuilt 2002 · S/N 480N272NGCactus Land Development LLC · Fountain Hills, AZBuilt 2011 · S/N 1272N273SMGuardian Flight LLC · South Jordan, UTBuilt 2002 · S/N 475N276HDRussoms Cloud Server LLC · Montgomery, ALBuilt 2023 · S/N 2276N277PCShc 2021 LLC · Grand Forks, NDBuilt 1999 · S/N 277N278JMJlm Aviation LLC · Winthrop, MEBuilt 2012 · S/N 1367N278WCN278wc LLC · Greer, SCBuilt 1999 · S/N 278N27KNStuckey Connections LLC · Magnolia, TXBuilt 2011 · S/N 1282N27NXValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 2117N281HSterling Air Service LLC · Corpus Christi, TXBuilt 2007 · S/N 799
Back to AD 2016-12-01