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.
N92125Seemann James P · Dade City, FLFirst renewal noticeN9212AMills Byron K · Harrison, ARN9212BRegistration Pending · Campbellsville, KYRegistration pendingN9212XNs Aviation Inc · Ottumwa, IAN92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYN9213BWallace Gary E · La Junta, CON9213CGriffith Thomas J · Watertown, MNN9213XChung Thomas · Stanwood, WAN92141High Flight Academy LLC · Allison Park, PAN92147Bielstein David P · Plainville, GAN9214CSchumacher Gregory L · Anchorage, AKN9214GOwens Joseph F · Tallahassee, FLN92150Pessolano Vincent F · Naples, FLN92151Adiabatic Adventures LLC · Morrison, CON92152Pank Thomas E · Walkersville, MDN92158Ackerman Jefferson P · Beaufort, SCN92159Buster Aviation LLC · Harveys Lake, PAN9215CIrlbeck Joshua W · Northfield, MNN92161Skywarrior Flight Training Inc · Pensacola, FLN92169Welch William Ben · Danville, ILN9216GComdess Company Inc · Seville, OHN9216HBurgess Alan P · Corona, CAN92172Fly Like An Eagle LLC · Springfield, MON92175Richards Joseph · Gardiner, NYN9217AAlumitank Inc · Harvard, ILN9217GRegister Otis E · Rolla, MON9217RHunt Galen C · Bellevue, WAN9217UWallace John L · Bethel, AKN92180Mahanti Robert L · Flagstaff, AZN92183Desselle Trent · New Orleans, LAN92184Aviatrix Adventures LLC · Tallahassee, FLN92187Med Eagle LLC · Folsom, CAN9218BWilliams Leslie D · Oneida, TNN9218GTpec LLC · Madison, MSN9218UHolzgrove Thomas H · Pipestone, MNN92190Rimkus Fisher · Rio Frio, TXN92193Hendricks Alan M · Greenville, TXN92198Hanson Steven Dale · Livermore, CAN9219AWatkins Donley E · Cheyenne, WYN9219COtt Tucker Kyle · Belgrade, MTN9219HKful Flyers Foundation Inc · Fullerton, CAN9219UCarlson Farms Inc · Plentywood, MTN921AARegistration Pending · Deland, FLRegistration pendingN921ASA2g International LLC · San Juan Capo, CAN921BBNorthwestern Michigan College · Traverse City, MIN921CTN921ct LLC · Elkton, KYN921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKN921MAMoxie Vincent B · Sarver, PAN921TAAtp Aircraft 4 LLC · Wilmington, DEN92207Eason William E · Gloucester, MA
Back to AD 79-10-14 R1