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.
N5133GPioneer Aviation LLC · Crossett, ARN5133KAa-Aero Inc · Fairfield, NJN5133QReed Aero Group LLC · Hendersonville, TNN51343Tucker John D II · Fayetteville, GAN51345Arizona Aircraft Leasing LLC · Mesa, AZN51347Bernhardt Michael J · North Branch, MNN5134DWheeler Robert L · Nampa, IDN5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationN5134KSunrise Aviation LLC · Gilbert, AZN51355Miller Judith A · Homer, AKN5135BMekkes Gregory L · Norfolk, VAN5135ECommercial Safe And Lock Inc · Imperial, MON5135GChinrock Adam · Spanish Fort, ALN5135PChristiansen Aviation LLC · Wilmington, DEN5135QOlivas Frank · Fabens, TXN5135UEchols Mill Aviation LLC · Elberton, GAN51362Caputi J Gary · Mashpee, MAN51365Cavu Pilot LLC · Powell, TNN51367Wings Over Texas Holdings LLC · Denton, TXN51369Thorn Blake A · Coupeville, WAN5136CMonadnock Aviation Inc · Keene, NHN5136DZieg James E · Goldsboro, NCN5136EWings Over Texas Holdings LLC · Denton, TXN5136GYork Aviators LLC · York, PAN5136N5136n LLC · Las Vegas, NVN5136UNg Raymond Fong · New York, NYN51373Roberts Aviation LLC · Shreveport, LAN51374Siekmann David G · Scottsdale, AZN51376Reaves Ronald E · Olive Branch, MSN51379N51379 LLC · Galena, OHN5137AAlbritton Kerry B · Camas, WAN5137DNeuschwander Raymon J · Canby, ORN5137RSchmeelk Darrin D · Thompson, CTN51380Aircraft Leasing Inc · Everett, WAN51385Taylor William E · Waynesville, MON51386Russell Joseph M J · Douglas, WYN5138710fss - Usafa Aero Club · Usafa, CON51388Flight Line Resources Inc · Chandler, AZN51389Knudson Tamara M · Deer Park, WAN5138DUrlaub James E II · Phoenix, AZN5138ESanders Flight Training Center Inc · Jasper, ALN5138RBell Ornithopters Flying Club Inc · Eastlake, CON5138VAdvanced Charter & Instruction LLC · Costa Mesa, CAN51390Mustang Sally Aviation LLC · Camden, SCN51393K&P Flyers LLC · Douglasville, GAN51395Rush David A · El Dorado, KSN51398Twitchell Robert · Jefferson City, MON5139DEdwards A Clay · Weaverville, CAN5139EAero Techniques LLC · Binghamton, NYN5139QNykerk Kory · San Miguel, CA
Back to AD 79-10-14 R1