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.

N993TATunica Air Inc · Tunica, MSBuilt 2017 · S/N 802A-0722N994CFKk 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 208B0133N995MCCaprock Spraying Inc · Vega, TXBuilt 2016 · S/N T65HG-028N995MKAviation 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 208B0135N996JBReabe Spraying Service Inc · Plover, WIBuilt 2010 · S/N 602-1182N996QCHds 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 BB217N998FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0139N999FNWing Air LLC · Orinda, CABuilt 2022 · S/N K033N999NGLiadair Inc · Wilmington, NCBuilt 2000 · S/N 4697022N999RWFederal Investors Servicing Corp · Capitan, NMBuilt 2001 · S/N 4697037N999VBJet Air Inc · Galesburg, ILBuilt 1995 · S/N BB-1506N999ZGCfc LLC · Bloomington, INBuilt 2012 · S/N FL-814N99ACRejo Inc · Wilmington, DEBuilt 1974 · S/N LW-120N9GAN9ga Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1719N9MSModification Specialists LLC · Johnson, KSS/N 001N9NXTalkeetna Aero Services Inc · Anchorage, AKS/N 20800129N9UEDakota Commercial & Development · Grand Forks, NDBuilt 2002 · S/N 224
Back to AD 2016-05-13