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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N90656Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-107N878American AA-1B · S/N AA1B-0001N8856VBellanca 17-30A · S/N 30388N902MWSud SE 210 CARAVELLE VIR · S/N 88N9056LChampion 7ECA · S/N 768-70N905MWSud SE 210 CARAVELLE VIR · S/N 95N90747Douglas DC-6 · S/N 43052N91026Cessna 207 · S/N 20700017N9153FHughes 369HS · S/N 930513SN9049YDouglas C-47 · S/N 34-299N9136RCessna A188B · S/N 18802127TN900ECessna 421B · S/N 421B0359N9211CCessna 180 · S/N 31310N8824Sikorsky CH-19 · S/N 56-4263N9079BRobinson Helicopter R22 · S/N 0294N9201Richard E Franklin JEANIES TEENIE · S/N RF013N922Lawson Special DG 1 · S/N 3N9221NAero Commander 685 · S/N 12033N8816QAero Commander S2R · S/N 1516RN9015RRobinson Helicopter R22 · S/N 0010N9034LChampion 7GCBC · S/N 261-70N8861LGrumman American Avn. AA-1B · S/N AA1B-0361N9040WWeatherly 201C · S/N 1020N91115Cessna T207 · S/N 20700078N8847Unknown model · S/N 1N8862BCessna 172 · S/N 36562N8762SAir Tractor AT-301 · S/N 301-0185N88KAFreeman PITTS S-1C · S/N 496-FN90396Key Wayne & Rudy SCORPION TOO · S/N 7615N87681Beech C-45H · S/N AF-454N89888Cessna 140 · S/N 8933N8777SCessna 150F · S/N 15062077N878BCBeech G35 · S/N D-4820N9109BCessna 172 · S/N 36609N90283Kimball Fred BARNETT 004.B · S/N 004BN9218SBeech C23 · S/N M-1738N88254Bellanca 7ECA · S/N 1046-74N8800NPiper PA-28-140 · S/N 28-25645N8837LPiper PA-25-235 · S/N 25-5348N8898FHughes 269A · S/N 83-0275N88KCBeech 65-88 · S/N LP-40N8960FHughes 269A-1 · S/N 15-0023N89468Cessna 152 · S/N 15282758N89501Cessna 152 · S/N 15282764N8953FHughes 269C · S/N 340282N9065SHughes TH-55A · S/N 67-18365N9011MRobinson Helicopter R22 · S/N 0005N9021KPiper PA-28R-201T · S/N 28R-7803058N90238Cessna 402B · S/N 402B0817N9036ZBohls Richard N WIND WAGON · S/N GW10
Back to Strobach Greg