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.
N70022Linford Robert M · Spokane, WAN70026Stephens Brandon J · North Pole, AKN7002AAustin James M · Fort Worth, TXN7002EHickle William H · Inyokern, CAN7002FMcdonald Timothy M · Meredith, NHN7002MApte John W · Biddeford, MEN70032Alpha Wings Inc · Willoughby, OHN70037Bancroft Contracting Corporation · South Paris, MEN7003AHuang Sophie M · Newcastle, WAN7003EIndy Air Sales LLC · Anderson, INN7003KSky West Aviation Inc Trustee · Albuquerque, NMN70046Zane Newton F · Rllng Hls Est, CAN70048Trident Resources LLC · Chino Valley, AZN7004AMitchell Mark A · Pittsford, NYN7004EBoughan Patrick W · Vail, CON7004GMcgreen John R · Albany, NYN70052Hastings Heidi · Wasilla, AKN7005AStansell Clayton H · Los Lunas, NMN7005FUS Flight Academy International Inc DBA · Post, TXN7005GHamilton Peter D · Bear, DEN7005QCentral Arkansas Flying Club Inc · Bryant, ARN7005TSmith Roy B · Newland, NCN70063Welch Thomas R DBA · Modesto, CAN7006AFletcher John G · Diamondhead, MSN7006ELienke Kevin E · Beaver Dam, WIN7006QToney Edward L · Hampton, GAN7006SSpicer Greg · Portage, MIN7006TFraas Stephan H · Meriden, CTN70070Bay Air Inc · Dillingham, AKN70071Bender Charles A Jr · Orrstown, PAN7007MDouble 07 Mike Flyers Inc · Kalispell, MTN7007SJw Air Ventures LLC · New Smyrna Beach, FLN70083Air Pacific LLC · Port Angeles, WAN70084Bridges Pamela J · Calais, MEN70085Embley Kenneth · Anchorage, AKN7008AMitchell Shawn J · Red Bluff, CAN7008SPoe John B · Port Orange, FLN7008TDelaney Patrick James · Marion, TXN70091Franke Gordon D · Anchorage, AKN70095Eastern Kentucky University · Richmond, KYN70097Family Air Tours LLC · Ketchikan, AKN7009ESutton Aircraft Salvage LLC · Palmer, AKN7009QJoiner Legacy Enterprises LLC · Joliet, MTN7009TCrigler Christopher E · Warrenton, VAN700AGMash Kity J LLC · Grand Rapids, MIN700AMInternational Air Services Inc Trustee · Carson City, NVN700CDCrahen William F · Merrimac, WIN700PDAero Survey LLC · Lake Havasu City, AZN700PJShort Stephen A · Lake Placid, NYN700PMRar LLC · Louisville, KY
Back to AD 79-10-14 R1