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.
N474AARegistered aircraftN474BFDodson International Parts Inc · Rantoul, KSN474CMUniversity Of Central Missouri · Warrenburg, MON474DNBravo Ag Air LLC · Belmond, IAN474EPSunshine Holding LLC · Danbury, CTN474HAHutch Aviation Inc · Zavalla, TXN474KPFaith Norman E Jr · El Dorado, ARN474SMPinnacle Aviation Services Inc · Encinitas, CAN474SPJads Aviation LLC · Rowlett, TXN474TBDr Daniel Brancheau Pllc · Fenton, MIN4750BConley Michael A · Mount Blanchard, OHN4750DGraves Frank C · Nocona, TXN4750FSouth Dakota Skydivers Inc · Sioux Falls, SDN4750NSaez Brian · Gilboa, NYN4750QDelaware C Plane Inc · Wilmington, DEN4750UHancock Stephen E · Yulee, FLN4750XSc Aircraft LLC · Copper Canyon, TXN4751BRegistered aircraftN4751DMoore Johnathan D · Guymon, OKN4751GJeff Air Pilot Services LLC · Shelbyville, INN4751QHofer Bruce L · Freeman, SDN4751UPlano Daniel W · Willow, AKN4752CShannon Alton P · Intl Falls, MNN4752QBrown Timothy L · Liberty Lake, WAN4752RCondors Flight LLC · Orlando, FLN4753FRobertson Robin L · Murfreesboro, TNN4753NSimmons Todd B · Cowley, WYN4753UTurchan Robert H · Scottsdale, AZN4753XUpstate Flying Club Inc · Marcy, NYN4754EJrm Property LLC · Taylors, SCN4754NBrentco Aerial Patrol Inc · Canton, OHN47559Valiair Lc Trustee · Casper, WYN4755QCook Alfred M · Juneau, AKN4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4756DVertical Investment Strategies LLC · Henderson, NVN4756EAero Missions Inc · Sylacauga, ALN4757DCalhoun Gerrald E · Leesburg, FLN4757EHoogendorn Homer E · Wasilla, AKN4757FMulcaire Jess E · Camp Verde, AZN4757NTwin Falls Fliers Inc · Twin Falls, IDN4757QKroenke Seth M · Palmer, AKN4757UPj Aviation LLC · Eden Prairie, MNN4757XFountain John D Jr · Lynchburg, SCN4758BJaars Inc · Waxhaw, NCN4758DBurt William G · Tullahoma, TNN4759BHoover Michael B · Ridgeland, WIN4759ERatcliff Stephen B · Anchorage, AKN4759GSanders Flight Training Center Inc · Jasper, ALN4759NMitchell Robert L · Presque Isle, MIN4759QPease Robert J · Anchorage, AK
Back to AD 79-10-14 R1