# Earlier aircraft under this name: Shamrock Aircraft Sales Inc

A list on [Shamrock Aircraft Sales Inc](https://openairdocs.org/faa-owner/SHAMROCK%20AIRCRAFT%20SALES%20INC.md).

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

- [N172CM](https://openairdocs.org/deregistered/N172CM-2018-05-25.md): Cessna 172RG · S/N 172RG0787 · Cancelled May 25, 2018 · Exported to Poland · Built 1980 · Monroe, WI
- [N4689L](https://openairdocs.org/deregistered/N4689L-2018-05-25.md): Cessna 152 · S/N 15284217 · Cancelled May 25, 2018 · Exported to Poland · Built 1980 · Monroe, WI
- [N6593L](https://openairdocs.org/deregistered/N6593L-2018-05-25.md): Cessna 152 · S/N 15284452 · Cancelled May 25, 2018 · Exported to Poland · Built 1980 · Monroe, WI
- [N757SH](https://openairdocs.org/deregistered/N757SH-2018-04-03.md): Cessna 152 · S/N 15279964 · Cancelled Apr 3, 2018 · Exported to Philippines · Built 1978 · Monroe, WI
- [N4633B](https://openairdocs.org/deregistered/N4633B-2018-03-05.md): Cessna 152 · S/N 15283559 · Cancelled Mar 5, 2018 · Exported to Mexico · Monroe, WI
- [N68795](https://openairdocs.org/deregistered/N68795-2018-02-23.md): Cessna 152 · S/N 15282378 · Cancelled Feb 23, 2018 · Exported to Mexico · Built 1978 · Monroe, WI
- [N5177B](https://openairdocs.org/deregistered/N5177B-2017-07-07.md): Cessna 152 · S/N 15283793 · Cancelled Jul 7, 2017 · Exported to Poland · Built 1979 · Monroe, WI
- [N64920](https://openairdocs.org/deregistered/N64920-2017-06-23.md): Cessna 152 · S/N 15285283 · Cancelled Jun 23, 2017 · Exported to Mexico · Built 1981 · Monroe, WI
- [N25339](https://openairdocs.org/deregistered/N25339-2017-06-22.md): Cessna 152 · S/N 15280603 · Cancelled Jun 22, 2017 · Exported to Poland · Built 1977 · Monroe, WI
- [N4450C](https://openairdocs.org/deregistered/N4450C-2017-06-22.md): Cessna 152 · S/N 15285715 · Cancelled Jun 22, 2017 · Exported to Poland · Monroe, WI
- [N757KW](https://openairdocs.org/deregistered/N757KW-2017-06-22.md): Cessna 152 · S/N 15279810 · Cancelled Jun 22, 2017 · Exported to Mexico · Built 1977 · Monroe, WI
- [N95904](https://openairdocs.org/deregistered/N95904-2016-11-17.md): Cessna 152 · S/N 15285983 · Cancelled Nov 17, 2016 · Exported to Mexico · Built 1985 · Monroe, WI
- [N89534](https://openairdocs.org/deregistered/N89534-2015-02-18.md): Cessna 152 · S/N 15282774 · Cancelled Feb 18, 2015 · Exported to Malaysia · Built 1978 · Monroe, WI
- [N739GA](https://openairdocs.org/deregistered/N739GA-2014-07-31.md): Cessna 172N · S/N 17270521 · Cancelled Jul 31, 2014 · Exported to Mexico · Built 1978 · Monroe, WI
- [N6755E](https://openairdocs.org/deregistered/N6755E-2014-03-17.md): Cessna 172N · S/N 17272061 · Cancelled Mar 17, 2014 · Exported to Canada · Built 1978 · Monroe, WI
- [N1727R](https://openairdocs.org/deregistered/N1727R-2013-11-15.md): Cessna R182 · S/N R18200537 · Cancelled Nov 15, 2013 · Exported to Brazil · Built 1978 · Monroe, WI
- [N5303L](https://openairdocs.org/deregistered/N5303L-2012-12-28.md): Cessna 152 · S/N 15284291 · Cancelled Dec 28, 2012 · Exported to Indonesia · Built 1980 · Monroe, WI
- [N25796](https://openairdocs.org/deregistered/N25796-2012-10-01.md): Cessna 152 · S/N 15280790 · Cancelled Oct 1, 2012 · Exported to Mexico · Built 1977 · Monroe, WI
- [N3916Q](https://openairdocs.org/deregistered/N3916Q-2012-08-24.md): Cessna 172L · S/N 17260016 · Cancelled Aug 24, 2012 · Exported to Brazil · Built 1971 · Monroe, WI
- [N757BR](https://openairdocs.org/deregistered/N757BR-2012-08-21.md): Cessna 152 · S/N 15279614 · Cancelled Aug 21, 2012 · Exported to Mexico · Built 1977 · Monroe, WI
- [N65642](https://openairdocs.org/deregistered/N65642-2011-11-30.md): Cessna 172P · S/N 17275795 · Cancelled Nov 30, 2011 · Exported to Indonesia · Built 1982 · Monroe, WI
- [N9584L](https://openairdocs.org/deregistered/N9584L-2011-11-17.md): Cessna 172P · S/N 17276584 · Cancelled Nov 17, 2011 · Exported to Indonesia · Built 1986 · Monroe, WI
- [N25371](https://openairdocs.org/deregistered/N25371-2011-09-27.md): Cessna 152 · S/N 15280620 · Cancelled Sep 27, 2011 · Exported to Uganda · Built 1977 · Monroe, WI
- [N52209](https://openairdocs.org/deregistered/N52209-2011-02-23.md): Cessna 172P · S/N 17274437 · Cancelled Feb 23, 2011 · Exported to Paraguay · Built 1980 · Monroe, WI
- [N739MT](https://openairdocs.org/deregistered/N739MT-2010-10-04.md): Cessna 172N · S/N 17270656 · Cancelled Oct 4, 2010 · Exported to Canada · Built 1978 · Monroe, WI
- [N67918](https://openairdocs.org/deregistered/N67918-2009-10-01.md): Cessna 152 · S/N 15282097 · Cancelled Oct 1, 2009 · Exported to South Korea · Built 1978 · Monroe, WI
- [N4921B](https://openairdocs.org/deregistered/N4921B-2009-06-29.md): Cessna 152 · S/N 15283705 · Cancelled Jun 29, 2009 · Exported to Poland · Built 1979 · Monroe, WI
- [N68352](https://openairdocs.org/deregistered/N68352-2009-04-02.md): Cessna 152 · S/N 15282278 · Cancelled Apr 2, 2009 · Exported to Poland · Built 1978 · Monroe, WI
- [N24359](https://openairdocs.org/deregistered/N24359-2008-10-27.md): Cessna 152 · S/N 15280233 · Cancelled Oct 27, 2008 · Exported to Australia · Built 1977 · Monroe, WI
- [N69107](https://openairdocs.org/deregistered/N69107-2008-06-10.md): Cessna 152 · S/N 15282485 · Cancelled Jun 10, 2008 · Exported to Hungary · Built 1978 · Monroe, WI
- [N67593](https://openairdocs.org/deregistered/N67593-2008-05-13.md): Cessna 152 · S/N 15281934 · Cancelled May 13, 2008 · Exported to Philippines · Built 1978 · Monroe, WI
- [N94197](https://openairdocs.org/deregistered/N94197-2008-05-13.md): Cessna 152 · S/N 15285619 · Cancelled May 13, 2008 · Exported to Philippines · Built 1982 · Monroe, WI
- [N789MF](https://openairdocs.org/deregistered/N789MF-2008-05-08.md): Cessna 152 · S/N 15280998 · Cancelled May 8, 2008 · Exported to Canada · Built 1977 · Monroe, WI
- [N25762](https://openairdocs.org/deregistered/N25762-2008-04-03.md): Cessna 152 · S/N 15280769 · Cancelled Apr 3, 2008 · Exported to Hungary · Built 1977 · Monroe, WI
- [N5175R](https://openairdocs.org/deregistered/N5175R-2008-03-31.md): Cessna 172S · S/N 172S9048 · Cancelled Mar 31, 2008 · Exported to Poland · Built 2002 · Monroe, WI
- [N46860](https://openairdocs.org/deregistered/N46860-2008-02-28.md): Cessna 152 · S/N 15283122 · Cancelled Feb 28, 2008 · Exported to Hungary · Built 1979 · Monroe, WI
- [N69211](https://openairdocs.org/deregistered/N69211-2008-02-06.md): Cessna 152 · S/N 15282559 · Cancelled Feb 6, 2008 · Exported to Philippines · Built 1978 · Monroe, WI
- [N49541](https://openairdocs.org/deregistered/N49541-2007-11-13.md): Cessna 152 · S/N 15283473 · Cancelled Nov 13, 2007 · Exported to Canada · Built 1979 · Monroe, WI
- [N89087](https://openairdocs.org/deregistered/N89087-2007-07-10.md): Cessna 152 · S/N 15282625 · Cancelled Jul 10, 2007 · Exported to Philippines · Built 1978 · Monroe, WI
- [N5323M](https://openairdocs.org/deregistered/N5323M-2007-07-09.md): Cessna 152 · S/N 15284532 · Cancelled Jul 9, 2007 · Exported to Philippines · Built 1980 · Monroe, WI

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

This list as a web page: https://openairdocs.org/faa-owner/SHAMROCK%20AIRCRAFT%20SALES%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.
