OpenAirDocs.org
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.

N5413RMckee Thomas E · Terra Alta, WVBuilt 1965 · S/N 17252954N5415QBrown James Jr · White Hall, ARBuilt 1972 · S/N 15073315N5416QSharp Jacob T · Frankfort, KYS/N 15073316N5417RBuenting John E · Sylva, NCBuilt 1965 · S/N 17252959N5420RBarrientos Sebastian · Tamarac, FLBuilt 1965 · S/N 17252963N5421RAviation Design LLC · Kalamazoo, MIBuilt 1965 · S/N 17252965N5422RRice Robert M · Huntsville, ALBuilt 1965 · S/N 17252966N5425RWalker Lyle P · Katy, TXBuilt 1965 · S/N 17252970N5428QKruse Jakob · Parsippany, NJBuilt 1972 · S/N 15073328N5429RRose Ronald R · Richland, NYBuilt 1966 · S/N 17252975N542ADJohnson Thomas F · Buckeye, AZS/N R1720234N5432RMishmash Christopher L · Valdez, AKBuilt 1965 · S/N 17252979N5432VMj Aerial LLC · Wasilla, AKS/N 18257941N5433RJones Kenneth Jr · Lufkin, TXBuilt 1965 · S/N 17252981N5434RFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1965 · S/N 17252982N5435QHutchins Kent F · Carbon, INBuilt 1972 · S/N 15073335N5436QAdler Richard A · Leland, NCBuilt 1972 · S/N 15073336N5437QMetro Technology Aviation Campus · Oklahoma City, OKBuilt 1972 · S/N 15073337N5439RIndian Hills Community College · Ottumwa, IABuilt 1965 · S/N 17252989N543JRRahns Inc · Enterprise, ORBuilt 1964 · S/N 205-0480N543VKHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071227N5441RGraham Norman J · West Ossipee, NHBuilt 1965 · S/N 17252991N5442RBarnes Terry A · Austin, TXBuilt 1965 · S/N 17252993N5444QChiavari Nicholas J · Havertown, PABuilt 1972 · S/N 15073344N5444RAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1965 · S/N 17252995N5445RWimpy Gregory S · Griffin, GABuilt 1965 · S/N 17252997N5447RToth Roger J · Willoughby, OHFirst renewal noticeBuilt 1965 · S/N 17252999N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001N5449QHarper Randall W · Presque Isle, MEBuilt 1972 · S/N 15073349N5449RMartin David · Waterport, NYBuilt 1965 · S/N 17253002N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981N5450RMayer Ag Service · Chamberlain, SDBuilt 1965 · S/N 17253003N5451RYoungstown Warren Development Partners · Vienna, OHBuilt 1965 · S/N 17253005N5452QRhein Craig · Mastic, NYBuilt 1972 · S/N 15073352N5452RWilliams Matthew W · Auburn, WABuilt 1965 · S/N 17253006N5453RVaughn Mark R · Fort Payne, ALBuilt 1965 · S/N 17253007N5454QPetko James · Mishawaka, INS/N 15073354N5455REpstein Paul · Pensacola, FLBuilt 1965 · S/N 17253010N5457RFarrand David V · London, OHBuilt 1965 · S/N 17253013N5458RLafranchise Louis C · Aurora, ORS/N 17253014N5459QZimmerman Dean F · Royalton, MNBuilt 1972 · S/N 15073359N5459RAllsup Rachel B · Anchorage, AKBuilt 1965 · S/N 17253015N545BLJaeger Stacey K · Towner, NDBuilt 1969 · S/N 18260124N545DTSkahill Earl DBA · Denver, COS/N 18259236N545PZLake Placid Flying Service Inc · Lake Placid, NYBuilt 1976 · S/N 177RG1023N5460QJacobson Eric R · Ouray, COS/N 15073360N5460RTake Angels Aviation LLC · Watertown, NYBuilt 1965 · S/N 17253017N54626Continental Title Trust LLC Trustee · Wichita, KSBuilt 1970 · S/N 18260199N5462RJameson Fred · Rathdrum, IDS/N 17253019N5464QBinsfeld Thomas · Chico, CABuilt 1972 · S/N 15073364
Back to AD 72-03-03 R3