AD 2001-09-06

Registered aircraft · 1,218

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:2001-09-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-09-06')
  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.

N130DWAttoyac Air LLC · Gonzales, TXBuilt 2021 · S/N T20609662N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130N131DTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N T20609239N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034N1323DEl LLC · Center, COBuilt 2008 · S/N T20608805N1327EDeguerin Dick · Houston, TXBuilt 2006 · S/N T20608689N1327KLoveland Aviation LLC · Scottsdale, AZBuilt 2006 · S/N T20608690N13291Conspec Inc · Wichita, KSBuilt 2006 · S/N T20608694N132PSU S Department Of The Interior · Boise, IDS/N 20608278N1330GNorth Plains Honey Co LLC · Bozeman, MTBuilt 2006 · S/N T20608696N1338BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608331N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413N13709Personal Wings Inc · San Diego, CABuilt 2007 · S/N T20608706N137PFerguson Frampton Z · Furman, SCS/N 20608304N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195N13WNRegistered aircraftBuilt 2026 · S/N T20609838N141CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609135N1423WMaricopa County Sheriffs Office · Phoenix, AZBuilt 2014 · S/N T20609150N143GBDocinator Aviation LLC · Edmond, OKBuilt 2012 · S/N T20609047N143GMNby Productions · Bristow, VABuilt 2010 · S/N T20608971N143GSPxw Services · Bristow, VABuilt 2010 · S/N T20608970N1447LHall Daniel W · Westlake Village, CABuilt 2008 · S/N T20608815N144GRegistration Pending · Waco, TXRegistration pendingBuilt 2020 · S/N T20609598N1458HMosle Air LLC · Far Hills, NJBuilt 2007 · S/N T20608765N1460TJlj Aviation LLC · Amarillo, TXBuilt 2007 · S/N T20608767N147GWAllen Air LLC · Creola, ALBuilt 2011 · S/N T20609022N147PASetki Air LLC · Wilmington, DEBuilt 2024 · S/N T20609772N147SASteeda Autosports Inc · Pompano Beach, FLBuilt 2014 · S/N T20609155N1488TTanana Leasing LLC · Fairbanks, AKS/N T20608541N148DWVantage Aviation USA LLC · Tampa, FLBuilt 2013 · S/N T20609091N149DWRbf Aero · Wilmington, DEBuilt 2013 · S/N T20609097N14WLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609857N15031Young J D · Plano, TXBuilt 2007 · S/N T20608725N151ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608588N15206Megwetch Aviation LLC · Auburn, MES/N T20609214N152BFFlorida State Guard · Tallahassee, FLBuilt 2015 · S/N T20609201N152RFHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609611N153WMPollard Aviation LLC · York, MEBuilt 2018 · S/N T20609558N154HROakes Aviation LLC · Racine, WIBuilt 2007 · S/N T20608755N1558QHostettler Aviation LLC · Nashville, TNBuilt 2017 · S/N T20609516N157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20608228N158PAndry Holdings LLC · Missoula, MTBuilt 2008 · S/N 20608306N159KMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609606N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333N160TTStraightline Private Air LLC · Denver, COBuilt 2017 · S/N T20609505N161CSAlberco LLC · Lovell, MEBuilt 2013 · S/N T20609101N161SPCalifornia Department Of Parks And Recreation · Mcclellan, CABuilt 2021 · S/N T20609667N1694LAccg Holdings LLC · Hyde Park, UTBuilt 2007 · S/N T20608783
Back to AD 2001-09-06