# Cancelled registrations: Valley City, ND

A list on [Valley City, ND](https://openairdocs.org/faa-place/ND/Valley%20City.md).

Cancelled aircraft registrations in Valley City, ND.

- [N9462E](https://openairdocs.org/deregistered/N9462E-2013-05-23.md): Aeronca 11AC · S/N 11AC-1100 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Anderson Rick L
- [N8GK](https://openairdocs.org/deregistered/N8GK-2012-12-11.md): Kesel Greg S1S · S/N 7-0356 · Cancelled Dec 11, 2012 · Exported to Australia · Built 1985 · North Valley Aircraft Inc
- [N3530Q](https://openairdocs.org/deregistered/N3530Q-2012-10-04.md): Cessna A188 · S/N 188-0480 · Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1969 · Sinness Lon E
- [N8298Q](https://openairdocs.org/deregistered/N8298Q-1992-09-16.md): Cessna U206F · S/N U20603159 · Cancelled Sep 16, 1992 · Exported to Tanzania · General Air Service Inc
- [N98547](https://openairdocs.org/deregistered/N98547-1981-10-15.md): Cessna 340A · S/N 340A0027 · Cancelled Oct 15, 1981 · Bjornson Paul J DBA Bjornson Development Co
- [N649C](https://openairdocs.org/deregistered/N649C-1974-05-20.md): Stinson 108-3 · S/N 108-3649 · Cancelled May 20, 1974 · Exported to Canada · Starke Anthony F
- [N7669Z](https://openairdocs.org/deregistered/N7669Z-1973-07-23.md): Piper PA-25-235 · S/N 25-3814 · Cancelled Jul 23, 1973 · Exported to Canada · All Air Serv Inc
- [N7834F](https://openairdocs.org/deregistered/N7834F-1973-04-16.md): Cessna 150F · S/N 15063934 · Cancelled Apr 16, 1973 · Exported to Canada · All Air Service Inc
- [N79171](https://openairdocs.org/deregistered/N79171-1970-09-03.md): Fairchild M-62A-3 · S/N FV114 · Cancelled Sep 3, 1970 · Peterson L V And Cink Ed
- [N95655](https://openairdocs.org/deregistered/N95655-1961-10-05.md): Taylorcraft BC12-D · S/N 7955 · Cancelled Oct 5, 1961 · Exported to Canada · Koppi Michael
- [N4171V](https://openairdocs.org/deregistered/N4171V-1960-05-25.md): Cessna 170 · S/N 18504 · Cancelled May 25, 1960 · Zwick William C
- [N97855](https://openairdocs.org/deregistered/N97855-1960-01-14.md): Stinson 108-1 · S/N 108-855 · Cancelled Jan 14, 1960 · Exported to Canada · Sms Flying Club
- [N4976H](https://openairdocs.org/deregistered/N4976H-1958-09-11.md): Piper PA-11 · S/N 11-856 · Cancelled Sep 11, 1958 · Cink Edwin
- [N87775](https://openairdocs.org/deregistered/N87775-1958-07-22.md): Piper J3C-65 · S/N 15433 · Cancelled Jul 22, 1958 · Exported to Canada · Built 1946 · Bruns Douglas
- [N50191](https://openairdocs.org/deregistered/N50191-1955-11-28.md): Fairchild M-62A · S/N T41766 · Cancelled Nov 28, 1955 · Jacobson Allen John
- [N33833](https://openairdocs.org/deregistered/N33833-1952-06-02.md): Aeronca 65-LB · S/N LB13791 · Cancelled Jun 2, 1952 · Carlton R Lee
- [N4471E](https://openairdocs.org/deregistered/N4471E-1950-09-08.md): Aeronca 7DC · S/N 7DC95 · Cancelled Sep 8, 1950 · Elliott Bernice N

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

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