AD 72-03-03 R3

Registered aircraft · 17,028

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.

N8061LColeman Terrence C · Maryville, TNBuilt 1967 · S/N 17256261N8061ZCarter Kristopher W · Bellingham, WABuilt 1965 · S/N U206-0461N8062FJackson Hugh W · Cordova, SCBuilt 1966 · S/N 15064162N8062GKelly Michael · Kaneohe, HIBuilt 1971 · S/N 177RG0062N8062SSturm Steve G Trustee · Springdale, ARS/N 15061662N8063EHale Mitchell D · Chugiak, AKS/N U2060926N8064LMccormick Michael P · Durham, NCBuilt 1967 · S/N 17256264N8065LDream Big Aviation LLC · Mount Juliet, TNS/N 17256265N8065ZZulu Forty One LLC · Anchorage, AKS/N U206-0465N8066FWilson Edwin · Midland, MIBuilt 1966 · S/N 15064166N8066ZTevik Michael A · Provo, UTBuilt 1965 · S/N U206-0466N8067GMaley Randy J · New Philadelphia, OHBuilt 1971 · S/N 177RG0067N8067LAviation Guys LLC · Charleston, WVBuilt 1967 · S/N 17256267N8068FGoldmuntz Jeffrey A · Chandler, AZBuilt 1966 · S/N 15064168N8068GStructural Design And Analysis Inc · Reston, VABuilt 1971 · S/N 177RG0068N8068LMason David M · Destin, FLBuilt 1967 · S/N 17256268N8068SJastrab Ryan M · Apple Valley, CABuilt 1965 · S/N 15061668N8070ZRivers Larry R · Talkeetna, AKBuilt 1965 · S/N U206-0470N8071GBell John · Queen Creek, AZBuilt 1971 · S/N 177RG0071N8072LBobo Jason A · Lampasas, TXBuilt 1967 · S/N 17256272N8073FDoll J M Smokey · Austin, TXBuilt 1966 · S/N 15064173N8073GBaker Brenten E · Farmington Hills, MIBuilt 1971 · S/N 177RG0073N8074GBudge Ross Spencer · Colorado Springs, COS/N 177RG0074N8075FLogan Francis Bodrero · Outlook, WABuilt 1966 · S/N 15064175N8076FYoxtheimer David R · Mansfield, OHBuilt 1966 · S/N 15064176N8076GGriffin Billy J · Corona, CABuilt 1971 · S/N 177RG0076N8076LWay Properties LLC · Tumbling Shoals, ARS/N 17256276N8076SChinn Thomas Blake · Arlington, TXBuilt 1965 · S/N 15061676N8076ZHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0476N8077FM-F Aviation LLC · Norman, OKS/N 15064177N8077GPhillips Stuart · La Conner, WABuilt 1971 · S/N 177RG0077N8077LAndrews Carson D · Hartsville, SCBuilt 1967 · S/N 17256277N8077SRebecca Grace LLC · Riesel, TXBuilt 1965 · S/N 15061677N8078G615dm LLC · Hazel Green, ALBuilt 1971 · S/N 177RG0078N8078LSale Reported · HawkestoneSale reportedBuilt 1967 · S/N 17256278N8078SBazemore Kelley R · Ingleside, TXS/N 15061678N8079FRegent Aero LLC · Kingsland, GAS/N 15064179N8079LHurricane Joaquin LLC · Umatilla, FLS/N 17256279N807KSKansas State University Salina · Salina, KSBuilt 1969 · S/N 15071287N8081LAerowood Aviation LLC · Monroe, NCBuilt 1967 · S/N 17256281N8081XHibdon Robert R · Jefferson City, MOBuilt 1967 · S/N 18258166N8082LBurns Jeremiah W · Westerville, OHS/N 17256282N8082MKeenan Thomas E Jr · Smyrna, DES/N 15072542N8083SKoenig William J · Benedict, MDS/N 15061683N8084BN8084b LLC · Fort Worth, TXBuilt 1975 · S/N 177RG0705N8084FAustin Michael S · Utica, KYS/N 15064184N8084SHunter Robert M · Rawlins, WYS/N 15061684N8085LDowns Warren · Dillingham, AKBuilt 1967 · S/N 17256285N8085SSchulz Michael L · Norfolk, NEBuilt 1965 · S/N 15061685N8087FWarbington Michael L · Enid, OKS/N 15064187
Back to AD 72-03-03 R3