Skip to content

Gulfstream American Corp

Earlier aircraft under this name · 43

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 = 'GULFSTREAM AMERICAN CORP' OR list_contains(d.other_registrant_names, 'GULFSTREAM AMERICAN CORP') 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 = 'GULFSTREAM AMERICAN CORP' OR list_contains(d.other_registrant_names, 'GULFSTREAM AMERICAN CORP')
  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 = 'GULFSTREAM AMERICAN CORP' OR list_contains(d.other_registrant_names, 'GULFSTREAM AMERICAN CORP')
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.

N5852NGulfstream AM Corp Comm Div 690D · S/N 15006Cancelled May 7, 1985 · Exported to Venezuela · Bethany, OK N600GAGulfstream American PEREGRINE 600 · S/N 601Cancelled Mar 22, 1984 · Bethany, OK N310GAGulfstream American G-1159A · S/N 389Cancelled Nov 21, 1983 · Savannah, GA N8182KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 603BCancelled Nov 17, 1982 · Exported to Suriname · Savannah, GA N8183KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 604BCancelled Nov 17, 1982 · Exported to Venezuela · Savannah, GA N8186KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 605BCancelled Nov 17, 1982 · Exported to Venezuela · Savannah, GA N5964KGulfstream AM Corp Comm Div 690C · S/N 11726Cancelled Nov 8, 1982 · Exported to Venezuela · Bethany, OK N8248KGrumman Acft ENG Cor-Schweizer G-164B · S/N 620BCancelled Nov 4, 1982 · Exported to Venezuela · Elmira, NY N74SARockwell International 690C · S/N 11678Cancelled Mar 17, 1982 · Exported to Venezuela · Bethany, OK N5950KGulfstream AM Corp Comm Div 690C · S/N 11698Cancelled Jan 22, 1982 · Exported to Venezuela · Bethany, OK N8008KGrumman Acft ENG Cor-Schweizer G-164B · S/N 536BCancelled Jul 31, 1981 · Exported to Algeria · Savannah, GA N8013KGrumman American Avn. G-164B · S/N 539BCancelled Jul 31, 1981 · Exported to Algeria · Savannah, GA N9002NAero Commander 500 S · S/N 1827-27Cancelled Jul 15, 1981 · Exported to Iran · Bethany, OK N203GAGrumman G-1159 · S/N 124Cancelled Jun 19, 1981 · Exported to Venezuela · Built 1973 · Savannah, GA N726GGulfstream American GA-7 · S/N GA7-0099Cancelled May 26, 1981 · Exported to Argentina · Savannah, GA N8321KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 15DCancelled May 7, 1981 · Exported to United Kingdom · Savannah, GA N8312KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 12DCancelled Apr 17, 1981 · Exported to United Kingdom · Savannah, GA N26999Gulfstream American AA-5A · S/N AA5A-0872Cancelled Jan 21, 1981 · Exported to Canada · Built 1979 · Savannah, GA N8142KGrumman Acft ENG Cor-Schweizer G-164B · S/N 584BCancelled Sep 29, 1980 · Exported to Venezuela · Savannah, GA N8160KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 592BCancelled Sep 12, 1980 · Exported to Venezuela · Savannah, GA N8221KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 621BCancelled Sep 12, 1980 · Exported to Venezuela · Savannah, GA N8224KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 618BCancelled Sep 12, 1980 · Exported to Venezuela · Savannah, GA N8262KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 10DCancelled Jun 6, 1980 · Exported to South Africa · Savannah, GA N8218KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 615BCancelled May 22, 1980 · Exported to Venezuela · Savannah, GA N4547LGulfstream American AA-5B · S/N AA5B1161Cancelled Apr 3, 1980 · Exported to United Kingdom · Built 1979 · Savannah, GA N6563KGrumman Acft ENG Cor-Schweizer G-164B · S/N 370BCancelled Feb 27, 1980 · Exported to Yugoslavia · Elmira, NY N6586KGrumman G-164B · S/N 380BCancelled Feb 27, 1980 · Exported to Yugoslavia · Elmira, NY N6583KGrumman G-164B · S/N 379BCancelled Feb 26, 1980 · Exported to Yugoslavia N8249KGrumman Acft ENG Cor-Schweizer G-164B · S/N 616BCancelled Feb 11, 1980 · Exported to Venezuela · Elmira, NY N8161KSchweizer G-164D · S/N 7DCancelled Dec 14, 1979 · Exported to United Kingdom N758GGrumman American Avn. GA-7 · S/N GA7-0111Cancelled Aug 31, 1979 · Exported to Norway · Savannah, GA N26998Gulfstream American AA-5A · S/N AA5A-0870Cancelled Aug 21, 1979 · Exported to United Kingdom · Savannah, GA N8176KGrumman G-164B · S/N 602BCancelled Aug 7, 1979 · Exported to Canada · Savannah, GA N759GGrumman American Avn. GA-7 · S/N GA7-0112Cancelled Jun 26, 1979 · Exported to Australia · Savannah, GA N721GGulfstream American GA-7 · S/N GA7-0094Cancelled Jun 20, 1979 · Exported to United Kingdom · Savannah, GA N798GAGulfstream American GA-7 · S/N GA7-0089Cancelled Mar 13, 1979 · Exported to Switzerland N750GAGrumman American Avn. GA-7 · S/N GA7-0040Cancelled Mar 9, 1979 · Exported to Canada · Savannah, GA N783GAGulfstream American GA-7 · S/N GA7-0070Cancelled Jan 12, 1979 · Exported to Australia · Savannah, GA N788GAGrumman American Avn. GA-7 · S/N GA70076Cancelled Dec 27, 1978 · Exported to Canada N770GAGrumman American Avn. GA-7 · S/N GA7-0057Cancelled Nov 27, 1978 · Exported to Denmark · Savannah, GA N39033Grumman American Avn. AA-1C · S/N AA-1C-0194Cancelled Oct 18, 1978 · Exported to New Zealand · Savannah, GA N26477Grumman American Avn. AA-5A · S/N AA5A0617Cancelled Sep 14, 1978 · Exported to United Kingdom · Savannah, GA N83SARockwell International 690C · S/N 11700Cancellation date not recorded · Bethany, OK

Back to Gulfstream American Corp