Strobach Greg

Earlier aircraft under this name · 125

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'STROBACH GREG' OR list_contains(d.other_registrant_names, 'STROBACH GREG')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N9050HCessna 172M · S/N 17265919Cancelled Feb 12, 1983 · Administratively canceled · Brenneke Richard L, Woodburn, INN90560Hardin Rodney BENSEN B8M · S/N RH93046Cancelled Feb 12, 1983 · Administratively canceled · Hardin Rodney P, Bartlett, TNN9158UCessna 150M · S/N 15078109Cancelled Feb 12, 1983 · Administratively canceled · Agape Air Inc, Durham, NHN9195AWagner-David VOLKSPLANE-I · S/N V12741Cancelled Feb 12, 1983 · Administratively canceled · Steere Joseph D, Gleneden Beach, ORN9180Schleicher AS-K13 · S/N 13178Cancelled Jan 8, 1983 · Administratively canceled · Adrian Soaring Club Inc, Toledo, OHN9053NAhearn James SCORPION TOO · S/N 1350Cancelled Nov 11, 1982 · Administratively canceled · Ahearn James P, Tampa, FLN9042KPiper PA-28-181 · S/N 28-7890172Cancelled Nov 4, 1982 · Administratively canceled · Campbell James F, Montecito, CAN9069EMaule M-5-235C · S/N 7079CCancelled Oct 24, 1982 · Administratively canceled · J S J Pipe Inc, Portland, ORN9225TPiper PA-38-112 · S/N 38-78A0283Cancelled Oct 24, 1982 · Administratively canceled · Sun Aviation Inc, Vero Beach, FLN8963LGrumman American Avn. AA-1B · S/N AA1B-0413Cancelled Oct 7, 1982 · Administratively canceled · Miller Robert O, Lavra, OHN8894LGrumman American Avn. AA-1B · S/N AA1B-0394Cancelled Oct 2, 1982 · Administratively canceled · Abc Inc, San Antonio, TXN8948KUniversal Stinson 108-1 · S/N 1081948Cancelled Oct 2, 1982 · Administratively canceled · Schumaker Robert J, Huntsville, ALN8988SCessna 150F · S/N 15062288Cancelled Oct 2, 1982 · Administratively canceled · Campbell Tommy Ray DBA, Arkadelphia, ARN8999ASmith AEROSTAR 601P · S/N 61P-0501-206Cancelled Oct 2, 1982 · Administratively canceled · Balf Co, Newington, CTN9001NAerospatiale SA315B · S/N 2523Cancelled Oct 2, 1982 · Administratively canceled · Farm Development Corporation, Boise, IDN9036WWeatherly 201C · S/N 1017Cancelled Oct 2, 1982 · Administratively canceled · Mac Donald Keith H, Ashland, MEN8854ABeech B35 · S/N D-2509Cancelled Sep 29, 1982 · Administratively canceled · Gruhl Corp, Louisville, KYN89154Cessna 152 · S/N 15282652Cancelled Sep 29, 1982 · Administratively canceled · Showalter Flying Service Inc, Orlando, FLN8985FHughes 269C · S/N 830233Cancelled Sep 23, 1982 · Administratively canceled · Mackay Jack DBA, Columbus, MSN90258Manazzi Blaine K SCOTT CR 19 · S/N BKM1-7706Cancelled Sep 23, 1982 · Administratively canceled · Minazzi Blaine K, San Antonio, TXN9099AAnderson Richard SCORPION 133 · S/N 007RJACancelled Sep 23, 1982 · Administratively canceled · Anderson Richard J, Lake Arrowhead, CAN9170KStinson 108-1 · S/N 108-2170Cancelled Sep 23, 1982 · Administratively canceled · Clapp Tire Co Inc, Knoxville, TNN9219BCessna 175 · S/N 55019Cancelled Sep 23, 1982 · Administratively canceled · Hardee Mack F, Calgary AlbertaN9080WWeatherly 201C · S/N 1025Cancelled Sep 16, 1982 · Administratively canceled · Geouge E Truman, Miami, OKN91285Dehavilland BEAVER U-6 · S/N 51-16569Cancelled May 7, 1975 · Administratively canceled · United States Department Of Interior, Prescott, AZ
Back to Strobach Greg