AD 2000-04-01

Registered aircraft · 5,676

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:2000-04-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:2000-04-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.

N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342N130CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609133N130DWAttoyac Air LLC · Gonzales, TXBuilt 2021 · S/N T20609662N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657N131AZSuraair Holdings Inc · Wilmington, DEBuilt 2012 · S/N 172S11165N131DTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N T20609239N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034N1322KCleared Into Bravo LLC · Sunnyvale, CABuilt 2006 · S/N 172S10345N1323DEl LLC · Center, COBuilt 2008 · S/N T20608805N1323KFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10348N1323XMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10367N1327EDeguerin Dick · Houston, TXBuilt 2006 · S/N T20608689N1327KLoveland Aviation LLC · Scottsdale, AZBuilt 2006 · S/N T20608690N1327NGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10380N1327ZN1327z LLC · Palm City, FLBuilt 2005 · S/N 172S9867N13291Conspec Inc · Wichita, KSBuilt 2006 · S/N T20608694N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176N132PSU S Department Of The Interior · Boise, IDS/N 20608278N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189N1330GNorth Plains Honey Co LLC · Bozeman, MTBuilt 2006 · S/N T20608696N1330NEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10396N1331213312 LLC · Union Gap, WABuilt 2006 · S/N 172S10401N1333EEndeavour Flight Training Inc · Opa Locka, FLBuilt 2006 · S/N 172S10404N1338BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608331N133CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12131N133VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281190N1348LFlight World Inc · San Juan, PRBuilt 2005 · S/N 172S9939N134BChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9345N134DBBlue Skies27 LLC · Los Angeles, CABuilt 2000 · S/N 18280808N134PJHelibro LLC · Red Bluff, CABuilt 2002 · S/N 172S9187N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077N135PJAviator Air Operations LLC · Grand Prairie, TXBuilt 2000 · S/N 172S8406N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192N1361MLux Aero Operations LLC · Belmont, CABuilt 2005 · S/N 172S9842N1369QAmeriflyers Of Texas Inc · Addison, TXBuilt 2005 · S/N 172S9946
Back to AD 2000-04-01