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.
N5938BDocjosh Ltd LLC · Essex, NYN5938TShihadeh Luke C · Wasilla, AKN5939GMasek Ron J · Valley City, OHN5939RHester James T · Fayetteville, GAN5939TAdkins Amanda J · Proctorville, OHN593CPCivil Air Patrol · Montgomery, ALN593STN593st LLC · Bangor, MEN5940EHorton Bill · Derby, KSN5940RBakrevski Lupcho · Valparaiso, INN5941ERoxbury Public Schools · Succasunna, NJN5941RChristian Stuart J · Erskine, MNN5942GGsell Bruce · Southampton, NJN5942JNovember Sierra Aviation LLC · O Neill, NEN5942RL&L Ltd · Shoreview, MNN5943AFox Michael S · Glendale, AZN5943EPlane Zane LLC · Stuart, FLN5943GFlight Express LLC · Henry, TNN5943RGear Down Hangar LLC · Phoenix, AZN5943TMission Flight Academy · Redlands, CAN5944GYakich Adam J · Fairfield, IAN5944RLucas Heaven · Griffin, GAN5944THills Jacob W · Lonepine, MTN5945EBaby 80 LLC · Chandler, AZN5945RDamme Douglas A · Talmage, NEN5946AKessinger John · Independence, ORN5946JMillett Paul B · Claremore, OKN5946RElite Aeronautics LLC · Miami, FLN5946TEasmunt David P · Hardin, KYN5947ARoberts James L · Sedgwick, KSN5947ESwenson Roger A · Pahrump, NVN5947GGregorzewski Richard D · Jasper, ALN5947NGmm Records · Big Pine Key, FLN5947RDillon Aero Inc · Phoenix, AZN5947SStewart Edgar Alan · Glennallen, AKN5947TStewart Edgar A · Glennallen, AKN5948AVerdouw Andrew J · Georgetown, INN5948ETlt Legacy LLC · Fort Worth, TXN5948F5c1 Ltd · Boerne, TXN5949FRead Travis E · Lumberton, TXN5949JAnderson Brian E · Castro Valley, CAN5949TJoy Jeffrey · Pendergrass, GAN5949VElkhorn Creek Aviation 3 LLC · Georgetown, KYN594CF4cf Partnership · Fall River Mills, CAN594CPCivil Air Patrol · Maxwell Afb, ALN594PFBatten Franklin H · Randleman, NCN5950AVincent Anthony Jordan · Graham, KYN5950GSmylie Michael Dean · Douglas, WYN5951ELlano Alfonso · Tucson, AZN5951GWallace Grant R · Altoona, IAN5951RSouth Seattle Community College · Seattle, WA
Back to AD 79-10-14 R1