# Cancelled registrations: Somerton, AZ

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

Cancelled aircraft registrations in Somerton, AZ.

- [N3463C](https://openairdocs.org/deregistered/N3463C-2023-09-16.md): Cessna 170B · S/N 26506 · Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1954
- [N560LB](https://openairdocs.org/deregistered/N560LB-2022-07-30.md): Aero Commander 560-F · S/N 1223-49 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1962 · Daugherty Lowell E
- [N57799](https://openairdocs.org/deregistered/N57799-2021-10-30.md): Piper PA-36-285 · S/N 36-7660116 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1976 · Hill Curtis E
- [N197T](https://openairdocs.org/deregistered/N197T-2020-10-03.md): Piper PA-18-105 SPECIAL · S/N 18-2311 · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1953 · Keith Sirus K
- [N2338R](https://openairdocs.org/deregistered/N2338R-2020-10-03.md): Cessna 182G · S/N 18255438 · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1964 · Brown Randy L Trustee
- [N290R](https://openairdocs.org/deregistered/N290R-2020-10-03.md): Schweizer 269C · S/N S1537 · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1991 · Hill Curtis E
- [N8284K](https://openairdocs.org/deregistered/N8284K-2020-03-02.md): Stinson 108-1 · S/N 108-1284 · Cancelled Mar 2, 2020 · Sale reported, canceled · Built 1946
- [N6630X](https://openairdocs.org/deregistered/N6630X-2017-06-30.md): Cessna 210A · S/N 21057630 · Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1960 · Tri Rotor Ag Services
- [N8013Z](https://openairdocs.org/deregistered/N8013Z-2017-04-18.md): Cessna U206 · S/N U206-0413 · Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1965 · Lawless Stanley A Trustee
- [N5950Z](https://openairdocs.org/deregistered/N5950Z-2015-05-05.md): Piper PA-22-108 · S/N 22-9821 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1964 · Buckelew Traver R
- [N591SP](https://openairdocs.org/deregistered/N591SP-2015-01-23.md): Piper PA-28-140 · S/N 28-22400 · Cancelled Jan 23, 2015 · Fieldgrove Matt
- [N7104Z](https://openairdocs.org/deregistered/N7104Z-2014-11-13.md): Piper PA-25-235 · S/N 25-2899 · Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1964 · Aero Applicators Inc
- [N62349](https://openairdocs.org/deregistered/N62349-2013-04-29.md): Hiller UH-12E · S/N 1080 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1959 · Ag Spray Inc
- [N3596Q](https://openairdocs.org/deregistered/N3596Q-2012-10-09.md): Cessna A188 · S/N 188-0546 · Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1969 · Valley Sprayer And Duster Svc Inc
- [N7083M](https://openairdocs.org/deregistered/N7083M-2008-03-17.md): Cessna 175 · S/N 55383 · Cancelled Mar 17, 2008 · Exported to Mexico · Fieldgrove Matt L
- [N871C](https://openairdocs.org/deregistered/N871C-2003-05-05.md): Stinson 108-3 · S/N 108-3871 · Cancelled May 5, 2003 · Triennial form not returned · Built 1947 · Eaton Robert F
- [N2014U](https://openairdocs.org/deregistered/N2014U-1999-09-01.md): Weatherly 620B · S/N 1566 · Cancelled Sep 1, 1999 · Morris Ag Air And Sons Inc
- [N65187](https://openairdocs.org/deregistered/N65187-1981-03-13.md): Beech TC-45J · S/N 3-9922 · Cancelled Mar 13, 1981 · Exported to Canada · Barkley Company Of Arizona
- [N8073H](https://openairdocs.org/deregistered/N8073H-1977-07-21.md): Beech AT-7 · S/N 4260 · Cancelled Jul 21, 1977 · Barkley J F
- [N4970V](https://openairdocs.org/deregistered/N4970V-1971-01-07.md): Cessna T-50 · S/N 5923 · Cancelled Jan 7, 1971 · Barkley James F
- [N57866](https://openairdocs.org/deregistered/N57866-1956-02-14.md): Fairchild M-62A · S/N T41-1068 · Cancelled Feb 14, 1956 · Carter Harold G
- [N1014A](https://openairdocs.org/deregistered/N1014A-1954-02-03.md): Piper PA-18 · S/N 18-583 · Cancelled Feb 3, 1954 · Exported to Mexico · Crowe Ralph A
- [N48468](https://openairdocs.org/deregistered/N48468-1951-05-03.md): Aeronca 0-58B · S/N 058B-3552 · Cancelled May 3, 1951 · Exported to Mexico · Deverse James
- [N88645](https://openairdocs.org/deregistered/N88645-1949-04-08.md): Piper J3C-65 · S/N 16274 · Cancelled Apr 8, 1949 · Sturdys Flying School
- [N33489](https://openairdocs.org/deregistered/N33489-1948-08-20.md): Piper J3C-65 · S/N 5998 · Cancelled Aug 20, 1948 · Harold G Carter
- [N88130](https://openairdocs.org/deregistered/N88130-1947-10-07.md): Piper J3C-65 · S/N 15747 · Cancelled Oct 7, 1947 · Sturdys Flying School

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

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