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.
N96844Flying Truckster LLC · Denver, CON9684QOgden Laurence B · Weaverville, NCN9684TKobe Thomas J · Lake Placid, FLN96852Inland Northwest Flyers LLC · Spokane Valley, WAN9685BJones Jason B · Anchorage, AKN9685GAltitude Asset Management LLC · Waukesha, WIN9685HBoys Will Fly LLC · Mapleton, UTN9685TBas Part Sales LLC · Greeley, CON9685VBlue Skies Aviation Of Wisconsin Inc · Pulaski, WIN96867Skywarrior Flight Training Inc · Pensacola, FLN9686HHope Lapsley G · Blountville, TNN9686QPetter John W · Wallis, TXN9686XMclenaghan Alvin N · Phoenix, AZN96879Gc Aviation Services-1 LLC · Miamisburg, OHN9687AHolbrook James A · Burnet, TXN9687EFrohbieter Jack A · Newtown, PAN9687HBell Gary E · Bend, ORN9687QBron Chris R · Springfield, ILN9687TPractical Software Solutions Inc · Windsor, CON9687VCothron Walter A · Angleton, TXN96883Knash Partners Nwa LLC · Summers, ARN96885Chord Line LLC · East Hampton, NYN9688ASmith Herschel C III · Panama City, FLN9688QF And W Flyers Inc · Newman, ILN9688XDrm Aviation LLC · Glencoe, ALN96890Llewellyn James R · Bainbridge Island, WAN96893Neu Rick L · Kingwood, TXN9689BCoffin Robert H · Wasilla, AKN9689QOptic Air LLC · Sioux Center, IAN9689TSutphen Clinton M · Saint Hedwig, TXN968AAWings Over Texas Holdings LLC · Denton, TXN968CPCivil Air Patrol · Maxwell Afb, ALN968HCMarsh Flying Services LLC · El Dorado, KSN968KOpheim Kurt · Minnetrisia, MNN968LLewis University · Romeoville, ILN968LTUniversity Of La System DBA · Ruston, LAN968RCAmelia Reid Aviation LLC · San Jose, CAN968SPMindy Limited LLC · Muscatine, IAN96906Nulisch Justin · Del Rio, TXN9690HConner Mark H · Wauna, WAN9690QRobinson Neil A · Madison, WIN9690VAlbrecht William J Jr · Greenville, NCN96911Luciano Edmund R · Anchorage, AKN96919Mckitrick Brad L · West Jefferson, OHN9691ABernette Allan E · Wisconsin Rapids, WIN9691BRegistered aircraftN9691GFox Michael F · Hernando, FLN9691VNewman Philip · Georgetown, TXN9691ZSouth America Mission Inc · Fort Mill, SCN96923Green David C · Milford, IA
Back to AD 79-10-14 R1