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.
N4967DSchmieding Michael A · Salem, ORN4967FMile Hi Skydivers Inc · Longmont, CON4968AD&B Aircraft Leasing LLC · Anchorage, AKN4968DNelson Scott D · Blackfoot, IDN4968NConfarotta Todd A · Mount Pleasant, SCN4968UGreen Brandon K · Eufaula, ALN4969DFarwick Kobbe L · Lenexa, KSN4969ECapricorn Equipment Co · Madisonville, KYN4969GSanford Aircraft LLC · Winter Springs, FLN4969NGreen Michael P · Thomaston, CTN4969RUnited States Air Force Owner · Offutt Afb, NEN4969UTallgrass Aviation LLC · Sharon Springs, KSN496EREmbry-Riddle Aeronautical University · Daytona Beach, FLN496HMTalon Air Service Inc · Soldotna, AKN496SPWingsleasing LLC · Wichita, KSN4970ANervino David J · Hilmar, CAN4970DMayes Nicholas R · Williams, CAN4970QPettis Ag Aviation LLC · Atlantic, IAN4971ATruman Sparks Aviation LLC · Wink, TXN4971DBolin William E · Smithville, OHN4971FRegistration Pending · Cottonwood, CARegistration pendingN4971GSuper Hawk Inc · West Jordan, UTN4971RScherer Sid S · Napa, CAN4971VGorman John Scott · Homosassa, FLN4972AHighsmith Alfred C · Burgaw, NCN4972DPaulsden LLC · Caldwell, IDN4972FTomahawk Aviation LLC · Reno, NVN4972GMcchuck Properties LLC · Pensacola, FLN4972NEllis Michael J · East Wenatchee, WAN4972QAdams David G · Knoxville, TNN4972RUnited States Air Force · Apo, APN4973DKilo Aviation LLC · East Peoria, ILN4973FBoraam Aviation Inc · Prospect Heights, ILN4973UFlightpath Leasing LLC · Tallahassee, FLN4974DPatton John W · Mancos, CON4974GPea-Wayman Flight LLC · Daytona Beach, FLN4974NCivil Air Patrol Inc · Maxwell Afb, ALN4974RMcpherson Marvan T · Oklahoma City, OKN4975FFg Aviation LLC · La Jolla, CAN4975GBermuda Dunes Flight Training LLC · Palm Desert, CAN4975NRegistered aircraftN4975VMiller David M · Fort Worth, TXN4976DConstenius Kurt N · Tucson, AZN4976FLytle John A · Anaheim, CAN4976GOklahoma Airmen Flying Club Inc · Jenks, OKN4976NMerlin Aviation LLC · Palisade, CON4976UMoro Jim · Naples, FLN4976VPlane Fun Inc Tr Trustee · Snellville, GAN4977DErdmann Gary A · North Pole, AKN4977UBaker Bryan D · Anderson, CA
Back to AD 79-10-14 R1