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.

N4389LOdell John J · Salinas, CABuilt 1966 · S/N 17254470N4389QMellinger Jason C · North Pole, AKS/N 17260289N4390LAero Science International LLC · Martinez, GABuilt 1966 · S/N 17254471N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290N4391LVeness Matthew B Trustee · Fairborn, OHBuilt 1966 · S/N 17254472N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293N4394LR A Marsh Flying Club LLC · Williamson, GABuilt 1966 · S/N 17254475N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294N4396LDyer John F · Spring, TXBuilt 1966 · S/N 17254479N4396QBennett Barry J · Owasso, OKBuilt 1971 · S/N 17260296N4397QWingsleasing LLC · Wichita, KSS/N 17260297N4398LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 17254481N4399LEge Sidney J · Carlisle, PABuilt 1966 · S/N 17254482N4399QHoefly Christopher · Belleview, FLS/N 17260299N439CEMuller Jenny DBA · Cody, NEBuilt 1965 · S/N 17253171N43TBAndreu Kenneth · Valhalla, NYBuilt 1966 · S/N 18257442N4401LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254484N4402LClements Alex F Jr · Alamogordo, NMBuilt 1966 · S/N 17254485N4405LKopcho Thomas L · York, NEBuilt 1966 · S/N 17254490N4410LLenhart James A · Manchester, MIBuilt 1966 · S/N 17254495N4411Mh Aviation LLC · Dublin, CABuilt 1965 · S/N 15062560N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905N4416LBustamante Marcos H · Nogales, AZBuilt 1966 · S/N 17254503N4418LIroquois Soaring Assn · Rome, NYBuilt 1966 · S/N 17254505N4419LMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 17254506N441TSRawareo LLC · Warsaw, MOBuilt 1966 · S/N 17254288N4420ENoguerra Eric · Astoria, ORBuilt 1973 · S/N 15073879N4420LMic Jack LLC · Stuart, FLFirst renewal noticeBuilt 1966 · S/N 17254507N4421LSouthern Seaplane Inc · Belle Chasse, LAS/N 17254508N4423LQuigley James J · Labelle, FLBuilt 1966 · S/N 17254512N4424LTikiun Thaddeus J Jr · Bethel, AKBuilt 1966 · S/N 17254513N4427LHatter Ronnie A · Newcastle, OKBuilt 1966 · S/N 17254516N442PGLuedders & Reed Inc · Pawnee City, NEBuilt 1966 · S/N 17254799N442RAKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N 18260739N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121N4430LDunn Michael P · Queen Creek, AZS/N 17254519N4436LLehman Bradley R · Onsted, MIBuilt 1966 · S/N 17254527N4437LThomas John · Lees Summit, MOBuilt 1966 · S/N 17254528N4438LHarvey Jason Kyle · Glendale, AZS/N 17254529N443KAKirsch John P · Fort Defiance, AZS/N U20602496N4441KWeaver Aircraft Co · Carson City, NVBuilt 1966 · S/N 15065397N4441LKwon Andrew W · Tujunga, CABuilt 1966 · S/N 17254534N4442LSchoepflin Robert D · Palouse, WABuilt 1966 · S/N 17254535N4443LHenderson Michael Trustee · Whitman, NES/N 17254536N44441Breeden William N · Gaithersburg, MDBuilt 1966 · S/N 18258015N4444TKinzie Industries LLC · Alva, OKBuilt 1966 · S/N P206-0290N4444VWolfe Randy K · Middle Grove, NYBuilt 1971 · S/N 15072907N4446LC And T Aviation Inc · Madera, CAS/N 17254539
Back to AD 72-03-03 R3