OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,023

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.

N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N104BU1984k LLC · Gypsum, COS/N 18254352N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122N104KMMorrison Mitchell A · Forest, VABuilt 1970 · S/N 15072415N104PMPats Offroad Inc · Mitchell, SDS/N 18258085N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907N10505Metro Flyers LLC · Paducah, KYBuilt 1973 · S/N 15074894N10507Pch Aviation LLC · Elmhurst, ILBuilt 1973 · S/N 15074896N10509Mckenna Andrew J Sr · Waynesville, OHBuilt 1973 · S/N 15074897N1050CCourser Ezra D · Columbiaville, MIBuilt 1973 · S/N 15074893N10518Post Ryan · Carmichaels, PAS/N 15074900N10524Putrakul Kobkit · London, KYS/N 15074902N10548Scootair LLC · Alburgh, VTBuilt 1973 · S/N 15074908N10557Parker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 15074909N10565Pribyl Cris M · Hennessey, OKS/N 15074912N10568Buchner Mark L · Springfield, VABuilt 1973 · S/N 15074914N10574Osterberg Douglas L · Neenah, WIBuilt 1973 · S/N 15074916N10577Hatch Arthur S Jr · Mt Vernon, TXBuilt 1973 · S/N 15074917N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998N10592Pedrick William M · Dixon, CABuilt 1973 · S/N 15074919N105ASJohnson Scott R · North Hampton, NHBuilt 1973 · S/N 15074786N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221N10604Bittner Vernon J · New Richmond, WIBuilt 1973 · S/N 15074922N10615Tarr Sheryl L · Spokane Valley, WABuilt 1973 · S/N 15074925N10617Kern Aviation LLC · Shafter, CABuilt 1973 · S/N 15074927N10618Roundy Kamlah F · Monteview, IDS/N 15074928N10621Brosh Cameron R · Loveland, COBuilt 1973 · S/N 15074930N10628Warner Daniel D · Linden, MIBuilt 1973 · S/N 15074932N10630Perez Juan Carlos · Miami Gardens, FLS/N 15074934N10644American Flag Airlines Inc · Ft Lauderdale, FLBuilt 1973 · S/N 15074942N10645Dearborn Edward M · Acworth, GAS/N 15074943N10647Kosko Stanley G · Seattle, WAS/N 15074945N10649Seaplane Adventures LLC · Cheyenne, WYS/N 15074947N10651Wampler Matthew T · Valles Mines, MOBuilt 1973 · S/N 15074948N10653Loftin Jamie B · Shreveport, LABuilt 1973 · S/N 15074950N10658Craigmyle William R · Cooperstown, NYBuilt 1973 · S/N 15074952N10661Colberg Sigurd E · Palmer, AKBuilt 1973 · S/N 15074955N10663General Aircraft Services LLC · Pendleton, ORS/N 15074957N10669Loeppky Neal K · Seminole, TXBuilt 1973 · S/N 15074962N10679Samson Rene R · Lewiston, MES/N 15074968N1067LCollins Gene William · Manassas, VABuilt 1973 · S/N 15074965N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367N10681Chickasha Wings Inc · Chickasha, OKBuilt 1973 · S/N 15074970N10682Thomas Edward L · West Bend, WIBuilt 1973 · S/N 15074971N10683Burton Ryne W · Astoria, ILBuilt 1973 · S/N 15074972N10687Boatright William L · Colonial Beach, VABuilt 1973 · S/N 15074974N10688Wilson Oscar O Jr · Kountze, TXBuilt 1973 · S/N 15074975
Back to AD 72-03-03 R3