AD 2002-23-13

Registered aircraft · 3,462

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-13')
    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-13')
  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.

N920TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N LJ-1300N921BSOld Dominion Aviation LLC · Statesville, NCBuilt 1993 · S/N FL-110N921FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0021N921MFPuerto Coral Corp · Wilmington, DEBuilt 1980 · S/N LA62N921RAAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2016 · S/N LJ-2131N922JCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N LJ-1665N923FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0023N923JKMs Avation LLC · Waukesha, WIS/N FL-40N923LHGrowers Air Service Inc · Woodland, CABuilt 2012 · S/N 502B-2797N92409Piper Aircraft Inc · Vero Beach, FLBuilt 1990 · S/N 425501054N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483N925ARRnjs Products LLC · Lewes, DEBuilt 1977 · S/N LJ-725N925DWSundy Aviation LLC · Palo Alto, CABuilt 2011 · S/N EVO-018N925FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0025N925KHS660-131dc LLC · Keller, TXBuilt 2015 · S/N T660XP-131DCN925TKSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1992 · S/N 1021N926FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0026N926LADevil Dusters Inc · Artesia, NMBuilt 1993 · S/N 402-0911N927FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0027N927JPBair Aviation Inc · Lake City, SDBuilt 2008 · S/N 402B-1203N927JTPikes Peak Flyers Llp · Colorado Springs, COBuilt 1991 · S/N LJ1263N92858Blue Aircraft LLC · Ketchikan, AKBuilt 1953 · S/N 8N928FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0028N928GP402wd Holdings LLC · Robstown, TXBuilt 2011 · S/N 402B1242N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482N928MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1944 · S/N 32897N928PBMaranatha Leasing & Consulting Inc · Marco Island, FLBuilt 2005 · S/N 4697227N928SBBoutique Air Inc · Dallas, TXBuilt 2004 · S/N 552N928TNBoettcher Aerial Company Inc · Beloit, KSBuilt 2013 · S/N 502B-2872N928WLJobe Industries LLC · Santa Teresa, NMBuilt 2025 · S/N 100-0357N9295Bank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 532N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630N929FDFaust Distributing Co Inc · Houston, TXBuilt 2000 · S/N LJ-1585N929FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0029N929KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 461N929PInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N LJ-1923N92BDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-132N92CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0185N92FEWarren Transportation LLC · Dallas, TXBuilt 1969 · S/N 242N92JASouther Field Aviation Inc · Americus, GABuilt 2020 · S/N T34-505DCN92JJPa1 208b-1074 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1074N92KMJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T41-175DCN92RKSnk Real Property Holdings LLC · Meta, MOBuilt 1996 · S/N LJ-1458N92WEInce Aviation LLC · Dover, DEBuilt 1984 · S/N LJ1090N9304FSkydive Baltimore LLC · Lincoln, DEBuilt 1985 · S/N 20800008N930CFHynes Kevin P · Wichita Falls, TXBuilt 2016 · S/N 1157N930DSAc Aircraft Holdings LLC · Dallas, TXBuilt 1999 · S/N FL-252N930FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0030N930HMForgenie Alan Peter · Willsboro, NYBuilt 2005 · S/N 4697236
Back to AD 2002-23-13