# Cancelled registrations: Stanfield, AZ

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

Cancelled aircraft registrations in Stanfield, AZ.

- [N953LS](https://openairdocs.org/deregistered/N953LS-2018-06-21.md): John Roscoe AUTOGYRO CAVALON · S/N V00110 · Cancelled Jun 21, 2018 · Built 2013 · Fleming William J
- [N3754P](https://openairdocs.org/deregistered/N3754P-2018-01-18.md): Piper PA-22-150 · S/N 22-3475 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1955 · Hett Paul J
- [N2927D](https://openairdocs.org/deregistered/N2927D-2017-04-07.md): Cessna 170 · S/N 26870 · Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Hett Paul J
- [N2877E](https://openairdocs.org/deregistered/N2877E-2017-03-21.md): Aeronca 7AC · S/N 7AC-6460 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1946 · Hett Paul Joseph
- [N4905Y](https://openairdocs.org/deregistered/N4905Y-2014-10-14.md): Piper PA-25-235 · S/N 25-4711 · Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Walton Enterprises Inc
- [N6910Z](https://openairdocs.org/deregistered/N6910Z-2013-05-02.md): Piper PA-25-235 · S/N 25-2649 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1964 · Walton Enterprises
- [N61570](https://openairdocs.org/deregistered/N61570-2013-04-10.md): Consolidated Vultee BT-15 · S/N 7494 · Cancelled Apr 10, 2013 · Revoked, pending cancellation · Built 1943 · Lannon John D
- [N3105B](https://openairdocs.org/deregistered/N3105B-1997-02-18.md): Ayres S2R-T34 · S/N T34136DC · Cancelled Feb 18, 1997 · Goodwin Susan Trustee
- [N7789C](https://openairdocs.org/deregistered/N7789C-1992-11-18.md): Corben Baby Ace NILSSON B-1 · S/N 1000 · Cancelled Nov 18, 1992 · Triennial form not returned · Hett Paul J
- [N731VU](https://openairdocs.org/deregistered/N731VU-1989-10-10.md): Cessna A188B · S/N 18803197T · Cancelled Oct 10, 1989 · Triennial form not returned · Walton Enterprises DBA
- [N5614J](https://openairdocs.org/deregistered/N5614J-1982-03-24.md): Cessna A188 · S/N 188-0564 · Cancelled Mar 24, 1982 · Exported to Mexico · Walton Enterprises Inc
- [N4017A](https://openairdocs.org/deregistered/N4017A-1981-12-01.md): Ayres S-2R · S/N 2556R · Cancelled Dec 1, 1981 · Exported to Mexico · Built 1979 · Custom Farm Service Of Arizona
- [N2487Q](https://openairdocs.org/deregistered/N2487Q-1980-10-21.md): Piper PA-25-235 · S/N 25-8056031 · Cancelled Oct 21, 1980 · Exported to Mexico · Custom Farm Service Of Arizona
- [N2563Q](https://openairdocs.org/deregistered/N2563Q-1980-10-21.md): Piper PA-25-235 · S/N 25-8056040 · Cancelled Oct 21, 1980 · Exported to Mexico · Custom Farm Service Of Arizona
- [N2519Q](https://openairdocs.org/deregistered/N2519Q-1980-10-20.md): Piper PA-25-235 · S/N 25-8056039 · Cancelled Oct 20, 1980 · Exported to Mexico · Custom Farm Service Of Arizona
- [N6708Q](https://openairdocs.org/deregistered/N6708Q-1979-09-25.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 223B · Cancelled Sep 25, 1979 · Exported to Mexico
- [N80461](https://openairdocs.org/deregistered/N80461-1979-08-31.md): Cessna 172M · S/N 17266599 · Cancelled Aug 31, 1979 · Exported to Canada · Russell Victor L
- [N6788Z](https://openairdocs.org/deregistered/N6788Z-1977-10-28.md): Piper PA-25-235 · S/N 25-2431 · Cancelled Oct 28, 1977 · Custom Farm Service Of Arizona
- [N8959Q](https://openairdocs.org/deregistered/N8959Q-1977-07-18.md): Aero Commander S2R · S/N 1629R · Cancelled Jul 18, 1977 · Custom Farm Services Of Arizona Inc
- [N83353](https://openairdocs.org/deregistered/N83353-1971-02-17.md): Aeronca 7AC · S/N 7AC2020 · Cancelled Feb 17, 1971 · Stanfield Flying Club Inc
- [N7066C](https://openairdocs.org/deregistered/N7066C-1963-05-13.md): North American AT-6C · S/N 88-13468 · Cancelled May 13, 1963 · James Kortsen

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

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