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.

N316PMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 241N316SWLongfellow An LLC · Dallas, TXS/N 1680N316TRTristar Leasing LLC · Poteet, TXBuilt 1996 · S/N 142N317CWWilson Eric · San Angelo, TXBuilt 2022 · S/N 2184N317KCHinterland Holdings LLC · Anchorage, AKBuilt 2006 · S/N 737N317NARegistration Pending · Greenwood Village, CORegistration pendingBuilt 1998 · S/N 223N318MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 318N319JMJohnston Enterprises LLC · Enid, OKBuilt 2022 · S/N 2214N320AFRigi Inc · Portsmouth, NHS/N 2320N320PWSpur Aviation Services Lc · Twin Falls, IDBuilt 2005 · S/N 647N320UHU-Haul Co Of Oregon · Phoenix, AZBuilt 2000 · S/N 320N320WAIndy Air LLC · Blaine, MNBuilt 2011 · S/N 1320N321MWW Aviation LLC · Dover, DEBuilt 2001 · S/N 393N321MXPathe Peter D · Kirkland, WAS/N 215N321VKHofmann Aviation LLC · Salt Lake City, UTBuilt 2014 · S/N 1508N323NXTrial Support Services Inc · Mesquite, TXBuilt 2011 · S/N 1323N323VBKickin Tires Aviation II LLC · Lake Wales, FLBuilt 2003 · S/N 513N324ACR&J Toy Fund LLC · North Sioux City, SDS/N 197N324AWUS Government · Washington, DCBuilt 2025 · S/N 2453N324BKBlue Water Express LLC · Coral Gables, FLBuilt 2008 · S/N 1021N324PWRenshi LLC · Palm City, FLS/N 406N324SCN324sc LLC · Nephi, UTS/N 490N325AFSilverback Advisory LLC · Portsmouth, NHBuilt 2023 · S/N 2325N325FSBridger Aerospace Group LLC · Belgrade, MTBuilt 2006 · S/N 746N325JTPierce Air Ventures LLC · Excelsior, MNBuilt 2011 · S/N 1279N325MEDesa Leasing LLC · Laredo, TXBuilt 2012 · S/N 1374N325MWMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 325N326PACone Air LLC · Omaha, NEBuilt 2000 · S/N 362N326VVictor Bravo Aviation LLC · Bethel, MEBuilt 2006 · S/N 733N327JZDhz LLC · Cincinnati, OHBuilt 2000 · S/N 327N327SFState Of Colorado · Lakewood, COBuilt 2003 · S/N 511N328BMPilatus Aircraft USA Ltd · Broomfield, COBuilt 2024 · S/N 2371N328SFState Of Colorado · Lakewood, COBuilt 1999 · S/N 269N329SKAlbion Aviation LLC · Florence, SCBuilt 2002 · S/N 441N329TSWylie David · Houston, TXBuilt 2015 · S/N 1562N32NXPilatus Aircraft USA Ltd · Broomfield, CONon-citizen corporation, flight hours not reportedBuilt 2023 · S/N 2236N32WKCassling Diagnostic Imaging Inc DBA Cassling · Omaha, NEBuilt 2008 · S/N 1046N330NXHillpointe Aviation LLC · Winter Park, FLBuilt 2012 · S/N 1330N331NGPilatus Aircraft USA Ltd · Broomfield, COBuilt 2012 · S/N 1331N3333NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 2163N333AJB2 Skies Florida LLC · Saint Louis, MOBuilt 2021 · S/N 2116N333FDHc Advisors LLC · Wilmington, DEBuilt 2022 · S/N 2207N333PNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 333N334AMAm3 LLC · Fresno, CABuilt 2021 · S/N 2081N335WHDch Aircraft Leasing LLC · Hayden, IDS/N 335N337NGKansas City Aviation Center Inc · Olathe, KSBuilt 2012 · S/N 1337N337RHHorwath Ricky · Saint James City, FLBuilt 2000 · S/N 337N338NGJet Sales Of Stuart LLC · Stuart, FLS/N 1338N338QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2000 · S/N 338N33BJB2 Aviation LLC · Sisters, ORS/N 184
Back to AD 2016-12-01