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.

N114PBBernabucci Christian J · Mapleton, NDBuilt 1976 · S/N 14057N114PMSundance Aviation · Morganton, NCBuilt 1999 · S/N 14666N114PRC W 3 LLC · San Juan, PRBuilt 1981 · S/N 31-8152088N114PSPitts S2b LLC · Salinas, CABuilt 1998 · S/N 6006N114PWSiddiqu Shahid · Hampton, VAS/N 14542N114RCAsbury William A · Bridger, MTBuilt 1976 · S/N 14011N114RMImmelman Leasing Company LLC · Lompoc, CABuilt 1999 · S/N 6030N114RRMdb Air LLC · Poway, CABuilt 1996 · S/N 20015N114RWLaw C Scott · Oklahoma City, OKBuilt 1976 · S/N 14048N114SACustom Air International LLC · Homestead, FLBuilt 1980 · S/N 31-8052053N114SGMixon Christopher L · Lafayette, LABuilt 1979 · S/N 14535N114SJMeashey Matthew · Wake Forest, NCBuilt 1977 · S/N 14318N114SMColvin Daniel A · Dayton, TNBuilt 1978 · S/N 14442N114SRSkymaster Stc LLC · Mena, ARS/N 14016N114SSHeritage Air LLC · Scappoose, ORS/N 14291N114TBWelch D Michael · Foster City, CABuilt 1976 · S/N 14172N114TCIntegritas Forum LLC · Sundance, WYBuilt 1978 · S/N 14355N114TLLa Soplaera Realty LLC · Niwot, COBuilt 2003 · S/N T18208220N114USPeters Richard A · San Marino, CABuilt 1978 · S/N 14386N114VCStevenson Andy · Boyd, TXBuilt 1993 · S/N 14581N114VFAtticus Talon LLC · Wilmington, DEBuilt 1981 · S/N 62P08928165024N114WCMahan Dusty · Cookeville, TNBuilt 1976 · S/N 14126N114WEL & K Aviation Holdings LLC · Leavenworth, KSS/N 14540N114WMMaule Flight LLC · Nashville, INBuilt 2001 · S/N 25058CN114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N1151ZRenfro Michael W · Bethel, AKS/N 1524-186N11541Upskirt Aviation LLC · Fredericktown, MOS/N R18201914N1154XKelley Jay D · Lake Havasu City, AZS/N 32-7540149N1155PN1155p Corp Trustee · Wilmington, DEBuilt 2003 · S/N 20608193N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093N115CEDentate Equipment Leasing LLC · Belmont, MABuilt 1999 · S/N 14667N115CSBurger Aviation LLC · Brandon, MSBuilt 2000 · S/N 32-46177N115DKN4471j LLC · Dover, DEBuilt 1997 · S/N 3270N115DSOverly Christopher Daniel · Williamsport, OHBuilt 2000 · S/N 2028N115DWMav LLC · Erie, COBuilt 2024 · S/N 4636848N115GTWahl John H · Rockwell City, IAS/N 20042N115HPCam Aviation LLC · Valparaiso, INBuilt 1998 · S/N 3246115N115JDC R Aviation Inc · Miami, FLS/N 27-7405395N115JWFeric Drazen · Mesa, AZBuilt 1976 · S/N 14081N115KTMulva Jonathan · De Pere, WIBuilt 2002 · S/N 20044N115MDSpecial Orthogonal Group LLC · Dover, DEBuilt 2001 · S/N 20039N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224N115SJWolf Richard · Yerington, NVBuilt 1994 · S/N 14614N115SZThree Greens LLC · San Jose, CABuilt 2000 · S/N 20036N115VSSei Vincent J · Albuquerque, NMBuilt 2005 · S/N 115N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198N116BKDacy Roy W · Rockport, TXS/N 32-782N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019C
Back to AD 2002-23-06