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.

N8033GStoltz Curtis · Winter Haven, FLBuilt 1970 · S/N 177RG0033N8034FDavis Matthew B · Silsbee, TXBuilt 1966 · S/N 15064134N8035SLongstreth Seth Allen · Lancaster, OHBuilt 1965 · S/N 15061635N8036SStern Mark A · Tallevast, FLBuilt 1965 · S/N 15061636N8037GGuidry John M · Pensacola, FLBuilt 1970 · S/N 177RG0037N8037LSkyglide LLC · St George, UTBuilt 1967 · S/N 17256237N8038FJackovich Dennis A · Bettendorf, IABuilt 1966 · S/N 15064138N8038SPainter Bryan · Renton, WABuilt 1965 · S/N 15061638N8039GGreen Mortgage Corp · Walworth, WIBuilt 1970 · S/N 177RG0039N8040FWingfield Kyle M · Leesburg, GABuilt 1966 · S/N 15064140N8040SNew Flight LLC · Dublin, VABuilt 1965 · S/N 15061640N8042SBanning Braden L · Pleasant Hill, IABuilt 1965 · S/N 15061642N8043GConnor Robert L · North Little Rock, ARBuilt 1971 · S/N 177RG0043N8043SLund William R · Escondido, CABuilt 1965 · S/N 15061643N8044GTml Services LLC · The Villages, FLS/N 177RG0044N8044LOverton Larry D · Hermiston, ORS/N 17256244N8044ZLever Samuel C · Udall, KSS/N 15071255N8045LAmonett Rodney · Abilene, TXBuilt 1967 · S/N 17256245N8046SHolmes Gerald P · Billerica, MABuilt 1965 · S/N 15061646N8046ZBest Auto Sales LLC · Plummer, IDS/N U206-0446N8047FPoole Terrell W · Rigby, IDBuilt 1966 · S/N 15064147N8048FParris Morgan Aaron R · Taylors, SCBuilt 1966 · S/N 15064148N8048LFour Dudes And A Plane LLC · Whitehouse, OHS/N 17256248N8048ZWalker John A · Kotzebue, AKS/N U206-0448N8049GStone & Phillips Aviation LLC · Youngstown, FLBuilt 1971 · S/N 177RG0049N8049LPrewitt Murray L · Lake Jackson, TXS/N 17256249N8049STri State Aero Inc · Martinsburg, WVBuilt 1965 · S/N 15061649N804PMSmp Outdoors Inc · Joseph, ORBuilt 1962 · S/N 18254108N8050GJudge Simone · Greenwood, ARS/N 177RG0050N8050LRobinette William B · Youngstown, OHBuilt 1967 · S/N 17256250N8050SWeeks George E · Trenton, SCS/N 15061650N8051GMeyer Nicholas A · Indianapolis, INBuilt 1971 · S/N 177RG0051N8051QLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1967 · S/N 18258064N8051ZN8051z LLC · Anchorage, AKBuilt 1965 · S/N U206-0451N8053FCurell Ken E · Centerville, OHBuilt 1966 · S/N 15064153N8053LSasser Jeremiah · Ceres, CABuilt 1967 · S/N 17256253N8054GPelham Robert F · Glasgow, KYBuilt 1971 · S/N 177RG0054N8054LAdams Clint D · San Antonio, TXBuilt 1967 · S/N 17256254N8055FGerken James D Jr · Salem, VABuilt 1966 · S/N 15064155N8055LRowden Paul G · Wichita, KSBuilt 1967 · S/N 17256255N8055SFoster Tommy L · Thaxton, VAS/N 15061655N8056GYosten Patsy J · Greenville, TXBuilt 1971 · S/N 177RG0056N8056LJenkins Mark · Santa Clarita, CABuilt 1967 · S/N 17256256N8057FThenappan Nachiappan · Round Rock, TXBuilt 1966 · S/N 15064157N8057LSale Reported · Kirksville, MOSale reportedBuilt 1967 · S/N 17256257N8060LOneonone Flight Training LLC · Hagerstown, MDS/N 17256260N8060SGrinfeder Alex J · Little Rock, ARBuilt 1965 · S/N 15061660N8061Gibson Isaac S · Saint John, INBuilt 1965 · S/N 15061669N8061FMorales Jose · Mission, TXBuilt 1966 · S/N 15064161N8061GMolstad Jerome M · La Crosse, KSBuilt 1971 · S/N 177RG0061
Back to AD 72-03-03 R3