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.

N854CMHeritage Aviation Management Ltd · Conroe, TXBuilt 2001 · S/N 208B0908N854FAAdams Aerial Solutions LLC · Decatur, ILBuilt 2024 · S/N 802A-1130N85516United States Department Of State · Melbourne, FLBuilt 1993 · S/N UE-61N855FEAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0203N855LAWilmot Airplane Ventures LLC · Mer Rouge, LABuilt 2022 · S/N 802A-0952N856FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0176N857FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0177N858AAAg Aviation Inc · Muleshoe, TXBuilt 2019 · S/N 802A-0798N858FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0178N858MAMess Aero Inc · Grand Forks, NDBuilt 1997 · S/N 20800262N859FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0181N85CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0125N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498N85LGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N LJ-1487N85TKStreamline Aviation LLC · Leawood, KSBuilt 2002 · S/N 4697128N860AR412 Jw Aviation LLC · Dover, DEBuilt 1990 · S/N 36019N861FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0183N861MAAerodynamics Worldwide Inc · Wilmington, DEBuilt 2000 · S/N 208B0825N861PPIrlbeckbruch Plane LLC · York, NEBuilt 2003 · S/N 510N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493N862FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0184N862KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 802A-0826N863FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0186N863MAMartinaire Aviation LLC · Addison, TXBuilt 2004 · S/N 208B1049N864SFAlaska Skypower LLC · Fairbanks, AKBuilt 2000 · S/N 208B0864N865DKKubecka Daniel P · Edna, TXBuilt 2022 · S/N 802A-0964N865FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0188N865MASchuman Carriage Co Ltd · Honolulu, HIBuilt 2002 · S/N 208B0996N865NFNew Frontier Aviation LLC · Fort Benton, MTBuilt 2012 · S/N 802A-0453N866FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0189N866KMMac Aviation LLC · Fargo, NDBuilt 2003 · S/N 528N867BFBunkie Flying Service Inc · Bunkie, LABuilt 2015 · S/N 802-0595N867FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0191N867HCNe Ia Helicopter LLC · Tekamah, NEBuilt 2015 · S/N 802-0615N867HPCaravan International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0252N869FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0195N869HCPlane LLC · Grove, OKBuilt 2012 · S/N 802-0475N869SSWells Flying Services LLC · Holdrege, NEBuilt 2017 · S/N 802-0696N869XATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0869N870A & S Aviation LLC · Chesterfield, MOBuilt 1993 · S/N 607N870BBBottoms Up Flying LLC · Gould, ARBuilt 2023 · S/N 802A-1087N870CBRaci Management Company Inc · Ogden, UTBuilt 2005 · S/N 657N870ESPrecision Air LLC · Dermott, ARBuilt 2025 · S/N 802A-1256N870FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0196N870HFHutcherson Flying Inc · Forrest City, ARBuilt 2024 · S/N 802A-1176N870JTBeta Fleet LLC · South Burlington, VTBuilt 2021 · S/N 802-0870N870JWRice Ag Service Inc · Brinkley, ARBuilt 2025 · S/N 802A-1254N870LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802-0270N870MRRice Ag Service Inc · Brinkley, ARBuilt 2022 · S/N 802A-0999N870SSRice Ag Service Inc · Brinkley, ARBuilt 2024 · S/N 802A-1179
Back to AD 2016-05-13