# Cancelled registrations: Santa Teresa, NM

A list on [Santa Teresa, NM](https://openairdocs.org/faa-place/NM/Santa%20Teresa.md).

Cancelled aircraft registrations in Santa Teresa, NM.

- [N737GX](https://openairdocs.org/deregistered/N737GX-2019-03-12.md): Cessna 172N · S/N 17269417 · Cancelled Mar 12, 2019 · Exported to Mexico · Built 1977 · Pinos Altos Import & Export Inc
- [N5315C](https://openairdocs.org/deregistered/N5315C-2019-02-06.md): Cessna T210N · S/N 21063730 · Cancelled Feb 6, 2019 · Exported to Mexico · Built 1979 · Pinos Altos Import & Export Inc
- [N6974L](https://openairdocs.org/deregistered/N6974L-2018-01-08.md): Cessna 310K · S/N 310K0074 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1966 · Cp Aviation Services Co
- [N210MK](https://openairdocs.org/deregistered/N210MK-2017-07-12.md): Cessna T210N · S/N 21064833 · Cancelled Jul 12, 2017 · Exported to Mexico · Built 1984 · Pinos Altos Import & Export Inc
- [N190W](https://openairdocs.org/deregistered/N190W-2015-10-02.md): Cessna 190 · S/N 7537 · Cancelled Oct 2, 2015 · Third renewal notice · Perlan Aviation LLC
- [N621BM](https://openairdocs.org/deregistered/N621BM-2014-03-24.md): Mikoyan Gurevich MIG 15 · S/N 1B01621 · Cancelled Mar 24, 2014 · Macguire John
- [N303AT](https://openairdocs.org/deregistered/N303AT-2014-02-07.md): Cessna 172S · S/N 172S9319 · Cancelled Feb 7, 2014 · Exported to Mexico · Built 2003 · Francis Capital Leasing LLC
- [N145SP](https://openairdocs.org/deregistered/N145SP-2013-09-26.md): Boeing 707-323B · S/N 20174 · Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1969 · Tokoph David
- [N5530B](https://openairdocs.org/deregistered/N5530B-2013-06-27.md): Cessna 182 · S/N 33530 · Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1956 · Beuden Marcel
- [N614BM](https://openairdocs.org/deregistered/N614BM-2013-03-25.md): Mikoyan Gurevich MIG 15 · S/N 1B01614 · Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Macguire John
- [N138U](https://openairdocs.org/deregistered/N138U-2012-07-27.md): Pilatus P-2/06 · S/N 58 · Cancelled Jul 27, 2012 · Exported to Germany · Built 1950 · Babel Francois P
- [N4054M](https://openairdocs.org/deregistered/N4054M-2010-11-24.md): Pilatus P3-05 · S/N 47322 · Cancelled Nov 24, 2010 · Exported to Switzerland · Built 1958 · Haberling Hermann Hp
- [N5299A](https://openairdocs.org/deregistered/N5299A-2009-08-05.md): Cessna T210N · S/N 21063355 · Cancelled Aug 5, 2009 · Exported to Mexico · Built 1979 · Alarcon Armando
- [N756HB](https://openairdocs.org/deregistered/N756HB-2008-11-10.md): Cessna TU206G · S/N U20604094 · Cancelled Nov 10, 2008 · Exported to Mexico · Built 1977 · Alarcon Armando
- [N5290B](https://openairdocs.org/deregistered/N5290B-2008-09-05.md): Cessna 152 · S/N 15283828 · Cancelled Sep 5, 2008 · Triennial form not returned · Built 1979 · Ttea Inc
- [N58171](https://openairdocs.org/deregistered/N58171-2003-09-25.md): Cameron Balloons O-77 · S/N 5017 · Cancelled Sep 25, 2003 · Second triennial mailing, no response · Built 1983 · Stanton Ronald L
- [N319CH](https://openairdocs.org/deregistered/N319CH-2001-06-05.md): Learjet 31A · S/N 041 · Cancelled Jun 5, 2001 · Exported to Philippines · Hurd C W Jr
- [N8104N](https://openairdocs.org/deregistered/N8104N-1997-12-02.md): Boeing 727-25 · S/N 18255 · Cancelled Dec 2, 1997 · Exported to Kenya · Tokoph David
- [N96GS](https://openairdocs.org/deregistered/N96GS-1991-01-17.md): Lockheed 1329 · S/N 5068 · Cancelled Jan 17, 1991 · Tokoph David

## 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_state = 'NM' AND d.registrant_city = 'SANTA TERESA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/NM/Santa%20Teresa/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.
