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.

N3515USchettler Patrick J · Garnett, KSS/N 18254915N3515YInflyt LLC · Carlsbad, CAS/N 18254415N35163Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17702239N35165N35165 LLC · Starkville, MSBuilt 1975 · S/N 17702241N3516FWhittock Tyson H · Anchorage, AKBuilt 1966 · S/N 18257516N3516YMks Aviation LLC · Port Orchard, WABuilt 1962 · S/N 18254416N3517FCebelak William G · Kent City, MIBuilt 1973 · S/N A1500410N3517UAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 18254917N3517YRobles Serafin M · Cynthiana, KYBuilt 1962 · S/N 18254417N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253N3518FPortmann James R · St Louis Park, MNBuilt 1966 · S/N 18257518N3518YMcaninch Shawn R · Albia, IAFirst renewal noticeBuilt 1962 · S/N 18254418N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256N35193Mccormack Duncan M · Sunfield, MIS/N 17702257N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519YWeber Larry F · New Paltz, NYBuilt 1962 · S/N 18254419N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046N3520FWood Forrest B · Cookson, OKBuilt 1966 · S/N 18257520N3520LGregory Austin · Bothell, WABuilt 1965 · S/N 15062320N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271N3521LBiorn Howard L · Brooklyn Center, MNS/N 15062321N3521YSportsman Airpark Inc · Newberg, ORS/N 18254421N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272N35225Nguyen Ricky L · Honolulu, HIS/N 17702275N3522LTyler Clark D · Fort Wayne, INS/N 15062322N3522UDfs · Bountiful, UTBuilt 1963 · S/N 18254922N3522YBohlen Thomas R · Hudson, WIBuilt 1962 · S/N 18254422N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278N3523UCharlson Aaron H Jr · Forest City, IABuilt 1963 · S/N 18254923N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289N3524UHudson George R · Hueytown, ALBuilt 1963 · S/N 18254924N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293N3525FR&R Aviation · Gunnison, COBuilt 1966 · S/N 18257525N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297
Back to AD 72-03-03 R3