Grumman American Aviation Corp

Earlier aircraft under this name · 42

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

N4516YGulfstream American AA-5B · S/N AA5B1023Cancelled May 18, 2005 · Built 1978 · Savannah, GAN7755BGrumman American Avn AA-5C · S/N AA5-0129Cancelled Aug 4, 1980 · Clevand, OHN777GAGrumman American Avn. GA-7 · S/N GA7P-0001Cancelled Jul 31, 1980 · Cleveland, OHN6609KGrumman Acft ENG Cor-Schweizer G-164B · S/N 387BCancelled Jan 8, 1980 · Exported to Costa Rica · Savannah, GAN749GGrumman American Avn. GA-7 · S/N GA7-0108Cancelled Nov 5, 1979 · Exported to United Kingdom · Savannah, GAN751GGrumman American Avn. GA-7 · S/N GA7-0109Cancelled Jun 22, 1979 · Exported to Belgium · Savannah, GAN737GGrumman American Avn. GA-7 · S/N GA7-0105Cancelled May 9, 1979 · Exported to United Kingdom · Savannah, GAN796GAGrumman American Avn. GA-7 · S/N GA7-0086Cancelled May 2, 1979 · Exported to Spain · Savannah, GAN736GGrumman American Avn. GA-7 · S/N GA7-0104Cancelled Apr 30, 1979 · Exported to Australia · Savannah, GAN6628KGrumman Acft ENG Cor-Schweizer G-164C · S/N 10CCancelled Mar 19, 1979 · Exported to Suriname · Elmira, NYN751GAGulfstream American GA-7 · S/N GA7-0041Cancelled Mar 15, 1979 · Exported to Canada · Savannah, GAN771GAGrumman American Avn. GA-7 · S/N GA7-0058Cancelled Dec 7, 1978 · Exported to United Kingdom · Savannah, GAN730GAGrumman American Avn. GA-7 · S/N GA7-0003Cancelled Oct 26, 1978 · Exported to Canada · Savannah, GAN26480Grumman American Avn. AA-5A · S/N AA5A 0620Cancelled Sep 1, 1978 · Exported to United Kingdom · Savannah, GAN28736Grumman American Avn. AA-5B · S/N AA5B0784Cancelled Aug 9, 1978 · Exported to United Kingdom · Savannah, GAN6539KGrumman Acft ENG Cor-Schweizer G-164B · S/N 359BCancelled Aug 9, 1978 · Exported to Nicaragua · Elmira, NYN6715KGrumman Acft ENG Cor-Schweizer G-164C · S/N 25CCancelled Aug 7, 1978 · Exported to Venezuela · Elmira, NYN6546KGrumman G-164B · S/N 363BCancelled Jul 13, 1978 · Exported to Honduras · Elmira, NYN9968UGrumman American Avn. AA-5A · S/N AA5A-0368Cancelled Feb 16, 1978 · Built 1977 · Savannah, GAN6799QGrumman Acft ENG Cor-Schweizer G-164B · S/N 312BCancelled Feb 13, 1978 · Exported to Venezuela · Savannah, GAN6788QGrumman Acft ENG Cor-Schweizer G-164B · S/N 288BCancelled Jan 18, 1978 · Exported to Indonesia · Savannah, GAN6778QGrumman Acft ENG Cor-Schweizer G-164B · S/N 296BCancelled Jan 3, 1978 · Exported to Venezuela · Elmira, NYN6805QGrumman Acft ENG Cor-Schweizer G-164B · S/N 314BCancelled Dec 30, 1977 · Exported to Venezuela · Elmira, NYN6767QGrumman Acft ENG Cor-Schweizer G-164B · S/N 276BCancelled Oct 18, 1977 · Exported to Argentina · Elmira, NYN6734QGrumman Acft ENG Cor-Schweizer G-164B · S/N 249BCancelled Jun 17, 1977 · Exported to Costa Rica · Elmira, NYN46934Grumman G-164A · S/N 1240Cancelled May 13, 1977 · Cleveland, OHN8935HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1574Cancelled May 18, 1976 · Exported to Philippines · Elmira, NYN1449RGrumman American Avn. AA-1B · S/N AA1B-0549Cancelled Jul 29, 1975 · Exported to Canada · Cleveland, OHN6534LGrumman American Avn. AA-5 · S/N AA5-0634Cancelled Oct 9, 1974 · Exported to Canada · Cleveland, OHN7101LGrumman American Avn. AA-5 · S/N AA5-0401Cancelled Oct 29, 1973 · Exported to South Africa · Built 1973 · Cleveland, OHN6065LGrumman American Avn. AA-5 · S/N AA5-0165Cancelled Oct 26, 1973 · Exported to South Africa · Cleveland, OHN9929LGrumman American Avn. AA-1B · S/N AA1B-0229Cancelled Oct 3, 1973 · Exported to Canada · Built 1973 · Cleveland, OHN5821LAmerican AA-5 · S/N AA5-0221Cancelled Sep 13, 1973 · Exported to South Africa · Built 1973 · Cleveland, OHN9696LGrumman American Avn. AA-1B · S/N AA1B-0196Cancelled Sep 13, 1973 · Exported to Canada · Cleveland, OHN5436LAmerican AA-5 · S/N AA5-0336Cancelled Jun 20, 1973 · Exported to Canada · Cleveland, OHN5422LAmerican AA-5 · S/N AA5-0322Cancelled Jun 15, 1973 · Exported to Canada · Cleveland, OHN5990LAmerican AA-5 · S/N AA5-0239Cancelled May 3, 1973 · Exported to South Africa · Cleveland, OHN7359LAmerican AA-1B · S/N AA1B-0059Cancelled May 3, 1973 · Exported to South Africa · Cleveland, OHN7372LGrumman American Avn. AA-5 · S/N AA5-0272Cancelled May 3, 1973 · Exported to South Africa · Cleveland, OHN9635LAmerican AA-1B · S/N AA1B-0135Cancelled May 2, 1973 · Exported to South Africa · Cleveland, OHN9637LGrumman American Avn. AA-1B · S/N AA1B-0137Cancelled May 2, 1973 · Exported to South Africa · Cleveland, OHN6374LAmerican AA-5 · S/N AA5-0244Cancelled Apr 13, 1973 · Exported to New Zealand · Cleveland, OH
Back to Grumman American Aviation Corp