OpenAirDocs.org
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.

N875RJUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 646N875SHJrm Aero LLC · Joplin, MOBuilt 2004 · S/N 4697174N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887N876FEFederal Express Corporation · Memphis, TNS/N 208B0207N876VACommonwealth Of Virginia · North Chesterfield, VABuilt 2025 · S/N 100-0352N877LAMcginty Flying Service LLC · Jones, LABuilt 2013 · S/N 502B-2877N877MCMid Continent Aircraft Corp · Hayti, MOBuilt 2025 · S/N 510-146N878FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0211N878KWehco Newspapers Inc · Little Rock, ARBuilt 1998 · S/N LJ-1513N878PNPenny Newman Grain Co · Fresno, CABuilt 2023 · S/N 4698251N8791SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0194N879FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0213N879JAWallace Flying Service Inc · Atmore, ALBuilt 2013 · S/N 502B-2879N87AWSummit Leasing LLC · Kenai, AKBuilt 1954 · S/N 52N87GRNational Test Pilot School · Mojave, CABuilt 1984 · S/N GM-93N87JFIsr Aviation LLC · Wilmington, DEBuilt 1998 · S/N 208B0657N87QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-60N87RMRegistration Pending · Lebanon, MERegistration pendingBuilt 1988 · S/N 208B0114N87SALiberty Air LLC · Christiansted, VIFirst renewal noticeBuilt 1982 · S/N BB-1089N87VDynamic Avlease Inc · Bridgewater, VAS/N LM-130N8800Tvs Aviation LLC · Nashville, TNBuilt 2001 · S/N 202N880DTOklahoma Department Of Transportation · Oklahoma City, OKBuilt 1991 · S/N LJ-1288N880FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0215N8817QRuhe Sales LLC · Leipsic, OHBuilt 1970 · S/N 1517RN881FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0204N882FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0208N883CRHoffman Travis K · Maroa, ILS/N 83N883FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0210N883LATri-Rotor Spray And Chemical Inc · Ulysses, KSBuilt 2013 · S/N 502B-2883N884DMQs Holdings LLC · Des Moines, IABuilt 2023 · S/N 4698274N884FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0233N885PESunshine Aircraft LLC · Winter Park, FLBuilt 2001 · S/N 208B0885N886AWAndrew & Williamson Sales Co · San Diego, CABuilt 1986 · S/N FA110N886FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0190N886SHDmfs Leasing LLC · Des Moines, IABuilt 2025 · S/N 46020075N887FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0216N8887BSt Croix Acceptance Corp · Devils Lake, NDBuilt 1987 · S/N LJ-1148N888ASStanislaus Food Products Co · Modesto, CABuilt 1987 · S/N FA-136N888EFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N 468608002N888FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0217N888KSShyair LLC · Medina, WABuilt 2019 · S/N 100-0270N888WGJ & M Aircraft LLC · Applegate, ORBuilt 2004 · S/N 587N888ZTRev Aircraft LLC · Wilmington, DEBuilt 1978 · S/N LW315N8892KKalche Aviation LLC · Baton Rouge, LABuilt 2001 · S/N 4697081N889FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0218N88GBPratt Group Leasing LLC · Niles, MIS/N 493N88HEStol LLC · Santa Fe, NMBuilt 2026 · S/N 488N88HRHansen Ranches LLC · Corcoran, CABuilt 1998 · S/N FL-225N88XJN88xj LLC · Park Ridge, ILBuilt 1998 · S/N LJ-1525N8907SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0230
Back to AD 2002-23-13