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.
N96928Jurkowski Raymond · Germantown, NYN96929Ware Joseph B · Angleton, TXN9692BAberdeen Flying Service · Aberdeen, SDN9692THarbaugh Eric M · Russell, KSN9692VShow Low Flight Academy LLC · Show Low, AZN9692YA Viation Inc · Bennettsville, SCN96932Valiair Lc Trustee · Casper, WYN9693HClear Creek Aviation LLC · Buffalo, WYN9693QHughes Ronnie D · Cedar Park, TXN9693VRabideau William J III · Stafford Springs, CTN96943Porta Michael W · Old Bridge, NJN96949Pittman William Greg · Anchorage, AKN9694AOgilvie Adam P · Loveland, CON9694HFitch William R · Dubuque, IAN9694LCivil Air Patrol Inc · Maxwell Afb, ALN9694QBexbach North America LLC · Reno, NVN9694TGarza Gilberto · Yuma, AZN9694VHaller Patrick C · York, SCN9694XDawson Timothy E · Dahlonega, GAN96952Gospel Ministries International · Collegedale, TNN9695HGoddard Robert J · Haverhill, MAN9695XHam Robert · El Cajon, CAN96968Shaw Stephen A · Sherwood, ORN9696FShakman Michael L Trustee · Chicago, ILN9696HMirror Image Inc · Belgrade, MTN9696LAny Border LLC · Yankton, SDN9696TJ & F Aviation Adventure LLC · North Fort Myers, FLN96977Couch Christopher · Huntertown, INN9697QCaltagirone Peter J · Lewes, DEN9697VWestern Edge Aviation LLC · Dickinson, NDN96988Wenner Aaron · Tehachapi, CAN9698EPark Rapids Avionics Inc · Park Rapids, MNN9698GCash Jeffery Scott · Gresham, ORN9698HEagle Simulator LLC · Lake Oswego, ORN9698VVermont Flight Academy Inc · South Burlington, VTN96991Johnson Kirk · Klamath Falls, ORN9699GCruikshank Brian S · Portland, ORN9699HDamschroder Rex A · Fremont, OHN9699TBas Part Sales LLC · Greeley, CON9699VPiercy Danille Marie · North Bay Village, FLN969FGMustang Sally Aviation LLC · Camden, SCN969JHJls Aviation LLC DBA · Fredericksburg, VAN969KMSk Aircraft LLC · Anchorage, AKN969LTUniversity Of La System DBA · Ruston, LAN969RBK Fortner LLC · San Marcos, TXN969RM182 LLC · Battle Ground, WAN969RRDodson International Parts Inc · Rantoul, KSN969SBBostyancic Stanley J · Cohasset, MNN969SLWojcik Bart C · Kimberly, IDN969SPB R S Leasing Inc · Wilmington, DE
Back to AD 79-10-14 R1