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.

N1339FFriedlander Edward R · Hattiesburg, MSBuilt 1966 · S/N 17254834N133DSHagopian Donald D · Van Nuys, CABuilt 1965 · S/N 18256837N133TSHunter Stephen Eugene · Grace, MSBuilt 1966 · S/N 18257883N13411Leiss Todd J · Merritt Island, FLBuilt 1976 · S/N 17702419N1341FDix Justin T · South Boston, VABuilt 1966 · S/N 17254836N1342FFriedman Peter Michael · Pleasant Hill, CABuilt 1966 · S/N 17254837N13430Mjr Assoc LLC · Bend, ORBuilt 1976 · S/N 17702420N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544N13454Parry Matthew J · Oxnard, CABuilt 1976 · S/N 17702423N1345CBeck Elwood M Jr · Athens, GAS/N 17702706N13468Wanner Kevin M · Morristown, NJBuilt 1976 · S/N 17702424N1347FSprague Lee G · Augusta, GABuilt 1966 · S/N 17254842N13484Aero-Flite Corp · Murfreesboro, TNBuilt 1976 · S/N 17702426N1348FRau Bodo A · Aliso Viejo, CABuilt 1966 · S/N 17254843N13493Pelaez Gilberto · Chatsworth, CABuilt 1976 · S/N 17702427N1349FTran Holm Viet · Henderson, NVS/N 17254844N1350FButler Kendall L · Gatesville, TXBuilt 1966 · S/N 17254845N13511Meteor Aviation · Kirkland, WAS/N 17702430N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431N1351CSapphire Vistas LLC · Iowa City, IABuilt 1977 · S/N 17702708N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433N1352FDtm Enterprises Inc · Bronson, MIBuilt 1966 · S/N 17254847N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434N1354QBaker Wayne E · Crossville, TNBuilt 1971 · S/N 15072654N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1357CSummit Concepts Inc · Wilmington, DES/N 17702710N1357QMckenzie Paul · Stockton, CABuilt 1971 · S/N 15072657N1358QWilliams Matthew L · Longview, TXBuilt 1971 · S/N 15072658N13596Gary Rollin F · Dallas, TXS/N 17702440N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711N135AUCoppice Aviation Assets LLC · Lewes, DEBuilt 1971 · S/N A1500297N135FPointon Aviation LLC · Baraboo, WIBuilt 1965 · S/N 18256502N13612Harry Philip Scott · Asheville, NCBuilt 1976 · S/N 17702443N1361CHuckaby William C Trustee · Loudon, TNBuilt 1977 · S/N 17702712N1361FWorld Media Corp · Hialeah, FLBuilt 1966 · S/N 17254856N13621Fowler Gerald · Springfield, MOBuilt 1976 · S/N 17702444N1363QAsch John C · Zephyrhills, FLBuilt 1971 · S/N 15072663N13647Winn William D · Fallbrook, CABuilt 1976 · S/N 17702447N1364FLewis David N · Carmel, INBuilt 1966 · S/N 17254859N13656Groth Abigail · Oxford, GAS/N 17702448N1365FHouse Conrad B · Hernando, MSS/N 17254860N13667Fuller Air Inc · Wilmington, DEBuilt 1976 · S/N 17702450N13669Hypersonic Handler Inc · Essex, IABuilt 1976 · S/N 17702451N1366FBenton Joseph C · Hinckley, MNBuilt 1966 · S/N 17254861N1367FMoehn Dennis H · Oshkosh, WIBuilt 1966 · S/N 17254862N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454
Back to AD 72-03-03 R3