AD 2001-20-01

Registered aircraft · 2,521

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-20-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:2001-20-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.

N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782N1TCMarcare Aviation LLC · Gardnerville, NVBuilt 1995 · S/N 130N1TQWilmington Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 1649TB27N1VXMid America Sprayers Inc · Johnson, KSBuilt 1982 · S/N 001N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772N200KSKapowsin Air Sports Ltd · Shelton, WABuilt 1986 · S/N 208B0001N200MFMissionary Flights & Services Inc DBA · Fort Pierce, FLBuilt 1943 · S/N 9766N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691N200NYNew York State Police · Latham, NYBuilt 1976 · S/N BC-25N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164N204PEWorsham Farms Flying Service Inc · Camilla, GABuilt 2003 · S/N T660-109N204WState Of Wisconsin · Madison, WIBuilt 1998 · S/N FL-204N20551Lane Christopher A · Lakeland, GAS/N T15-035N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491N2067BAgricair Leasing LLC · Bancroft, WIBuilt 1998 · S/N T34-246N2076BArrowhead Aviation LLC · Louisville, ALBuilt 1998 · S/N T34-249N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207N207PDale Aviation · Rapid City, SDBuilt 1995 · S/N LJ-1406N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195N207WWDarling'S Agency LLC · Brewer, MEBuilt 2023 · S/N 4698287N208Jmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 2002 · S/N 20800363N208ABSkydive Guam Inc · Barrigada, GUBuilt 2008 · S/N 208B2047N208AJCessna 2080711 Inc Trustee · Wilmington, DEBuilt 1998 · S/N 208B0711N208AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 208B0710N208BMerlin Labs Inc · Boston, MABuilt 2003 · S/N 208B1023N208BABoeing Co · Renton, WABuilt 2008 · S/N 208B2027N208BKTwo O Eight LLC · Nantucket, MABuilt 2006 · S/N 208B1190N208BLCaravan International Leasing Inc · Carson City, NVBuilt 1989 · S/N 208B0182N208BVRegistered aircraftBuilt 2001 · S/N 208B0913N208BXBoeing Co · Renton, WABuilt 2011 · S/N 208B2292N208CEArctic One LLC · Fairbanks, AKBuilt 1995 · S/N 208B0466N208CGAspen Homes And Development LLC · Coeur D Alene, IDBuilt 1995 · S/N 132N208CVKangaru Enterprises LLC · Solvang, CABuilt 2008 · S/N 208B2024N208DEEvans David J · Parker, COBuilt 1996 · S/N 208B0502N208DHAcme Prevost LLC · Missoula, MTFirst renewal noticeBuilt 2008 · S/N 208B2018N208DZSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1998 · S/N 208B0717N208EBUS Government · Washington, DCBuilt 2004 · S/N 208B1047N208EEN208ee Inc · Addison, TXBuilt 2006 · S/N 208B1213
Back to AD 2001-20-01