AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N9212XNs Aviation Inc · Ottumwa, IAN92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYN9213BWallace Gary E · La Junta, CON9213CGriffith Thomas J · Watertown, MNN9213XChung Thomas · Stanwood, WAN92140Poplar Grove Airmotive Inc · Poplar Grove, ILN92141High 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, TNN9218CArensmeyer Michael W · Longmont, CON9218GTpec 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, CAN921KPCenturion N709jm LLC · Minneapolis, MNN921MAMoxie Vincent B · Sarver, PAN92207Eason William E · Gloucester, MAN92208Full Throttle Aviation LLC · Nashville, ARN92209Stanton Gregory R Jr · Newport, ORN9220ABrown Douglas C · Daytona Beach, FLN92214Sfh Aviation LLC · Birmingham, MI
Back to AD 87-20-03 R2