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.

N914BRFitchs Flying Service LLC · Pearsall, TXBuilt 1992 · S/N 502-0189N914DKCal-Ore Life Flight LLC · Brookings, ORBuilt 1996 · S/N LJ-1445N914FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0014N914SHSanford Medical Center · Sioux Falls, SDBuilt 1999 · S/N BB-1688N9152CLewis Flying & Maintenance Service Inc · Morse, LAFirst renewal noticeBuilt 1993 · S/N 5020205N9152RFlatland Aviation LLC · Indianola, MSBuilt 1989 · S/N 502-0203N915CDN915cd LLC · Woodland, CABuilt 1977 · S/N LJ748N915GDAir Charter Inc DBA · Culebra, PRBuilt 1989 · S/N SH3755N915JFFox James R · St Paul, MNBuilt 1991 · S/N 20800209N915MRGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1637N916FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0016N916GDAir Charter Inc DBA · Culebra, PRBuilt 1989 · S/N SH3751N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041N917KRAction Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 176N917PCChester Haven LLC · Chester, SCBuilt 2013 · S/N LJ-2060N917TPAerial LLC · Kalispell, MTBuilt 1982 · S/N 31T8104068N917WAN917wa Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-77N917WGAmphib Air LLC · Fort Myers, FLBuilt 1965 · S/N 1586TB8N9184QMowata Farms LLC · Mamou, LABuilt 1993 · S/N 502-0209N9184UWest Hills Aviation Inc DBA · Huron, CABuilt 1993 · S/N 502-0211N9185FFarm Brothers Flyers A LLC · Grady, ARBuilt 1993 · S/N 502-0206N9185GDodson International Parts Inc · Rantoul, KSBuilt 1993 · S/N 502-0213N9187QLewis Flying & Maintenance Service Inc · Morse, LABuilt 1993 · S/N 502-0219N9187WAcadian Dusters LLC · Church Point, LABuilt 1993 · S/N 502-0220N9187ZEagle LLC · Sleepy Eye, MNBuilt 1993 · S/N 502-0223N918BBAlco Aviation Services Consulting LLC · Taft, TNBuilt 1980 · S/N LA113N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677N918FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0018N918JPAgricair Leasing LLC · Bancroft, WIBuilt 2022 · S/N 510-103N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1983 · S/N LA-211N9190VT&T Highcountry Flying Service LLC · Saint Anthony, IDFirst renewal noticeBuilt 1993 · S/N 402-0919N91918Thiel Air Care Inc · Chowchilla, CABuilt 1993 · S/N 502-0227N9192JAir Care Inc · Lamar, COS/N 502-0228N9193VMurtagh Flying Service Inc · Lexington, MSBuilt 1994 · S/N 502-0231N9194PLeading Edge Aero LLC · Southampton, NJBuilt 1993 · S/N 502-0233N91959Aslesen Leasin LLC · Halstad, MNBuilt 1994 · S/N 802A-0008N9195XRba LLC · Kimberly, IDBuilt 1993 · S/N 502-0235N9196CWoodley Aerial Leasing LLC · Walnut, ILBuilt 1994 · S/N 402A-0937N9196ZOscar Aviation LLC · Livonia, LAS/N 502B-0238N9197DT-C Aerial LLC · Littlefield, TXBuilt 1994 · S/N 502B-0240N919BGFreebird Aviation LLC · Monahans, TXBuilt 1984 · S/N EA-428N919GDAir Charter Inc DBA · Culebra, PRBuilt 1988 · S/N SH3740N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824N91CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0054N91CTClemson University · Clemson, SCBuilt 1998 · S/N LJ-1521N91CVTwin P Aviation LLC · Fort Worth, TXBuilt 1991 · S/N 5600009N91SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-15N91WFLouisiana Department Of Wildlife And Fisheries · Baton Rouge, LABuilt 2023 · S/N 100-0323N920FEFederal Express Corp · Memphis, TNS/N 208B0020
Back to AD 2002-23-13