# Cancelled registrations: Dickinson, ND

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

Cancelled aircraft registrations in Dickinson, ND.

- [N4NL](https://openairdocs.org/deregistered/N4NL-2022-07-02.md): Temco D-16A · S/N TTN-67 · Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1947 · Wild Blue Yonder LLC
- [N6013W](https://openairdocs.org/deregistered/N6013W-2022-07-02.md): Piper PA-28-150 · S/N 28-20013 · Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1964 · Wild Blue Yonder LLC
- [N701PH](https://openairdocs.org/deregistered/N701PH-2021-09-04.md): Halstead David SPORTSMAN 2+2 · S/N 154 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1991 · Halstead David G
- [N65216](https://openairdocs.org/deregistered/N65216-2020-10-03.md): Powrachute PEGASUS · S/N A 358 PEG · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2005 · Stenehjem Jerome R
- [N4040M](https://openairdocs.org/deregistered/N4040M-2020-01-31.md): Piper PA-12 · S/N 12-2923 · Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1947 · Chandler Gabriel R
- [N5860S](https://openairdocs.org/deregistered/N5860S-2019-11-07.md): Sensefly EBEE · S/N EB-03-06670 · Cancelled Nov 7, 2019 · Registration expired, pending cancellation · Fisher Sand & Gravel Co
- [N586PH](https://openairdocs.org/deregistered/N586PH-2019-11-07.md): DJI PHANTOM 2 · S/N PH645235907 · Cancelled Nov 7, 2019 · Registration expired, pending cancellation · Fisher Sand & Gravel Co
- [N6041W](https://openairdocs.org/deregistered/N6041W-2018-03-14.md): Piper PA-28-140 · S/N 28-20041 · Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1964 · Reinholdt Joshua D
- [N71NB](https://openairdocs.org/deregistered/N71NB-2014-12-10.md): Piper PA 46-350P · S/N 4636252 · Cancelled Dec 10, 2014 · Exported to Canada · Built 2000 · Brannin Operating LLC
- [N7275B](https://openairdocs.org/deregistered/N7275B-2014-11-17.md): Beech J35 · S/N D-5624 · Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1958 · Baird Audrey L
- [N7064D](https://openairdocs.org/deregistered/N7064D-1986-05-22.md): Piper PA-18-150 · S/N 18-5602 · Cancelled May 22, 1986 · Thompson Ellis E
- [N3595X](https://openairdocs.org/deregistered/N3595X-1977-08-31.md): Mooney M-20G · S/N 680164 · Cancelled Aug 31, 1977 · Exported to Canada · Built 1968 · Diamond Equipment Inc
- [N84887](https://openairdocs.org/deregistered/N84887-1973-02-16.md): Cessna 172K · S/N 17258654 · Cancelled Feb 16, 1973 · Prchal Richard
- [N8994A](https://openairdocs.org/deregistered/N8994A-1971-08-19.md): Beech D18S · S/N A-581 · Cancelled Aug 19, 1971 · Meyer Construction Co
- [N3778J](https://openairdocs.org/deregistered/N3778J-1971-03-24.md): Cessna 150G · S/N 15065078 · Cancelled Mar 24, 1971 · Prchal Richard DBA Dickinson Air Service
- [N7264V](https://openairdocs.org/deregistered/N7264V-1971-02-05.md): Callair A-9 · S/N 1316 · Cancelled Feb 5, 1971 · Naumann Robert
- [N2498A](https://openairdocs.org/deregistered/N2498A-1962-07-06.md): Piper PA-18A · S/N 18-1968 · Cancelled Jul 6, 1962 · Oleson Todd R J
- [N2343K](https://openairdocs.org/deregistered/N2343K-1962-01-11.md): Luscombe 8A · S/N 5070 · Cancelled Jan 11, 1962 · Dickinson Aviation Co Inc
- [N50198](https://openairdocs.org/deregistered/N50198-1955-11-28.md): Consolidated Vultee BT-13A · S/N 3140 · Cancelled Nov 28, 1955 · Sax Aviation Company
- [N4170V](https://openairdocs.org/deregistered/N4170V-1950-07-12.md): Cessna 170 · S/N 18503 · Cancelled Jul 12, 1950 · Exported to Canada · Sax Aviation Co
- [N36590](https://openairdocs.org/deregistered/N36590-1948-08-31.md): Aeronca 65-TAL · S/N L1021TA · Cancelled Aug 31, 1948 · Built 1941 · Worth Air Service
- [N36657](https://openairdocs.org/deregistered/N36657-1948-08-31.md): Aeronca 65-TAL · S/N L1341TA · Cancelled Aug 31, 1948 · Built 1941 · Worth Air Service

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

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