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.

N23302Adams John C · Gladstone, MOBuilt 1968 · S/N 15068860N23303Chuzy Suzy LLC · Lafayette, LABuilt 1968 · S/N 15068861N23304Gendy Shady S · Columbia, PABuilt 1968 · S/N 15068862N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864N2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892N23357603 Flight LLC · Nashua, NHS/N 15068898N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900N2335FGravitte Peter F · Napa, CAS/N 21058535N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538N23390Smp LLC · Kenner, LAS/N 15068924N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239N2339YGross Barbara J · Timber Lake, SDS/N 17700139N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920N233WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18257879N2340RBrandt Phillip A · Boyd, TXBuilt 1964 · S/N 18255440N2341XYale LLC · Watford City, NDS/N 18256241N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939
Back to AD 72-03-03 R3