# Cancelled registrations: Apache Junction, AZ

A list on [Apache Junction, AZ](https://openairdocs.org/faa-place/AZ/Apache%20Junction.md).

Cancelled aircraft registrations in Apache Junction, AZ.

- [N869Y](https://openairdocs.org/deregistered/N869Y-2021-07-31.md): Ray Young 4S · S/N 001 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Young Ray
- [N22994](https://openairdocs.org/deregistered/N22994-2021-07-03.md): Piper J3C-65 · S/N 3880 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Nyberg Carl
- [N667UC](https://openairdocs.org/deregistered/N667UC-2019-09-06.md): Sensefly EBEE · S/N ER-01-23806 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Blount Contracting Inc
- [N9798L](https://openairdocs.org/deregistered/N9798L-2018-08-23.md): Beech A24R · S/N MC-117 · Cancelled Aug 23, 2018 · Sale reported, canceled · Built 1972
- [N9497A](https://openairdocs.org/deregistered/N9497A-2018-06-04.md): Cessna 140A · S/N 15318 · Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1949
- [N3533L](https://openairdocs.org/deregistered/N3533L-2018-02-13.md): Marshall Jerome G GEO · S/N 37266 · Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 2002 · Marshall Jerome G
- [N97706](https://openairdocs.org/deregistered/N97706-2018-01-17.md): Stinson 108 · S/N 108706 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1946 · Thillmony Brad Dean
- [N1004K](https://openairdocs.org/deregistered/N1004K-2013-07-08.md): Kelly Kelvin L KR-100 · S/N 100-1 · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1987 · Pearce Douglas A
- [N5827A](https://openairdocs.org/deregistered/N5827A-2013-06-12.md): Schnobrich Robert BENSEN B-8M · S/N 1 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Schnoberich Robert A
- [N688S](https://openairdocs.org/deregistered/N688S-2013-06-11.md): Maurer Christopher L SNS-8 HYPERLIGHT · S/N 44 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1984 · Maurer Christopher L
- [N712KD](https://openairdocs.org/deregistered/N712KD-2013-05-02.md): Free Bird Innovations FREEBIRD CLASSIS/SS · S/N RDKD-001 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Donaldson Robert A
- [N6769](https://openairdocs.org/deregistered/N6769-2008-08-06.md): Thomas John BAKENG DUCE · S/N 157 · Cancelled Aug 6, 2008 · Exported to Canada · Built 1974 · Thillmony Brad D
- [N43597](https://openairdocs.org/deregistered/N43597-1998-01-16.md): Taylorcraft BC12-D1 · S/N 7256 · Cancelled Jan 16, 1998 · Triennial form not returned · Robertson Aleck D Trustee
- [N3431E](https://openairdocs.org/deregistered/N3431E-1991-05-10.md): Cessna 172N · S/N 17271546 · Cancelled May 10, 1991 · Triennial form not returned · Losey Howard D
- [N3154L](https://openairdocs.org/deregistered/N3154L-1983-10-06.md): Cessna 310J · S/N 310J0154 · Cancelled Oct 6, 1983 · Burton J W
- [N6592X](https://openairdocs.org/deregistered/N6592X-1981-07-29.md): Cessna 210A · S/N 210-57592 · Cancelled Jul 29, 1981 · Exported to Canada · Waltham Robert M

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

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