AD 2017-16-03

Registered aircraft · 188

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:2017-16-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-16-03')
  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.

N34RFRed Tail Fox LLC · Fort Wayne, INBuilt 2016 · S/N 4698019N364WBWayne Ross Biddell · Oklahoma City, OKBuilt 2022 · S/N 4698208N375KSWestside Strategic Aviation LLC · Las Vegas, NVBuilt 2017 · S/N 4698045N38BEBoone Aviation LLC · Zionsville, INBuilt 2018 · S/N 4698070N38CDMilestone Consulting LLC · Glendale, AZBuilt 2021 · S/N 4698171N390MAKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2017 · S/N 4698052N406SMile High 1 LLC · Lakeway, TXBuilt 2022 · S/N 4698217N408WYStorey Aviation LLC · Cheyenne, WYBuilt 2020 · S/N 4698154N411JPBluffside Aero LLC · Williamsburg, VABuilt 2022 · S/N 4698229N416RLAnderson Doug · Blanco, TXBuilt 2016 · S/N 4698016N418MAAei Air LLC · Lander, WYBuilt 2017 · S/N 4698043N41MKEric Leasing LLC · London, KYBuilt 2023 · S/N 4698247N41TJ874 Place Limited · Uniontown, OHBuilt 2017 · S/N 4698058N444TBMagic Wheel Holdings LLC · New Braunfels, TXBuilt 2020 · S/N 4698143N460PFMonarch Aviation LLC · Dillon, MTBuilt 2018 · S/N 4698066N460SHMeier & Hartwig Management LLC · Wilmington, DEBuilt 2021 · S/N 4698179N464RKSvr Transportation LLC · Burnet, TXBuilt 2017 · S/N 4698044N465MAFbf Aviation LLC · Perry, FLBuilt 2021 · S/N 4698170N46TCapvo LLC · Yoakum, TXBuilt 2021 · S/N 4698159N471MMVivoli Daniel Frank · Las Vegas, NVBuilt 2022 · S/N 4698228N48FGNacairways LLC · Nacogdoches, TXBuilt 2020 · S/N 4698148N490YRDevone Adam · Lake Forest, CABuilt 2018 · S/N 4698096N4922XHowey Aviation LLC · Woodhaven, MIBuilt 2023 · S/N 4698289N492STSimons Harlan W III · Valencia, PABuilt 2020 · S/N 4698155N49TWMulton Nutritional Services Inc · Kearney, NEBuilt 2023 · S/N 4698288N501RLRpg Aviation LLC · Myrtle Beach, SCBuilt 2019 · S/N 4698120N509JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 4698223N519TLAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2022 · S/N 4698232N53PMDaniele Aviation LLC · Rochester, NYBuilt 2020 · S/N 4698137N5559WWuertz William J · Bozeman, MTBuilt 2021 · S/N 4698193N56PVValiair Limited Company Trustee · Casper, WYBuilt 2021 · S/N 4698162N576DDUp Aero LLC · Williamsburg, OHBuilt 2022 · S/N 4698215N584LPM J Price Construction Co Inc · Roanoke Rapids, NCBuilt 2023 · S/N 4698279N584MMIsland Flyers LLC · Apopka, FLBuilt 2019 · S/N 4698105N600AEPlanecents LLC · Mooresville, NCBuilt 2022 · S/N 4698206N600AYRegistered aircraftBuilt 2020 · S/N 4698147N600BJHighland Machinery Inc · Benton Harbor, MIBuilt 2016 · S/N 4698007N600BTAscend Aviation LLC · Columbus, OHBuilt 2016 · S/N 4698004N600DTJw Leasing LLC · Fargo, NDBuilt 2018 · S/N 4698068N600ETJ And J Aviation LLC · Souderton, PABuilt 2019 · S/N 4698114N600EVLfw Investments LLC · Hillsborough, NCBuilt 2020 · S/N 4698126N600FLKnoxville Capital Holdings Inc · Knoxville, TNBuilt 2017 · S/N 4698056N600GHRegistered aircraftBuilt 2017 · S/N 4698037N600GPSchiffer Herbert · West Chester, PABuilt 2022 · S/N 4698205N600JAJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 4698097N600MKJt Executive Properties LLC · Frost, TXBuilt 2022 · S/N 4698238N600MULunar Society LLC · Cambridge, MABuilt 2017 · S/N 4698030N600NMRaafs Nest LLC · St George, UTS/N 4698182N600NVSunshine Partners Socal LLC · Incline Village, NVBuilt 2018 · S/N 4698087N600PJAj18 Holdings LLC · Boca Raton, FLBuilt 2018 · S/N 4698078
Back to AD 2017-16-03