# Earlier aircraft under this name: Crystal Shamrock Inc

A list on [Crystal Shamrock Inc](https://openairdocs.org/faa-owner/CRYSTAL%20SHAMROCK%20INC.md).

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

- [N1727T](https://openairdocs.org/deregistered/N1727T-2011-03-15.md): Cessna 172N · S/N 17270323 · Cancelled Mar 15, 2011 · Exported to Serbia · Built 1978 · Crystal, MN
- [N3333P](https://openairdocs.org/deregistered/N3333P-1996-05-21.md): Piper PA-23-160 · S/N 231284 · Cancelled May 21, 1996 · Triennial form not returned · Minneapolis, MN
- [N64406](https://openairdocs.org/deregistered/N64406-1992-02-03.md): Cessna 172P · S/N 17275556 · Cancelled Feb 3, 1992 · Triennial form not returned · Minneapolis, MN
- [N7427N](https://openairdocs.org/deregistered/N7427N-1986-01-27.md): Cessna U206G · S/N U20603658 · Cancelled Jan 27, 1986 · Exported to United Kingdom · Minneapolis, MN
- [N757XJ](https://openairdocs.org/deregistered/N757XJ-1986-01-13.md): Cessna 152 · S/N 15280083 · Cancelled Jan 13, 1986 · Exported to United Kingdom · Minneapolis, MN
- [N66396](https://openairdocs.org/deregistered/N66396-1976-05-19.md): Cessna 150M · S/N 15076020 · Cancelled May 19, 1976 · Minneapolis, MN
- [N8680J](https://openairdocs.org/deregistered/N8680J-1976-05-03.md): Cessna 150G · S/N 15066580 · Cancelled May 3, 1976 · Exported to Canada · Minneapolis, MN
- [N6641H](https://openairdocs.org/deregistered/N6641H-1976-01-06.md): Cessna 172M · S/N 17265521 · Cancelled Jan 6, 1976 · Exported to Canada · Minneapolis, MN
- [N61805](https://openairdocs.org/deregistered/N61805-1976-01-05.md): Cessna 172M · S/N 17264814 · Cancelled Jan 5, 1976 · Exported to Canada · Minneapolis, MN
- [N33925](https://openairdocs.org/deregistered/N33925-1975-10-15.md): Cessna 210J · S/N 21059192 · Cancelled Oct 15, 1975 · Minneapolis, MN
- [N9192B](https://openairdocs.org/deregistered/N9192B-1975-08-08.md): Cessna 172 · S/N 36792 · Cancelled Aug 8, 1975 · Exported to Canada · Minneapolis, MN
- [N5975G](https://openairdocs.org/deregistered/N5975G-1975-07-18.md): Cessna 150K · S/N 15071475 · Cancelled Jul 18, 1975 · Exported to Canada · Minneapolis, MN
- [N4898C](https://openairdocs.org/deregistered/N4898C-1975-06-04.md): Cessna A185F · S/N 18502649 · Cancelled Jun 4, 1975 · Exported to Canada · Built 1975 · Minneapolis, MN
- [N35693](https://openairdocs.org/deregistered/N35693-1975-02-18.md): Cessna 172I · S/N 17256913 · Cancelled Feb 18, 1975 · Exported to Canada · Minneapolis, MN
- [N11362](https://openairdocs.org/deregistered/N11362-1974-12-05.md): Cessna 150L · S/N 15075353 · Cancelled Dec 5, 1974 · Exported to Canada · Built 1973 · Minneapolis, MN
- [N4598Q](https://openairdocs.org/deregistered/N4598Q-1974-09-06.md): Cessna 402A · S/N 402A0098 · Cancelled Sep 6, 1974 · Exported to Australia · Built 1969 · Minneapolis, MN
- [N92856](https://openairdocs.org/deregistered/N92856-1974-07-30.md): Cessna 182N · S/N 182-60398 · Cancelled Jul 30, 1974 · Exported to Canada · Minneapolis, MN
- [N17237](https://openairdocs.org/deregistered/N17237-1974-02-13.md): Cessna 150L · S/N 15073683 · Cancelled Feb 13, 1974 · Exported to Canada · Minneapolis, MN
- [N3723U](https://openairdocs.org/deregistered/N3723U-1973-10-02.md): Cessna 182G · S/N 18255123 · Cancelled Oct 2, 1973 · Exported to Canada · Minneapolis, MN
- [N564GS](https://openairdocs.org/deregistered/N564GS-1973-09-10.md): Cessna 150K · S/N 15071444 · Cancelled Sep 10, 1973 · Exported to Canada · Minneapolis, MN
- [N2721U](https://openairdocs.org/deregistered/N2721U-1973-04-12.md): Cessna 172D · S/N 17250321 · Cancelled Apr 12, 1973 · Exported to Canada
- [N7674G](https://openairdocs.org/deregistered/N7674G-1973-02-22.md): Cessna 172L · S/N 17259374 · Cancelled Feb 22, 1973 · Exported to Canada · Minneapolis, MN
- [N4217F](https://openairdocs.org/deregistered/N4217F-1972-09-26.md): Cessna 172 · S/N 46117 · Cancelled Sep 26, 1972 · Exported to Canada · Minneapolis, MN
- [N7784P](https://openairdocs.org/deregistered/N7784P-1972-04-04.md): Piper PA-24-250 · S/N 24-3001 · Cancelled Apr 4, 1972 · Exported to Canada · Built 1962 · Minneapolis, MN
- [N6708E](https://openairdocs.org/deregistered/N6708E-1972-02-16.md): Cessna 175 · S/N 175-56208 · Cancelled Feb 16, 1972 · Exported to Canada · Minneapolis, MN
- [N79170](https://openairdocs.org/deregistered/N79170-1971-06-25.md): Cessna 172K · S/N 17257933 · Cancelled Jun 25, 1971 · Exported to Canada · Minneapolis, MN
- [N871VU](https://openairdocs.org/deregistered/N871VU-1968-03-05.md): Cessna 172 · S/N 28132 · Cancelled Mar 5, 1968 · Exported to Canada · Built 1956 · Minneapolis, MN
- [N9962A](https://openairdocs.org/deregistered/N9962A-1968-02-13.md): Cessna 170A · S/N 19322 · Cancelled Feb 13, 1968 · Exported to Canada · Minneapolis, MN
- [N1758F](https://openairdocs.org/deregistered/N1758F-1968-02-07.md): Cessna 172H · S/N 17255153 · Cancelled Feb 7, 1968 · Exported to Canada · Built 1966 · Minneapolis, MN

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 = 'CRYSTAL SHAMROCK INC' OR list_contains(d.other_registrant_names, 'CRYSTAL SHAMROCK INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/CRYSTAL%20SHAMROCK%20INC/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.