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.

N161AJGruener Garrett · Berkeley, CABuilt 1997 · S/N 161N1621MLybl Air LLC · Billings, MTBuilt 2019 · S/N 1846N162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLBuilt 1996 · S/N 162N164CMaroon & Gold LLC · Albuquerque, NMBuilt 2009 · S/N 1074N164RDIsland Park Aviation LLC · Fargo, NDBuilt 2022 · S/N 2225N164SLife Flight Network LLC · Aurora, ORBuilt 2009 · S/N 1164N166AFGeiger Holdings Inc · Portsmouth, NHBuilt 2022 · S/N 2166N166SBNew Cingular Wireless Pcs LLC · Anchorage, AKBuilt 1999 · S/N 310N1677Le Loop LLC · Naples, FLBuilt 2017 · S/N 1677N167AREdgemont Aviation LLC · Wilmington, DEBuilt 1999 · S/N 279N16FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2071N16HQ10ke LLC · Okeechobee, FLBuilt 2016 · S/N 1656N172AFDynasty Flight LLC · Portsmouth, NHBuilt 2022 · S/N 2172N172JSCmfl LLC · Montgomery, ALBuilt 1997 · S/N 171N172PBLocker Inc · Muleshoe, TXBuilt 1997 · S/N 172N173CBer Company LLC · Albuquerque, NMBuilt 2023 · S/N 2256N175ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 566N175WAOsprey Aviation LLC · Preston, IDBuilt 2017 · S/N 1750N177NXLebeouf Bros Towing LLC · Houma, LABuilt 2018 · S/N 1777N178CMaroon And Gold LLC · Albuquerque, NMBuilt 2024 · S/N 2358N178MHRegistered aircraftBuilt 2008 · S/N 875N178WFJb Air Holdings 1 LLC · College Grove, TNBuilt 2022 · S/N 2222N179ALBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 1779N17DPWde Aviation LLC · Atlanta, GABuilt 2005 · S/N 648N17SEBeta Fleet LLC · South Burlington, VTBuilt 2011 · S/N 1322N18007Stancil Builders Inc · Angier, NCBuilt 2000 · S/N 377N180NGCwa LLC · Saint Louis, MOS/N 1800N183CGeorgia Air South Inc · Valdosta, GABuilt 2016 · S/N 1597N185PBStellar Envoy LLC · Arvada, COBuilt 1997 · S/N 185N188PCTimeless USA LLC · Wilmington, DEBuilt 1997 · S/N 188N189AFRmz LLC · Portsmouth, NHBuilt 2022 · S/N 2189N18DSN18ds LLC · Mcminnville, ORBuilt 2007 · S/N 797N190ASInterport Aviation LLC · Newark, NJBuilt 2006 · S/N 727N190PEUS Department Of The Interior · Boise, IDBuilt 1997 · S/N 190N1919Phase 2 Aviation LLC · Miami, FLBuilt 2019 · S/N 1919N191PEJmm Aviation LLC · Oakwood, GABuilt 2010 · S/N 1191N191PGDw Leasing LLC · Charlotte, NCBuilt 2018 · S/N 1775N191SPJke Helm LLC · Spreckels, CABuilt 1999 · S/N 284N1921UBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 2104N192CPaso Aviation LLC · Winsted, MNBuilt 2024 · S/N 2403N192CPRegistered aircraftBuilt 2014 · S/N 1509N1932HAirmax LLC · Waukee, IABuilt 2023 · S/N 2260N194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTBuilt 2003 · S/N 533N198TKEbac LLC · Wichita, KSBuilt 2010 · S/N 1198N199CMPassmore Aviation LLC · Claremore, OKBuilt 1999 · S/N 262N19AEGbny LLC · Sheridan, WYBuilt 2024 · S/N 2429N1CWAircw LLC · Charlotte, NCBuilt 2017 · S/N 1705N1TCMarcare Aviation LLC · Gardnerville, NVBuilt 1995 · S/N 130N200NPRhys Vineyards LLC · Woodside, CABuilt 2016 · S/N 1596N201LFFreedom 2026 LLC · Minneapolis, MNBuilt 1996 · S/N 147
Back to AD 2016-12-01