AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N92208Full Throttle Aviation LLC · Nashville, ARN92209Stanton Gregory R Jr · Newport, ORN9220ABrown Douglas C · Daytona Beach, FLN92214Sfh Aviation LLC · Birmingham, MIN92215Indian Lakes Aviation LLC · Cedar Springs, MIN9221CCruson Michelle E · Ontario, ORN9221XBoettger Gordon R · Carson City, NVN9222Erkmann Christopher R Trustee · Chesterfield, MON92228Dhs Operations LLC · Wilmington, DEN9222AMccully Kevin W · Payson, AZN9222BGilreath Steven M · Anderson, SCN9222CHall Vincent P · San Diego, CAN9222HDhs Operations LLC · Wilmington, DEN9222UJdl Services LLC · Centreville, MDN9222XJones Margaret C · San Marcos, TXFirst renewal noticeN9223ABrossard Adam · Olalla, WAN9223CDhs Operations LLC · Wilmington, DEN9223EDhs Operations LLC · Wilmington, DEN9223GWilson John L · Winchester, KYN9223HHallock Robert C III · Sag Harbor, NYN9223XDhs Operations LLC · Wilmington, DEN9224AGauman Dylon M · Wasilla, AKN9224GB9224g LLC · Carthage, NCN92255Kloker Daniel E · Owasso, OKN9225APeterson Scott W · Garfield, KSN9225B25/25 LLC · Pinedale, WYN9225UPrecise Flight LLC · Waukesha, WIN9225XMenix Travis L · Russell Springs, KYN92262William Syme Alexander Howie Trustee · Bozeman, MTN92264Dhs Operations LLC · Wilmington, DEN92265Futchagribusiness LLC · Broxton, GAN92266Dhs Operations LLC · Wilmington, DEN9226ASchmidt James W · Dousman, WIN9226GLefevre Jonathan W · Haskell, TXN9226HDebt LLC · Yuma, AZN9226UMcnamara Gavin E W · Rancho Cucamonga, CAN9226XJjm3 LLC · Twin Falls, IDN92277Whiskey Bravo Investments LLC · Bulverde, TXN92280Look To The Sky LLC · Middletown, DEN92281Jera Aviation LLC · Brooksville, FLN92282Registered aircraftN92286Wpr Group LLC · Clinton, MSN9228GDouthitt Kevin S · Long Bch Twp, NJN92291Media Stew LLC · Carson City, NVN92298Ponderosa Aviation LLC · Safford, AZN92299Barxbar Aviation LLC · Mesa, AZN9229APotter Gary W · Abilene, TXN9229FCooke John W III · Carthage, TXN9229GKhademi Amin · Chino Hills, CAN9229TLorenzen Kraig E · Pagosa Springs, CO
Back to AD 79-10-14 R1