Skip to content

Earlier aircraft under this name · 125

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

Query with SQL

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

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.

N345JFCessna 150M · S/N 15076291Cancelled Sep 18, 2009 · Registration revoked · Built 1974 · Triplet Wilton C, Phoenix, AZ N345JFCessna 150M · S/N 150-76291Cancelled Aug 18, 2006 · Registration revoked · Built 1974 · Triplet Wilton C, Phoenix, AZ N8759DPiper PA-22-160 · S/N 22-5943Cancelled Sep 16, 1985 · Administratively canceled · Chitiea Andrew D, Aurora, CO N89757Cessna 152 · S/N 15282855Cancelled Mar 20, 1985 · Administratively canceled · Boardman Flight Academy Inc, Fort Worth, TX N9196ACessna 170A · S/N 18957Cancelled Feb 14, 1985 · Administratively canceled · Mcleod Albert D, Moss Point, MS N8917VCessna 172M · S/N 17264274Cancelled Jan 31, 1985 · Administratively canceled · Civil Air Patrol Inc, Maxwell Afb, AL N9002QBeech V35B · S/N D-9166Cancelled Jan 31, 1985 · Administratively canceled · Swoboda Robert H, Cairo, IL N9050DPiper PA-22-160 · S/N 22-6189Cancelled Jan 31, 1985 · Administratively canceled · Faber Harold E, Bonners Ferry, ID N9094PPiper PA-24-260 · S/N 24-4569Cancelled Jan 31, 1985 · Administratively canceled · Phoenix Flyers Inc, Phoenix, AZ N8807TCessna 182C · S/N 52707Cancelled Jan 22, 1985 · Administratively canceled · St Maries Cap Aero Club Inc, St Maries, ID N9164YPiper PA-31-310 · S/N 31-217Cancelled Jan 22, 1985 · Administratively canceled · Turbo Sales And Leasing, Bowling Green, KY N8969ZCessna 310G · S/N 310G0069Cancelled Oct 26, 1984 · Administratively canceled · Chrisair Management Services Inc, Ny, NY N9056UGlover Ray M MUSTANG II · S/N M-II289Cancelled Oct 5, 1984 · Administratively canceled · Glover Ray M, Spencer, OK N8908PPiper PA-24-260 · S/N 24-4363Cancelled Oct 3, 1984 · Administratively canceled · Emr Aviation, Redmond, WA N9083HCessna 172M · S/N 17265931Cancelled Oct 3, 1984 · Administratively canceled · Lake Tahoe Aviation Inc, South Lake Tahoe, CA N90286Robinson Helicopter R22 · S/N 0051Cancelled Aug 20, 1984 · Administratively canceled · Kenn Air Corporation, Westlake, OH N90534Gardner J L STEEN SKYBOLT-A · S/N 7-13-19Cancelled Jul 18, 1984 · Administratively canceled · Gardner Junior L, Milton, FL N8801FHughes 269A · S/N 112-0135Cancelled Jul 11, 1984 · Administratively canceled · Johnston John H, Wetumpka, AL N90977Bellanca 7ECA · S/N 903-73Cancelled Jul 11, 1984 · Administratively canceled · Vaughan Michael R, Kansas, IL N9125GCessna A188B · S/N 18801386TCancelled Jul 11, 1984 · Administratively canceled · Lewis Roger E, Sterlington, LA N9031FRobinson Helicopter R22 · S/N 0077Cancelled Jul 6, 1984 · Administratively canceled · Roto Flite Inc, Wabash, IN N8952LGrumman American Avn. AA-1B · S/N AA1B-0402Cancelled Jul 3, 1984 · Administratively canceled · Moore Teddy L, Columbus, OH N8979LGrumman American Avn. AA-1B · S/N AA1B-0429Cancelled Jul 3, 1984 · Administratively canceled · Hanusa Robert L, Wailuku Maui, HI N89948Cessna 152 · S/N 15282924Cancelled Jul 3, 1984 · Administratively canceled · Rozhon & Schiejok Inc DBA, Hollywood, FL N90015Bell 206B · S/N 1528Cancelled Jun 15, 1984 · Administratively canceled · Triple S Drilling Co Inc, Liberty, KY N87643Douglas C-47A · S/N 13060Cancelled Jun 2, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87666Douglas C-47D · S/N 32589Cancelled Jun 2, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N90982Bellanca 7ECA · S/N 906-73Cancelled Jun 2, 1984 · Administratively canceled · Mckinley William Isaac, Pearsall, TX N87626Douglas C-47A · S/N 9988Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87627Douglas C-47A · S/N 13660Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Company, Tucson, AZ N87665Douglas C-47D · S/N 32572Cancelled May 26, 1984 · Administratively canceled · Acme Aircraft Co, Tucson, AZ N87985General Dynamics 240-27 · S/N 338Cancelled May 26, 1984 · Administratively canceled · Niswonger Scott M, Greeneville, TN N91354Douglas B-26C · S/N 41-39468Cancelled May 26, 1984 · Administratively canceled · Reeder Flying Service Inc, Twin Falls, ID N9155Failing-Falconer Teal AMPHIBIAN 121 · S/N 121.199BCancelled May 26, 1984 · Administratively canceled · Olsen David A, Machias, ME N880PABoeing 707-321B · S/N 20019Cancelled Apr 10, 1984 · Administratively canceled · Maushardt Bernard L Trustee, San Francisco, CA N8904WPiper PA-28-235 · S/N 28-10470Cancelled Apr 10, 1984 · Administratively canceled · Osborn Construction Co, Sapulpa, OK N2606MHarris Jack R QUICKSILVER MX II · S/N 4024Cancelled Apr 3, 1984 · Administratively canceled · Harris Jack R, Gilbert, AZ N90595Beech T-34B · S/N BG396Cancelled Mar 17, 1984 · Administratively canceled · US Navy Owner Flyg, Fpo Miami, FL N90019Cessna 140 · S/N 9077Cancelled Mar 10, 1984 · Administratively canceled · Prescott Robert G, Manchester, NH N8781VBellanca 17-30A · S/N 30321Cancelled Feb 22, 1984 · Administratively canceled · Donelson Martin Jr, Danville, VA N9164MCessna 182P · S/N 18264713Cancelled Feb 13, 1984 · Administratively canceled · Par Electrical Contractors Inc, North Kansas City, MO N8876UCessna 150M · S/N 15078010Cancelled Jan 13, 1984 · Administratively canceled · Dixie Air Inc, Tuscaloosa, AL N896CLBeech A23-24 · S/N MA-77Cancelled Jan 10, 1984 · Administratively canceled · Greenwood Deborah J, Falls Church, VA N9200DPiper PA-22-160 · S/N 22-6259Cancelled Jan 10, 1984 · Administratively canceled · Janecek Frank H Jr, Windham, OH N8825BCessna 172 · S/N 36525Cancelled Nov 29, 1983 · Administratively canceled · Cornman Lyle L, Kingman, AZ N8902FHughes 269A · S/N 0279Cancelled Nov 29, 1983 · Administratively canceled · Helicopters Ltd, Durand, MI N890LCessna 172M · S/N 17262750Cancelled Nov 29, 1983 · Administratively canceled · Poindexter James D, Seabrook, TX N89DAAero Commander 680V · S/N 1702-78Cancelled Nov 29, 1983 · Administratively canceled · B E S Leasing Co, Lake Jackson, TX N90654Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-105Cancelled Nov 29, 1983 · Administratively canceled · Mbb Helicopter Corporation, West Chester, PA N90655Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-106Cancelled Nov 29, 1983 · Administratively canceled · Mbb Helicopter Corporation, West Chester, PA

Back to Strobach Greg