# Cancelled registrations: Aguila, AZ

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

Cancelled aircraft registrations in Aguila, AZ.

- [N6217L](https://openairdocs.org/deregistered/N6217L-2022-07-30.md): American AA-1 · S/N AA1-0417 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1970 · Smith Barbara A
- [N131RD](https://openairdocs.org/deregistered/N131RD-2022-03-14.md): Dickey K Shirlan E-RACER · S/N ER-1 · Cancelled Mar 14, 2022 · Dickey K Shirlan
- [N666XX](https://openairdocs.org/deregistered/N666XX-2021-10-30.md): Hurd Danny A HARMON ROCKET II · S/N 151 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2001 · Aero Optics Inc
- [N357RK](https://openairdocs.org/deregistered/N357RK-2021-07-03.md): Jannsen Ross MARK III · S/N M3-273 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1999 · Jannsen Ross A
- [N7471P](https://openairdocs.org/deregistered/N7471P-2018-08-10.md): Piper PA-24-250 · S/N 24-2662 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1961 · Chief LLC
- [N7766C](https://openairdocs.org/deregistered/N7766C-2018-03-29.md): Stits Playboy SA3A · S/N JW100 · Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1958 · Trew Robert L
- [N9556G](https://openairdocs.org/deregistered/N9556G-2018-03-15.md): Chial Steve G THUNDERGULL J · S/N 71942 · Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Chial Steve G
- [N65307](https://openairdocs.org/deregistered/N65307-2017-10-20.md): Zenith ZODIAC CH601XL · S/N 6782 · Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Spooner Frank W
- [N2QQ](https://openairdocs.org/deregistered/N2QQ-2017-07-12.md): Piper PA-22-150 · S/N 22-5413 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1957 · Dapp Eric M
- [N80062](https://openairdocs.org/deregistered/N80062-2012-02-28.md): Cessna 172M · S/N 17266342 · Cancelled Feb 28, 2012 · Exported to Canada · Built 1975 · Partee Charles H
- [N389VV](https://openairdocs.org/deregistered/N389VV-2006-01-24.md): Hopkins Michael P RUTAN/VARIVIGGEN · S/N 389 · Cancelled Jan 24, 2006 · Built 2004 · Hopkins Michael P
- [N23TN](https://openairdocs.org/deregistered/N23TN-2004-06-17.md): Nyquist Thomas P CHALLENGER II · S/N CH2-0496-1480 · Cancelled Jun 17, 2004 · Triennial form not returned · Built 1997 · Smith Harry N
- [N333AB](https://openairdocs.org/deregistered/N333AB-2003-07-14.md): Burgess Samuel C PITTS S-IE · S/N 1 · Cancelled Jul 14, 2003 · Exported to United Kingdom · Built 1982 · Mundy Terrence D
- [N9203S](https://openairdocs.org/deregistered/N9203S-2000-12-20.md): Beech B24R · S/N MC-373 · Cancelled Dec 20, 2000 · Robbins Beauford A
- [N151L](https://openairdocs.org/deregistered/N151L-2000-04-05.md): Lewis Jerry D STEWART S-51 · S/N S-117 · Cancelled Apr 5, 2000 · Triennial form not returned · Lewis Jerry D
- [N2595D](https://openairdocs.org/deregistered/N2595D-1982-11-09.md): Piper PA-38-112 · S/N 38-79A0389 · Cancelled Nov 9, 1982 · Built 1978 · Sampleys Aviation Inc
- [N6776Z](https://openairdocs.org/deregistered/N6776Z-1982-05-13.md): Piper PA-25-235 · S/N 25-2410 · Cancelled May 13, 1982 · Exported to Mexico · Sampleys Aviation Inc
- [N8798L](https://openairdocs.org/deregistered/N8798L-1980-09-04.md): Piper PA-25-235 · S/N 25-5224 · Cancelled Sep 4, 1980 · Exported to Mexico · Tri Valley Sprayers Inc
- [N4702Y](https://openairdocs.org/deregistered/N4702Y-1980-05-16.md): Piper PA-25-235 · S/N 25-4433 · Cancelled May 16, 1980 · Exported to Mexico · Tri Valley Sprayers Inc
- [N7267Z](https://openairdocs.org/deregistered/N7267Z-1980-05-16.md): Piper PA-25-235 · S/N 25-3204 · Cancelled May 16, 1980 · Exported to Mexico · Tri-Valley Sprayers Inc
- [N4783Y](https://openairdocs.org/deregistered/N4783Y-1979-07-13.md): Piper PA-25-235 · S/N 25-4552 · Cancelled Jul 13, 1979 · Built 1968 · Tri Valley Sprayers Inc
- [N4972Y](https://openairdocs.org/deregistered/N4972Y-1979-07-13.md): Piper PA-25-235 · S/N 25-4776 · Cancelled Jul 13, 1979 · Tri-Valley Sprayers Inc
- [N87319](https://openairdocs.org/deregistered/N87319-1970-09-25.md): Ercoupe 415-C · S/N 492 · Cancelled Sep 25, 1970 · Lowe Jack D

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

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