AD 72-03-03 R3
Registered aircraft · 17,027
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N2980JOrsak Eddie J · Seymour, TXN2980YLeisz Jeffrey A · Bloomington, INN2981YBeebe Michael · Rangeley, MEN2982JTijman Esteban M · Potomac, MDN2982SHerzog Daniel L · Clinton, MIN2982XSale Reported · Lakeland, FLSale reported, canceledN2983FHalle Michael P · Livingston, TXN2983XEagle Sky Patrol Inc · Deadwood, SDN2984JBell Edward A · Richfield, OHN2984UJuris Ronald D · Bickleton, WAN2984YRondeb Aircraft LLC · Wilmington, DEN2985JScott Jason Eton · Seattle, WAN2985XFrazier James R · Adamsville, TNN2985YJones Aviation Inc · Biggs, CAN2986JWylam Thomas S · Ocala, FLN2986SHouglan Norman L · Shepherdsville, KYN2987FRegistered aircraftN2988FTaf Aerial Services LLC · Beeville, TXN2988JRegistration Pending · Asotin, WARegistration pendingN2988XDoyle Thomas P · San Diego, CAN2989JWright Brandon C · Cave City, KYN2989XLabadie Enrique L · Tucson, AZN2990JHale Randall C · Bloomburg, TXN2990SAndresen Paul S · Chandler, AZN2991FBerryessa Alan E · Cedarville, CAN2991SVanbrocklin Valerie A · Anchorage, AKN2991XDewald David J · Fort Wayne, INN2991YRabska William G · Suisun City, CAN2992SN2992s LLC · Bristol, VTN2993FDaniels Aviation Inc · Inverness, MSN2993SCintron Jaime · Lake City, FLN2993XKreutzer Charles · Springfield, ILN2993YBranch Robert W · Fort Mohave, AZN2994XBas Part Sales LLC · Greeley, CON2995FCj3 Aviation LLC · Idaho Falls, IDN2995SWillard Kevin C · Bartlett, NEN2996FSmooth Air LLC · Mequon, WIN2996JDziadaszek Daniel J · Yemassee, SCN2996SKingdom Air Corp · Sutton, AKN2996XEagle Sky Patrol Inc · Deadwood, SDN2996YCrowe Timothy P · Gilbert, AZN2997YSkyriders LLC · Flagstaff, AZN2998FChristian Halls International · Arlington, TXN2998YReynolds Peter · Athol, MAN2999SZheng Zheng · Walnut, CAN2999XPoore Zack W · Mcdonald, KSN299MPayne Michael Allen · Montgomery, TXN299PTWright W Gregory III · Kinsale, VAN299RQRds Aviation LLC · Powder Springs, GAN29FCUsda Forest Service Fepp · Raleigh, NC
Back to AD 72-03-03 R3