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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N34RFRed Tail Fox LLC · Fort Wayne, INN364WBWayne Ross Biddell · Oklahoma City, OKN375KSWestside Strategic Aviation LLC · Las Vegas, NVN38BEBoone Aviation LLC · Zionsville, INN38CDMilestone Consulting LLC · Glendale, AZN390MAKenmore Crew Leasing Inc Trustee · Bellingham, WAN406SMile High 1 LLC · Lakeway, TXN408WYStorey Aviation LLC · Cheyenne, WYN411JPBluffside Aero LLC · Williamsburg, VAN416RLAnderson Doug · Blanco, TXN418MAAei Air LLC · Lander, WYN41MKEric Leasing LLC · London, KYN41TJ874 Place Limited · Uniontown, OHN444TBMagic Wheel Holdings LLC · New Braunfels, TXN460PFMonarch Aviation LLC · Dillon, MTN460SHMeier & Hartwig Management LLC · Wilmington, DEN464RKSvr Transportation LLC · Burnet, TXN465MAFbf Aviation LLC · Perry, FLN46TCapvo LLC · Yoakum, TXN471MMVivoli Daniel Frank · Las Vegas, NVN48FGNacairways LLC · Nacogdoches, TXN490YRDevone Adam · Lake Forest, CAN4922XHowey Aviation LLC · Woodhaven, MIN492STSimons Harlan W III · Valencia, PAN49TWMulton Nutritional Services Inc · Kearney, NEN501RLRpg Aviation LLC · Myrtle Beach, SCN509JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN519TLAviation Trust Co LLC Trustee · Oklahoma City, OKN53PMDaniele Aviation LLC · Rochester, NYN5559WWuertz William J · Bozeman, MTN56PVValiair Limited Company Trustee · Casper, WYN576DDUp Aero LLC · Williamsburg, OHN584LPM J Price Construction Co Inc · Roanoke Rapids, NCN584MMIsland Flyers LLC · Apopka, FLN600AEPlanecents LLC · Mooresville, NCN600AYRegistered aircraftN600BJHighland Machinery Inc · Benton Harbor, MIN600BTAscend Aviation LLC · Columbus, OHN600DTJw Leasing LLC · Fargo, NDN600ETJ And J Aviation LLC · Souderton, PAN600EVLfw Investments LLC · Hillsborough, NCN600FLKnoxville Capital Holdings Inc · Knoxville, TNN600GHRegistered aircraftN600GPSchiffer Herbert · West Chester, PAN600JAJav Enterprises LLC · Broomfield, CON600MKJt Executive Properties LLC · Frost, TXN600MULunar Society LLC · Cambridge, MAN600NMRaafs Nest LLC · St George, UTN600NVSunshine Partners Socal LLC · Incline Village, NVN600PJAj18 Holdings LLC · Boca Raton, FL
Back to AD 2017-16-03