# Cancelled registrations: Mayaguez, PR

A list on [Mayaguez, PR](https://openairdocs.org/faa-place/PR/Mayaguez.md).

Cancelled aircraft registrations in Mayaguez, PR.

- [N413RA](https://openairdocs.org/deregistered/N413RA-2021-07-03.md): Audain Renford B COZY MARK III · S/N 349 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Perez Pedro J
- [N858JS](https://openairdocs.org/deregistered/N858JS-2020-08-02.md): Segarra Jose CHALLENGER II · S/N CH2-0693-0986 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Segarra Jose
- [N3889D](https://openairdocs.org/deregistered/N3889D-2019-09-06.md): Cessna 182A · S/N 34589 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1957 · Diaz Ernesto
- [N3337P](https://openairdocs.org/deregistered/N3337P-2018-09-07.md): Piper PA-23-160 · S/N 23-1289 · Cancelled Sep 7, 2018 · Revoked, canceled · Built 1958 · Maldonado Ortiz Ruben E
- [N5100W](https://openairdocs.org/deregistered/N5100W-2018-08-23.md): Piper PA-28 · S/N 28-114 · Cancelled Aug 23, 2018 · Revoked, canceled · Built 1961 · Cleaver James A
- [N5244Y](https://openairdocs.org/deregistered/N5244Y-2018-03-27.md): Piper PA-23-250 · S/N 27-2296 · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1963 · Western Agro Inc
- [N7213Z](https://openairdocs.org/deregistered/N7213Z-2017-11-21.md): Piper PA-25-235 · S/N 25-3072 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1964 · Du Pre Air Activities Inc
- [N8775S](https://openairdocs.org/deregistered/N8775S-2013-09-12.md): Cessna 150F · S/N 15062075 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1965 · Folch Minerva
- [N4014Q](https://openairdocs.org/deregistered/N4014Q-2013-07-19.md): Cessna 402 · S/N 402-0114 · Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1967 · Ramos Luis H Vargas
- [N211RK](https://openairdocs.org/deregistered/N211RK-2013-07-09.md): Reyes Carlos Mari PIONEER DUALSTAR · S/N DS-1000SN · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1985 · Reyes Luis J
- [N9884F](https://openairdocs.org/deregistered/N9884F-2013-05-30.md): Cessna 401 · S/N 401-0304 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1968 · Western Agro
- [N191RR](https://openairdocs.org/deregistered/N191RR-2013-05-16.md): Martinez Enrique R REVOLUTION MINI 500 · S/N 220 · Cancelled May 16, 2013 · Registration expired, pending cancellation · Ripoll Ramon Anglada
- [N734TP](https://openairdocs.org/deregistered/N734TP-2013-05-07.md): Cessna 172N · S/N 17269103 · Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Airfoils Systems Inc
- [N2084Z](https://openairdocs.org/deregistered/N2084Z-2013-04-10.md): Cessna 150C · S/N 15059884 · Cancelled Apr 10, 2013 · Revoked, pending cancellation · Built 1963 · Solano Oritz Morales
- [N5603H](https://openairdocs.org/deregistered/N5603H-2012-11-13.md): Piper PA-16 · S/N 16-210 · Cancelled Nov 13, 2012 · Revoked, pending cancellation · Built 1949 · Silva Rolando
- [N4138E](https://openairdocs.org/deregistered/N4138E-2011-02-28.md): Aeronca 11CC · S/N 11CC45 · Cancelled Feb 28, 2011 · Revoked, pending cancellation · Built 1947 · Garrett Carlos R
- [N2370J](https://openairdocs.org/deregistered/N2370J-2002-05-23.md): Beech 23 · S/N M-334 · Cancelled May 23, 2002 · Triennial form not returned · Built 1963 · Cruz Hector
- [N7214Q](https://openairdocs.org/deregistered/N7214Q-1998-03-13.md): Cessna 172L · S/N 17260514 · Cancelled Mar 13, 1998 · Exported to Canada · Marques Walter A
- [N3204P](https://openairdocs.org/deregistered/N3204P-1994-12-21.md): Piper PA-23 · S/N 231144 · Cancelled Dec 21, 1994 · Exported to Belize · Marques Walter A

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

This list as a web page: https://openairdocs.org/faa-place/PR/Mayaguez/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.