OpenAirDocs.org
AD 2019-10-06

Registered aircraft · 419

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

N103MAMinor Sam M · Volga, SDS/N 3085N105RJSell Shannon Carl · Hoschton, GABuilt 2014 · S/N 3225N10AEEllison Alan T · Burien, WABuilt 2018 · S/N 3311N10AXTexas Vtol LLC · Houston, TXBuilt 2021 · S/N 3371N10FHThro Flight Inc · Boca Raton, FLBuilt 2024 · S/N 3439N10HUKentucky Taildraggers LLC · Louisville, KYBuilt 2018 · S/N 3310N110MASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3060N112RJTobul James R · Jackson, WYBuilt 2014 · S/N 3226N116RJRegistered aircraftS/N 3227N118WYNemitz Anthony M · Jackson, WYBuilt 2014 · S/N 3208N119RJHunter Briard L · Detroit Lakes, MNS/N 3229N119WYHusky N119wy LLC · Missoula, MTBuilt 2014 · S/N 3209N11AHHilltop Aviation LLC · Dauphin, PABuilt 2020 · S/N 3355N11HUC5 Holding LLC · San Juan, PRBuilt 2024 · S/N 3430N11HYSpa Aero LLC · Helena, MTBuilt 2011 · S/N 3135N11YHSpa Aero LLC · Helena, MTBuilt 2022 · S/N 3403N124SLSl Aviation LLC · Kalispell, MTBuilt 2021 · S/N 3382N125GSelvis LLC · Missoula, MTBuilt 2018 · S/N 3315N125WYNorthstar Aerospray Inc · Clara City, MNBuilt 2010 · S/N 3098N1283Mcmillian Rex C · Roseburg, ORS/N 3314N12HDMorotti John · Polson, MTBuilt 2022 · S/N 3401N12YCCedarview Airport Investments LLC · Orlando, FLBuilt 2022 · S/N 3395N134BWRussell Schwendiman Farms Inc · Ririe, IDBuilt 2011 · S/N 3134N134DDN134dd LLC · Parsons, KSBuilt 2008 · S/N 3015N135JWMackay Matthew · Deer Park, WABuilt 2016 · S/N 3267N135MAAppel Joshua · Wasilla, AKBuilt 2008 · S/N 3034N137DCThompson Joseph D · Alliance, NEBuilt 2017 · S/N 3278N139MWhitney Richard T · Steamboat Springs, COBuilt 2015 · S/N 3239N13BFWygant Steven J · Copper Center, AKBuilt 2008 · S/N 3021N13HCFultz Robert C IV · Morgantown, PABuilt 2023 · S/N 3407N13QMHerrick Eugene · Chicago, ILS/N 3042N13SNExplore 406 LLC · Kalispell, MTBuilt 2009 · S/N 3054N141USDunkerley Mark · Washington, DCS/N 3059N143EEFour Bs Montana Ranch LLC · Kalispel, MTBuilt 2014 · S/N 3218N146HGMaloney Leasing LLC · Tupelo, MSS/N 3146N14AHEper Wings Avio Inc · Livingston, MTBuilt 2018 · S/N 3308N14HYLammle Greg · Fargo, NDBuilt 2019 · S/N 3327N14YSAviat Aircraft Inc · Afton, WYS/N 3473N152CWRegistered aircraftS/N 3248N154ZJAttitude Aerobatics LLC · Wilmington, DEBuilt 2018 · S/N 3312N157MAMaronick Richard · East Helena, MTBuilt 2012 · S/N 3167N15GFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2019 · S/N 3324N15HYS&S Aviation LLC · Oakley, UTS/N 3328N15NGAviat Aircraft Inc · Afton, WYBuilt 2013 · S/N 3189N15WYAviat Aircraft Inc · Afton, WYS/N 3092N162MAHearne Scott N · Powderly, TXBuilt 2009 · S/N 3056N16HCPrivate Consulting Partners LLC · Boynton Beach, FLBuilt 2022 · S/N 3399N16TTGeronimo Aerosport LLC · Dover, DEBuilt 2018 · S/N 3304N16WYAbbott Thomas B · Portland, MEBuilt 2010 · S/N 3100N16WZRud Gilman E · Coronado, CABuilt 2008 · S/N 3017
Back to AD 2019-10-06