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.

N51209Green Harvey D · Germantown, TNBuilt 1968 · S/N 15069840N5120FUnited States Air Force · Jacksonville, FLBuilt 1965 · S/N 17252811N51219Szostak Edward M · San Diego, CABuilt 1968 · S/N 15069845N51220Trevillyan Bart L · Hot Springs, SDS/N 15069853N51223James Joseph E · Janesville, WIBuilt 1968 · S/N 15069848N51224Rettenmeyer Ryan J · Buford, GABuilt 1968 · S/N 15069849N51225Riccelli Zack Louis · Portland, ORBuilt 1968 · S/N 15069850N5122FRay Richard H · Franklin, GABuilt 1965 · S/N 17252825N51232Hawk Hangars Corporation LLC · Jenks, OKS/N 15069857N51251Technical Education Services Inc DBA · Virginia Beach, VABuilt 1968 · S/N 15069872N51256Miller Andy · Marana, AZBuilt 1968 · S/N 15069875N51257Burnham Nathaniel · Eagle Mountain, UTBuilt 1968 · S/N 15069876N51258Nelson Otis · Portage, MEBuilt 1968 · S/N 15069877N5125FEckles Aircraft LLC · Holdenville, OKBuilt 1965 · S/N 17252846N5125GRogers William A II · Indn Hbr Bch, FLBuilt 1968 · S/N 17257022N51266Reiter Marc · Hooks, TXBuilt 1968 · S/N 15069881N5126FEkblad Carl A · New Port Richey, FLBuilt 1965 · S/N 17252853N51275Hollow David C · Knoxville, TNBuilt 1968 · S/N 15069887N5127FDolan Ross R · Portland, MEBuilt 1965 · S/N 17252860N5127UFowler Ron W · Lopez Island, WAS/N 206-0127N51284Stallbaumer Roger P · Seneca, KSBuilt 1968 · S/N 15069894N51285Bk Aviation Inc · Grand Prairie, TXBuilt 1968 · S/N 15069895N51287Personal Air LLC · Wilmington, DES/N 15069897N51288Cantley Richard W · Bluff City, TNS/N 15069898N51292Herbert William N · Anchorage, AKBuilt 1968 · S/N 15069901N512ADDiffenderfer Andy C · Horseheads, NYS/N 15065020N51300Loftin Gabe · Weatherford, TXBuilt 1977 · S/N 177RG1137N51304Stewart Roy L · Roy, UTS/N 15069909N51306Durand Gregory M · Marquette, MIBuilt 1968 · S/N 15069911N51314Scott John J · Arcadia, FLBuilt 1968 · S/N 15069916N51316Devault Clayton D · Larkspur, COS/N 15069918N51317Spitzer Terry E · Kalona, IAS/N 15069919N5131FWoerle Edward R · Rossville, TNBuilt 1965 · S/N 17252888N51323Rathnayake Eric · Collegeville, PABuilt 1968 · S/N 15069924N51326Lapoint Paul E · Drummond Island, MIBuilt 1968 · S/N 15069926N51327Bowles Alan B · Georgetown, TXBuilt 1968 · S/N 15069927N51328Butterfield Charles D · Eskridge, KSBuilt 1968 · S/N 15069928N51333Blazey John Stanley · Palmyra, NYBuilt 1968 · S/N 15069930N51334Cragg Noel J · Millbrae, CABuilt 1968 · S/N 15069931N51337Garner Charlotte Trustee · Sun Lakes, AZS/N 15069933N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447N51343Tucker John D II · Fayetteville, GABuilt 1968 · S/N 15069939N51345Arizona Aircraft Leasing LLC · Mesa, AZS/N 15069941N51347Bernhardt Michael J · North Branch, MNS/N 15069942N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448N51355Miller Judith A · Homer, AKS/N 15069946N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449N5135QOlivas Frank · Fabens, TXBuilt 1965 · S/N 17252916N51365Cavu Pilot LLC · Powell, TNBuilt 1968 · S/N 15069953N51367Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 15069954
Back to AD 72-03-03 R3