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.

N802WFColdwater Enterprises LLC · Wynne, ARBuilt 2018 · S/N 802-0746N802WLEagle Lake Leasing LLC · Bradford, ARBuilt 2018 · S/N 802A-0753N802WMAero Seat Inc · Sterling, COBuilt 2020 · S/N 802A-0824N802WPPorter Flying Service Inc · Chico, CABuilt 1998 · S/N 802A-0074N802WWPorter Flying Service Inc · Chico, CAS/N 802A-0434N802YBS&H Aviation LLC · Robstown, TXBuilt 2022 · S/N 802A-0933N802ZWWallin Michael L · Walnut Ridge, ARBuilt 2015 · S/N 802A-0591N8033NAufderheide Flying Service Inc · Dewitt, ARBuilt 2017 · S/N 802A-0701N8036ATensas Flying Service LLC · Saint Joseph, LABuilt 2018 · S/N 802A-0760N8038VNeal Aircraft Inc · Slaton, TXBuilt 2018 · S/N 802A-0766N80393Echo Fox Leasing LLC · Wilmington, DEBuilt 2018 · S/N 802A-0768N8039MSwing Wing Inc · Veedersburg, INBuilt 2023 · S/N 802A-1004N803AALocker Fred · Muleshoe, TXBuilt 2012 · S/N 802A-0455N803ARSparkys Aeronautical Holdings Inc · Dover, DEBuilt 2021 · S/N 802A-0893N803ASRice Flying LLC · Poplar Bluff, MOBuilt 2024 · S/N 802-1096N803CHTensas Aviation LLC · Lewes, DEBuilt 2022 · S/N 802A-0943N803FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2022 · S/N 802A-0994N803HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2016 · S/N 802A-0635N803HMH And M Flyuing Service LLC · Osceola, ARBuilt 2019 · S/N 802A-0813N803JACaravan Flight Services LLC · Bayside, NYBuilt 1985 · S/N 20800016N803JFBff Aviation LLC · Paragould, ARBuilt 2013 · S/N 802A-0519N803KAAnderson Flying Service LLC · Covington, TNBuilt 2022 · S/N 802-0955N803KPT & M Aircraft LLC · Monticello, ILBuilt 2012 · S/N 802-0470N803LMMorrison Lynn · Vernon, TXBuilt 2016 · S/N 802A-0663N803MAG B Aerial Applications Inc · Slaton, TXBuilt 2000 · S/N 802A-0093N803SEA & M Flying Service Inc · Carlisle, ARBuilt 2024 · S/N 802A-1166N803VTesk Aviation LLC · Steele, MOBuilt 2024 · S/N 802A-1148N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724N8040GBaylee Company · Bear, DEBuilt 2024 · S/N 802A-1099N8040LGregs Crop Care Co Inc · Wilbur, WABuilt 2017 · S/N 802A-0706N80416Ckw Aviation LLC · Dalhart, TXBuilt 2023 · S/N 802A-1046N8042YMorris Equipment LLC · Yuma, AZBuilt 2017 · S/N 802A-0691N8043FMeyer Bros Ag LLC · Algona, IABuilt 2020 · S/N 802A-0820N8046EAllard Evan Wade DBA · Vinita, OKBuilt 2016 · S/N 802A-0664N8049ABank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 802A-0790N804AARice Flying LLC · Poplar Bluff, MOBuilt 2017 · S/N 802-0698N804BFCkw Aviation LLC · Dalhart, TXBuilt 2019 · S/N 802A-0815N804CTCottonwing Air LLC · Indianola, MSBuilt 2021 · S/N 802A-0919N804DGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1999 · S/N 802A-0089N804FARainey Aerial Ag Service Inc · Obion, TNBuilt 2024 · S/N 802-1150N804FEFederal Express Corporation · Memphis, TNS/N 208B0039N804HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2017 · S/N 802A-0710N804HMH And M Flying Service LLC · Osceola, ARBuilt 2024 · S/N 802A-1105N804JHRocky Mountain Boat Co · Pueblo West, COBuilt 2001 · S/N 4697044N804KPAir-Worthy Inc · Lyon, MSBuilt 2013 · S/N 802A-0496N804MANew Frontier Aviation LLC · Fort Benton, MTBuilt 1996 · S/N 802-0026N804MWWoodard Flying Service Inc · Corning, ARBuilt 2022 · S/N 802A-0948N804RATwist Air LLC · Turrell, ARBuilt 2015 · S/N 802A-0617N804SESummer Agro Services LLC · Royal Palm Beach, FLBuilt 2025 · S/N 802A-1209N804THPa1 208b-0421 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0421
Back to AD 2016-05-13