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.

N5026UBorders Nowell Equipment G P Inc · Edinburg, TXBuilt 1963 · S/N 206-0026N50270Flanagan Elizabeth M · Coronado, CABuilt 1968 · S/N 15069183N50274Currie William O · Lumberton, NCBuilt 1968 · S/N 15069186N50276Pense Richard L · Katy, TXBuilt 1968 · S/N 15069188N50283Sanchez Oscar A Blanco · Portsmouth, VAS/N 15069194N50284Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069195N50286Baue Michael G · Foristell, MOBuilt 1968 · S/N 15069197N50292Wheeler Richard Edmond III · Norfolk, VABuilt 1968 · S/N 15069201N50297Eddleston Ryan · Winter Haven, FLBuilt 1968 · S/N 15069206N50299Wood Thomas J · Overland Park, KSBuilt 1968 · S/N 15069208N502RKKuehne Tracy · Pensacola, FLBuilt 1973 · S/N 15075370N502WACommodore Jr Paul S · Tinton Falls, NJS/N 177RG0664N50304Reuben Abraham · Flushing, NYBuilt 1968 · S/N 15069211N50308Villano Frank P · Wappingers Falls, NYBuilt 1968 · S/N 15069215N50310Richards Lyle · San Diego, CABuilt 1968 · S/N 15069217N50311Khamo Josef · Running Springs, CABuilt 1968 · S/N 15069218N50316Foster Reynolds Sw · Winona, MNBuilt 1968 · S/N 15069222N50318Florida Fast Boats LLC · Palm Coast, FLBuilt 1968 · S/N 15069224N50323Got Valentin L · Olivehurst, CAFirst renewal noticeS/N 15069228N50326Thompson Arthur W · Paris, TXBuilt 1968 · S/N 15069229N50328Neiger Steven · Ocean View, NJBuilt 1968 · S/N 15069231N50331Sale Reported · Nashotah, WISale reportedBuilt 1968 · S/N 15069233N50335Joung Kweon · Cumming, GABuilt 1968 · S/N 15069235N50337Nava Alfred Joseph II · Gig Harbor, WABuilt 1968 · S/N 15069236N50345Stanley345 LLC · Esko, MNS/N 15069242N50347Garrett Dennis R · Hudson, FLS/N 15069244N50354N50354 LLC · Key West, FLBuilt 1968 · S/N 15069249N50355Kurpgeweit William E · Ewing, NEBuilt 1968 · S/N 15069250N50356Meyers Meade M · Rockwood, PABuilt 1968 · S/N 15069251N5035TJettime10 LLC · Grayslake, ILBuilt 1964 · S/N 18255231N50367American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15069255N50368Rogers Warren R · Manti, UTS/N 15069256N50375Mcburney Cleland V · Kingman, KSBuilt 1968 · S/N 15069260N50379Grosdidier Rolland J · Kenai, AKBuilt 1968 · S/N 15069263N50382Eastside Aero Inc · Eatonville, WABuilt 1968 · S/N 15069264N50390Dillard Clayton B · Talkeetna, AKBuilt 1968 · S/N 15069269N503MDChristy John R · Anchorage, AKBuilt 1963 · S/N 206-0076N503TCForetich Joseph J · Baker, LAS/N 15069261N50400Bostick Alva D H · Portsmouth, OHBuilt 1968 · S/N 15069274N50403Reis Gavin · Conway, SCS/N 15069277N50404Mcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 15069278N50405Und Aerospace Foundation · Grand Forks, NDBuilt 1968 · S/N 15069279N50406Aeroplanes Over Idaho Inc · Carson City, NVS/N 15069280N50407Coombs Kevin A · Knoxville, TNS/N 15069281N5040UAir Data Solutions LLC · Natchitoches, LABuilt 1963 · S/N 206-0040N50413Rafi Adnan · Olean, NYS/N 15069286N50418Forrest City Aircraft Club · Rockton, ILS/N 15069289N50419Hamilton Richard Paul · Laredo, TXBuilt 1968 · S/N 15069290N50421Franco Gary R · Chico, CABuilt 1968 · S/N 15069291N50425Keneston Mark G · Ballston Spa, NYBuilt 1968 · S/N 15069295
Back to AD 72-03-03 R3