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.
N50816Dingee Robert G · Clarks Summit, PAN50818Bradley Hayden Ace · Litchfield Park, AZN50819Registered aircraftN5081AJones William H Trustee · Wenden, AZN5081UKiloecho Aeronautics LLC · Tucson, AZN50822Nyhus Sharon L · Harvey, NDN50826Bristol Bay Capital LLC · Watkins, CON5082AYoung Ryan E · Willis, TXN5082DRegistered aircraftN5082EWeaver M Thomas · Kalispell, MTN5082GJala Tech Services LLC · Social Circle, GAN5082RWings Over Texas Holdings LLC · Denton, TXN5082WAmeeti Robert Keith Trustee · Newport Beach, CAN50832Whalen John F Jr · West Ossipee, NHN50835Henson Chad Cox · Galivants Ferry, SCN50836Leeper Miles F · Douglass, KSN50837N50837 LLC · Kaneohe, HIN50838Ansee LLC · Seattle, WAN5083KLoewen Wielhelm N · Presidio, TXN5083NN5083 LLC · San Diego, CAN50840Dahlgren John W · Little Egg Harbor, NJN50844Ellenson Conroy N · Browns Valley, CAN50846Jackson Bob · Bay City, TXN5084AOsterberg Douglas L · Neenah, WIN5084DArrow LLC · Pateros, WAN5084RBenham Eric T · Las Vegas, NVN50850Knutson Wayne R · Tioga, NDN50854Fulton Lanny G · Spartanburg, SCN50858Christiansen Aviation LLC · Wilmington, DEN5085DHawkes Brian R · Hamilton, MTN5085KMartin Bach Aviation LLC · Cornelius, NCN50864Rasmussen Agribusiness Inc · Antelope, MTN50865Smith Leslie A · Waresboro, GAFirst renewal noticeN50868Krekacs Gabor · La Crescenta, CAN5086ANeeley James L · Temecula, CAN5086DGillaspy Paul J · Orcutt, CAN5086EPark David W · Placentia, CAN5086NSnoopy Aviation Ltd · San Antonio, TXN5086RSafety In Motion Flight Center Inc · Puyallup, WAN50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VAN50874Priddle Linda Ann · Carlsborg, WAN50875Krs Aerial Inc · Plain City, OHN50876Parker David A · Sacramento, CAN5087AMenard Bernny · Abbeville, LAN5087BSchwebach Victoria L · Coronado, CAN5087DPenz Johnathan D · Russian Mission, AKN5087EDern Aviation · Lake Charles, LAN5087JSession Jason E · Higden, ARN5087KAir Capital Aviators Club · Wichita, KSN50887Stanton Sport Aviation Inc · Stanton, MN
Back to AD 79-10-14 R1