AD 2002-23-06

Registered aircraft · 16,325

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:2002-23-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:2002-23-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.

N113AFRa Aviation LLC · Clinton, LABuilt 2008 · S/N 12133N113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 4636363N113CDDowning Charles E · West Melbourne, FLFirst renewal noticeBuilt 1998 · S/N 001N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076N113ECCarrasco Enrique · Jupiter, FLBuilt 2017 · S/N 3RX112N113HMAkins Tal M · Register, GABuilt 1976 · S/N 32-7640084N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027N113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 3134N113KCGolden Valley LLC · Missoula, MTBuilt 2018 · S/N 41573N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193N113TLKramer David P · Lebanon, TNBuilt 2003 · S/N T18208219N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N1140XReaper LLC · Britton, MIBuilt 1975 · S/N 32-7540147N11414Van Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208413N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604N1143XTj Allen Bulk Services LLC · Newport, NYBuilt 2006 · S/N T18208648N1145BKampton William Charles · Napa, CABuilt 2006 · S/N T18208649N114ADBailey Walter A III · Cincinnati, OHBuilt 1998 · S/N 20020N114ANHake Scott W · Swoope, VABuilt 1978 · S/N 14396N114ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 14619N114AWCameron Hugh R · Gainesboro, TNBuilt 1976 · S/N 14095N114BShankle Michael L · Culpeper, VABuilt 1993 · S/N 14588N114BLLoose David C · Blanco, TXBuilt 1976 · S/N 14003N114BMJaswal Faisal · La Conner, WABuilt 1976 · S/N 14082N114BXRcs Aviation LLC · Indian Trail, NCBuilt 1992 · S/N 14543N114CECommander Air LLC · Purcellville, VABuilt 1996 · S/N 14640N114CGUnited Aviation LLC · Whitehall, PABuilt 1995 · S/N 14628N114CTTairex Inc · Wilmington, DES/N 14413N114DFNorthwoods Distribution Services Inc · Rhinelander, WIBuilt 1978 · S/N 14360N114DWLayman Nathan L · Hudson, WIBuilt 1978 · S/N 14408N114EEEngstrom Eric R · Eastover, NCBuilt 1978 · S/N 14357N114ELNaperville Flying Club · Woodridge, ILBuilt 1981 · S/N 32-8106096N114ERIhle Edward A · Elmendorf, TXS/N 0879N114GTEnders Richard A · San Bernardino, CABuilt 1976 · S/N 14130N114HPDolanair LLC · Coal Valley, ILBuilt 1978 · S/N 14370N114JAWright Richard D · Acworth, GABuilt 1978 · S/N 14365N114JGMack Phillip B · Tampa, FLBuilt 1995 · S/N 14634N114JTVanbeek Donald Eugene · Tualatin, ORBuilt 1976 · S/N 14104N114KR H Welsh LLC · Crescent City, FLBuilt 1979 · S/N 14519N114KJRegistered aircraftFirst renewal noticeBuilt 1995 · S/N 14630N114KLKaruppannan Venkatachalam · Troy, MIBuilt 1978 · S/N 14427N114LRegan Properties LLC · Coeur D Alene, IDBuilt 1997 · S/N 167N114MBCrew Andrew P · Chester, CTBuilt 1976 · S/N 14084N114MDUrsic Albert J · Minden, NVS/N 14033N114MGW F Carter Construction Inc · Arlington, TXBuilt 1978 · S/N 14382N114MKGood Thomas Ryan · Grapevine, TXS/N 10022-CN114MTSattig Henry B II · Cortez, COBuilt 1976 · S/N 14068
Back to AD 2002-23-06