# Cancelled registrations: John Day, OR

A list on [John Day, OR](https://openairdocs.org/faa-place/OR/John%20Day.md).

Cancelled aircraft registrations in John Day, OR.

- [N8213](https://openairdocs.org/deregistered/N8213-2023-05-20.md): Cameron Copter B · S/N CC-001 · Cancelled May 20, 2023 · Revoked, canceled · Cameron Copter Corporation
- [N31659](https://openairdocs.org/deregistered/N31659-2023-04-01.md): Quicksilver SPORT II MXL · S/N 197 · Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1991 · Lundbom Ronald D
- [N1546B](https://openairdocs.org/deregistered/N1546B-2022-04-02.md): Luscombe 8F · S/N 6173 · Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Born Chester
- [N23279](https://openairdocs.org/deregistered/N23279-2021-12-04.md): Piper J3C-65 · S/N 3035 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1939 · Keeton James E
- [N5902V](https://openairdocs.org/deregistered/N5902V-2021-02-26.md): Beech A35 · S/N D-1858 · Cancelled Feb 26, 2021 · Registration expired, pending cancellation · Carpenter Storm E
- [N39426](https://openairdocs.org/deregistered/N39426-2018-07-03.md): Feiger David L KR-2 · S/N 122336 · Cancelled Jul 3, 2018 · Second renewal notice · Built 1984 · Feiger David L
- [N4769V](https://openairdocs.org/deregistered/N4769V-2012-08-06.md): Boeing E75 · S/N 75-5552 · Cancelled Aug 6, 2012 · Revoked, canceled · Built 1951 · Watkins Denis W
- [N8593G](https://openairdocs.org/deregistered/N8593G-2012-07-24.md): Cessna 150F · S/N 15062693 · Cancelled Jul 24, 2012 · Registration pending, canceled · Built 1965
- [N8098J](https://openairdocs.org/deregistered/N8098J-2004-04-30.md): Nanchang China CJ-6A · S/N 4032004 · Cancelled Apr 30, 2004 · Exported to Canada · Mansur Andy
- [N50499](https://openairdocs.org/deregistered/N50499-2001-05-04.md): Sherman Evan EXEC · S/N ES002 · Cancelled May 4, 2001 · Triennial form not returned · Sherman Evan J
- [N76167](https://openairdocs.org/deregistered/N76167-1981-11-23.md): Cessna 140 · S/N 10564 · Cancelled Nov 23, 1981 · Pike Victor A
- [N2406K](https://openairdocs.org/deregistered/N2406K-1958-10-10.md): Luscombe 8E · S/N 5133 · Cancelled Oct 10, 1958 · Exported to Canada · Lemberger Jack
- [N72985](https://openairdocs.org/deregistered/N72985-1955-04-18.md): Cessna 120 · S/N 10186 · Cancelled Apr 18, 1955 · John Day Flying Service
- [N39228](https://openairdocs.org/deregistered/N39228-1950-05-16-6482-8850316.md): Taylorcraft BC12-D · S/N 6482 · Cancelled May 16, 1950 · Built 1946 · Lemberger Jack
- [N39228](https://openairdocs.org/deregistered/N39228-1950-05-16-6482-8850317.md): Taylorcraft/Peterson BC12-D · S/N 6482 · Cancelled May 16, 1950 · Lemberger Jack
- [N94929](https://openairdocs.org/deregistered/N94929-1949-07-28.md): Taylorcraft BC12-D · S/N 9329 · Cancelled Jul 28, 1949 · Pereira Barney
- [N10651](https://openairdocs.org/deregistered/N10651-1948-04-08.md): Eyerly EYERLY COUPE · S/N 6 · Cancelled Apr 8, 1948 · Built 1932 · Lyons Jim

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

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