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.
N812FPeter Kevin · Hermon, MEN812KKKerscher Helen A · Los Lunas, NMN812KRSchneider Richard A · Ellicott City, MDN812KSUniversity Of Central Missouri · Warrensburg, MON812MCFly Bye Air LLC · Southport, NCN812PLCirrusair LLC · Missoula, MTN812THSuss Charles H · Woodford, VTN812WJjc Enterprises Inc · Dillingham, AKN8130BJohnson Daniel P · Pardeeville, WIN8130GBank Of Utah Trustee · Salt Lake City, UTN8130LPerfect 10 Roofing · Billings, MTN8130TMoore Dallas L · Rotonda, FLRegistration revokedN8130UWade Air LLC · Clanton, ALN8130ZChalmers Russell P · Saint Martinville, LAN8131GTalley Edward P · San Jose, CAN8131LGerber Aviation LLC · Winter Haven, FLN8131UTodd James M · Angleton, TXN8132AProell Eric R · Fairbanks, AKN8132SHarris Gregory A · Aurora, CON8132TSlade Richard · Halifax, PAN8132ZCrown L Inc · Greenacres, FLN8133BReaka Dean James Trustee · Troy, MON8133FMagarian Mitchell · Jacksonville, FLN8133UDunaire LLC · Mechanicsburg, PAN8133XAdamie Isaac Sloan · Bowling Green, KYN8134BTreefo Bravo LLC · Hawkins, TXN8134FHammond Steven R · Trenton, MON8134UColey Lee · Fayetteville, GAN8134XLugas Grant A · Elyria, OHN8135SMcjunkin John Michael · Portland, ORRegistration revokedN8135XMatarelli Robert E Jr · Carlton, MNN8136ARedman Thomas F · Talkeetna, AKN8136BStanley Mark E · Paso Robles, CAN8136FRawson Aviation LLC · Ardmore, OKN8136MTakeair LLC · Incline Village, NVN8136SPockrus Pat B · Mineral Wells, TXN8136UMoors Thomas G · Wentzville, MON8136XStevenson George Otis · Wheatland, WYN8137BKelly James E · Accord, NYN8137GTwo Ten K LLC · Upper Sandusky, OHN8137LShreve Jerry · Warrensburg, MON8137XHarritt Roger · Anchorage, AKN8137ZSullivan Harry Stuard Trustee · Banning, CAN8138ANelson Richard W · Edna, TXN8138GRab Com Limited · Hayward, CAN8138QAnderson Marshall H · Anchorage, AKN8138TSvoboda Patrick J · Bucyrus, KSN8138UBurner Dwight L · Mc Gaheysville, VAN8138XHarris David L · Wichita, KSFirst renewal noticeN8139BDavies Lincoln J · Oostburg, WI
Back to AD 79-10-14 R1