AD 2016-05-13

Registered aircraft · 3,126

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:2016-05-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:2016-05-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.

N871FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0198N872FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0200N873FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0202N874FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0205N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354N875FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0206N875JBAslesen Leasin LLC · Halstad, MNBuilt 2017 · S/N 802A-0725N875RJUS 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 208B0207N876LADcs Air LLC · Lewes, DEBuilt 2021 · S/N 802A-0876N878FEFederal 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 4698251N879FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0213N87AWSummit Leasing LLC · Kenai, AKBuilt 1954 · S/N 52N87JFIsr Aviation LLC · Wilmington, DEBuilt 1998 · S/N 208B0657N87RMRegistration 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 202N8802EBravo Ag Air LLC · Belmond, IABuilt 2016 · S/N 802A-0630N880DTOklahoma Department Of Transportation · Oklahoma City, OKBuilt 1991 · S/N LJ-1288N880FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0215N880GXTub Time Aviation LLC · Portland, ORBuilt 2024 · S/N K080N8817QRuhe Sales LLC · Leipsic, OHBuilt 1970 · S/N 1517RN881FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0204N882FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0208N882KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 802A-0832N883CRHoffman Travis K · Maroa, ILS/N 83N883FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0210N884DMQs 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-136N888FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0217N888HBAgri Air Industries Of Arkansas LLC · Paragould, ARBuilt 2021 · S/N 802A-0880N888WGJ & 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 493N88HRHansen Ranches LLC · Corcoran, CABuilt 1998 · S/N FL-225N88XJN88xj LLC · Park Ridge, ILBuilt 1998 · S/N LJ-1525
Back to AD 2016-05-13