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.

N9898Aspen Air Montana LLC · Albuquerque, NMBuilt 1998 · S/N BB1627N9899Registered aircraftBuilt 1990 · S/N T65010DCN989BWRed Dragon Aviation LLC · Melbourne, FLBuilt 2004 · S/N 208B1058N989FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0124N989SAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2001 · S/N EA-689N98ARRyan Gordon Air LLC · Santa Ana, CABuilt 1979 · S/N LJ829N98FAHigher Purpose Aviaiton LLC · Spring Lake, MIBuilt 1980 · S/N 31T-8004028N98HBEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 425-003N98KQPilots To The Rescue Inc · Brooklyn, NYBuilt 2013 · S/N 100-0098N98KSGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N LJ-1502N98MNMohawk Northeast Inc · Plantsville, CTBuilt 1992 · S/N FL-88N98NFTanner Air LLC · Oxford, MSBuilt 1998 · S/N 133N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131N98VKFb Aviation Services LLC · Wilmington, DEBuilt 1989 · S/N 559N98WPWalsh Aviation LLC · Midland, TXBuilt 1997 · S/N LJ1493N990CBB & G Aircraft LLC · Flanders, NJBuilt 1994 · S/N LJ-1362N990JMCounty Of Galveston · Dickinson, TXBuilt 1966 · S/N LM-17N990LAMustang West Aero LLC · Midland, TXBuilt 2000 · S/N LJ-1613N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060N990WTAmerican King Air LLC · Escalon, CABuilt 1987 · S/N FA-121N991AKLake Clark Air Inc · Port Alsworth, AKBuilt 1982 · S/N U-189N991LLState Of Illinois · Springfield, ILBuilt 1996 · S/N FL-142N992AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-203N992AKLake Clark Air Inc · Port Alsworth, AKBuilt 1981 · S/N U-167N992FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0128N992LALane Aviation Inc · Rosenberg, TXBuilt 2007 · S/N LJ-1812N992MAJet Rider LLC · Wilmington, DES/N FL271N993AKLake Clark Air Inc · Ports Alsworth, AKBuilt 1982 · S/N U-180N993CBTri-Counties Bank · Chico, CABuilt 1999 · S/N LJ-1550N993FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0130N994AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N U141N994CFKk Air Leasing LLC · Tamarac, FLBuilt 1999 · S/N FL-248N994DF5 Blade Aero LLC · Firestone, COBuilt 1991 · S/N 22N994FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0132N9956BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0119N995FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0133N995GTJ&E Capital Partners LLC · Wilmington, DEBuilt 2007 · S/N LJ-1816N995JGMy Beaver LLC · Seattle, WABuilt 1966 · S/N 1627N995MKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1990 · S/N 180N995SPmg-Sr22t LLC · Greenville, NCBuilt 2003 · S/N 4697154N996FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0135N996QCHds Inc · Beech Grove, ARS/N 19CN997FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0197N997JMLight Aircraft Leasing LLC · Menomonie, WIBuilt 2003 · S/N 244N997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1976 · S/N BB217N997MDHaynes Aviation LLC · Wetumpka, ALBuilt 1985 · S/N LJ1111N998FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0139N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116N999DZAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U70
Back to AD 2002-23-13