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.

N2980JOrsak Eddie J · Seymour, TXBuilt 1966 · S/N 15065780N2980YLeisz Jeffrey A · Bloomington, INBuilt 1962 · S/N 18253980N2981YBeebe Michael · Rangeley, MEBuilt 1962 · S/N 18253981N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782N2982SHerzog Daniel L · Clinton, MIS/N 15066882N2982XSale Reported · Lakeland, FLSale reported, canceledS/N 17700382N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083N2983XEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701365N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785N2985XFrazier James R · Adamsville, TNBuilt 1967 · S/N 17700385N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886N2987FRegistered aircraftBuilt 1966 · S/N 18257087N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788N2988XDoyle Thomas P · San Diego, CABuilt 1968 · S/N 17700388N2989JWright Brandon C · Cave City, KYS/N 15065789N2989XLabadie Enrique L · Tucson, AZBuilt 1967 · S/N 17700389N2990JHale Randall C · Bloomburg, TXS/N 15065790N2990SAndresen Paul S · Chandler, AZS/N 15066890N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091N2991SVanbrocklin Valerie A · Anchorage, AKBuilt 1967 · S/N 15066891N2991XDewald David J · Fort Wayne, INBuilt 1967 · S/N 17700391N2991YRabska William G · Suisun City, CABuilt 1962 · S/N 18253991N2992SN2992s LLC · Bristol, VTBuilt 1967 · S/N 15066892N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093N2993SCintron Jaime · Lake City, FLS/N 15066893N2993XKreutzer Charles · Springfield, ILBuilt 1967 · S/N 17700393N2993YBranch Robert W · Fort Mohave, AZS/N 18253993N2994XBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 17700394N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095N2995SWillard Kevin C · Bartlett, NEBuilt 1967 · S/N 15066895N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096N2996JDziadaszek Daniel J · Yemassee, SCBuilt 1966 · S/N 15065796N2996SKingdom Air Corp · Sutton, AKS/N 15066896N2996XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700396N2996YCrowe Timothy P · Gilbert, AZBuilt 1962 · S/N 18253996N2997YSkyriders LLC · Flagstaff, AZBuilt 1962 · S/N 18253997N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098N2998YReynolds Peter · Athol, MABuilt 1962 · S/N 18253998N2999SZheng Zheng · Walnut, CABuilt 1967 · S/N 15066899N2999XPoore Zack W · Mcdonald, KSBuilt 1967 · S/N 17700399N299MPayne Michael Allen · Montgomery, TXBuilt 1974 · S/N 17702216N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631N299RQRds Aviation LLC · Powder Springs, GABuilt 1977 · S/N 177RG1167N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191
Back to AD 72-03-03 R3