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.

N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240N3140JSmith Franklin R Sr · York, SCBuilt 1966 · S/N 15065840N3140SLavell Michael J · Blue Mounds, WIS/N 18255640N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440N3140XGerasimov Gennady · Jefferson City, MOBuilt 1966 · S/N 15064540N3140YParker Mccrum LLC · Eugene, ORBuilt 1962 · S/N 18254140N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241N3141RIncze Bela · Morgan Hill, CABuilt 1967 · S/N 18258541N3141SValley Excavation And Grading Inc · Chatsworth, CABuilt 1964 · S/N 18255641N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441N3141UMo2 Investing LLC · Springfield, MOS/N 18254541N3141XMalo Lee M · Peabody, MABuilt 1966 · S/N 15064541N3142QRogers James · Summerfield, FLBuilt 1967 · S/N 18258142N3142SB&G Aircraft LLC · Greensboro, GABuilt 1964 · S/N 18255642N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442N3142YOdom Aviation Inc · Cabot, ARS/N 18254142N3143QJlm Management LLC · Clarion, PABuilt 1967 · S/N 18258143N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543N3144JChaffey Union Junior College District · Alta Loma, CABuilt 1966 · S/N 15065844N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546N3147JRegistered aircraftS/N 15065847N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447N3147XSuperior Golf Course Maintenance LLC · Plantation, FLBuilt 1966 · S/N 17255297N3148JWoerle Edward R · Rossville, TNBuilt 1966 · S/N 15065848N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448N3148XJennings Dewey S · Springfield, MOBuilt 1966 · S/N 17255298N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547N3150JKeown Kyle W · Saint Charles, MOBuilt 1966 · S/N 15065850N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251N3151QRairdan Todd G · Vacaville, CABuilt 1967 · S/N 18258151N3151SThomas Darryl · Belfield, NDBuilt 1964 · S/N 18255651N3151XJoseph Stern · Sherman, TXS/N 17702399
Back to AD 72-03-03 R3