AD 2016-08-18
Registered aircraft · 399
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-08-18')
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-08-18')
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:2016-08-18') 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-08-18') 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.
N356DBCaldwell Island LLC · Sherborn, MAN357SAFox Aircraft LLC · Wasilla, AKN3582PAir Arctic Inc · Fairbanks, AKN35834Carto-Flight · Willoughby, OHN3587PMsm587p LLC · Jericho, NYN35890Ja Aero LLC · Chicago, ILN3589BAir Arctic Inc · Fairbanks, AKN3589XMarc Inc · Bolton, MSN3590BTranquil Air LLC · Lighthouse Point, FLN3590DSale Reported · Xxx, OKSale reported, canceledN35RDIngersoll Grove LLC · Springfield, MAN369KJGrace Aire Inc · Corpus Christi, TXN36PBMarin Pacific International LLC · Apple Valley, CAN371MCSale Reported · Palm City, FLSale reportedN3746PSale Reported · Fort Lauderdale, FLSale reported, canceledN376NCLima Delta Company Trustee · New Castle, DEN385RMG Force Air LLC · Columbus, OHN38KCChanney Aviation Group LLC · Las Vegas, NVN38MCGulf Air Aviation · Wilmington, DEN3VMAztec Worldwide Airlines Inc · Wilmington, DEN400HMBarneys Services Inc · Newton, IAN400RAJacko Josh E · Anchorage, AKN4023Maighnath Melissa · Jamaica, NYN403RGGkids Holdings LLC · New York, NYN4043MPremier Air Charters Inc · Coram, NYN404ABcj LLC · Haines City, FLN4072LN4072l LLC · Conroe, TXN4073LColumbia Asset Trust Corp Trustee · Wichita, KSN4074FMy Flyers LLC · Valley Stream, NYN4076TMike Jones Aircraft Sales Inc · Murfreesboro, TNN4078BDodson International Parts Inc · Rantoul, KSN4078JStar Marianas Air Inc · Tinian, MPN40796Grant Aviation Inc · Anchorage, AKN4079HWarbelow'S Air Ventures Inc · Fairbanks, AKN4082TWarbelows Air Ventures Inc · Fairbanks, AKN4083W13 Aviation LLC · Leesburg, GAN4086EJj Aviation LLC · Allentown, PAN40872Ole South Aviators LLC · Athens, GAN4087CSherry-Aire LLC · Sidney, MTN4087KAggie Air Inc · Clifton, TXN4090UIsland Bound LLC · Dunedin, FLN40919Asb1 Group LLC · Miramar, FLN4095YLakeland Air 6 LLC · Lakeland, FLN40978Dodson International Parts Inc · Rantoul, KSN4097KSwag Aviation LLC · Labelle, FLN4098AJaa Holdings LLC · Springfield, ILN40992Awmr LLC · Conroe, TXN4101NGateway Of Sturgis LLC · Sturgis, MIN4102JCarto Flight Inc · Willoughby, OHN4104KStar Marianas Aviation School Inc · Tinian, MP
Back to AD 2016-08-18