# Cancelled registrations: Bismark, ND

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

Cancelled aircraft registrations in Bismark, ND.

- [N54902](https://openairdocs.org/deregistered/N54902-2011-03-17.md): Piper PA-25-260 · S/N 25-7656046 · Cancelled Mar 17, 2011 · Expired dealer · Built 1976 · Commander Aviation Corp
- [N1070A](https://openairdocs.org/deregistered/N1070A-2009-06-25.md): Piper PA-18-125 · S/N 18-653 · Cancelled Jun 25, 2009 · Registration revoked · Built 1951 · Lahman Jake
- [N60207](https://openairdocs.org/deregistered/N60207-1979-06-25.md): Beech 77 · S/N WA-10 · Cancelled Jun 25, 1979 · Exported to Canada · Executive Air Taxi Corp
- [N9776T](https://openairdocs.org/deregistered/N9776T-1978-07-06.md): Piper PA-38-112 · S/N 38-78A0204 · Cancelled Jul 6, 1978 · Exported to Canada · Executive Air Taxi Corp
- [N5257L](https://openairdocs.org/deregistered/N5257L-1976-08-04.md): Piper PA-28-180 · S/N 284554W · Cancelled Aug 4, 1976 · Exported to Canada · Commander Aviation Corp
- [N64440](https://openairdocs.org/deregistered/N64440-1976-05-25.md): Cessna 172M · S/N 172-65228 · Cancelled May 25, 1976 · Exported to Canada · Commander Avia Corp
- [N8937P](https://openairdocs.org/deregistered/N8937P-1976-04-13.md): Piper PA-24-260 · S/N 244393 · Cancelled Apr 13, 1976 · Exported to Canada · Commander Aviation Corp
- [N185W](https://openairdocs.org/deregistered/N185W-1976-04-06.md): Cessna A185F · S/N 18502559 · Cancelled Apr 6, 1976 · Exported to Canada · Built 1974 · Commander Aviation Corp
- [N5898R](https://openairdocs.org/deregistered/N5898R-1976-01-12.md): Cessna 172G · S/N 17253567 · Cancelled Jan 12, 1976 · Exported to Canada · Commander Aviation Corp
- [N9658P](https://openairdocs.org/deregistered/N9658P-1975-05-13.md): Piper PA-18-150 · S/N 18-7509002 · Cancelled May 13, 1975 · Exported to Canada · Commander Aviation Corp
- [N4137J](https://openairdocs.org/deregistered/N4137J-1975-02-12.md): Piper PA-28-140 · S/N 28-22460 · Cancelled Feb 12, 1975 · Exported to Canada · Built 1966 · Commander Aviation Corp
- [N9694G](https://openairdocs.org/deregistered/N9694G-1975-02-05.md): Cessna 182P · S/N 18263432 · Cancelled Feb 5, 1975 · Exported to Canada · Commander Aviation
- [N5600J](https://openairdocs.org/deregistered/N5600J-1975-01-04.md): Cessna 182P · S/N 18263457 · Cancelled Jan 4, 1975 · Exported to Canada · Commander Aviation Corp
- [N92500](https://openairdocs.org/deregistered/N92500-1974-12-17.md): Cessna 182N · S/N 18260232 · Cancelled Dec 17, 1974 · Exported to Canada · Commander Aviation Corp
- [N7822N](https://openairdocs.org/deregistered/N7822N-1974-11-21.md): Piper PA-28 · S/N 285274 · Cancelled Nov 21, 1974 · Exported to Canada · Commander Aviation Corp
- [N3318U](https://openairdocs.org/deregistered/N3318U-1974-04-25.md): Cessna 182F · S/N 18254718 · Cancelled Apr 25, 1974 · Exported to Canada · Commander Aviation Corp
- [N9325J](https://openairdocs.org/deregistered/N9325J-1974-04-04.md): Piper PA-28-180 · S/N 28-3418 · Cancelled Apr 4, 1974 · Exported to Canada · Built 1966 · Commander Aviaiton Corp
- [N6042V](https://openairdocs.org/deregistered/N6042V-1974-02-15.md): Aeronca 7CCM · S/N 48-496 · Cancelled Feb 15, 1974 · Exported to Canada · Commander Aviation Corp
- [N384D](https://openairdocs.org/deregistered/N384D-1973-06-25.md): Beech 35-A33 · S/N CD-269 · Cancelled Jun 25, 1973 · Exported to Canada · Commander Aviation Corp
- [N6300Q](https://openairdocs.org/deregistered/N6300Q-1973-06-06.md): Mooney M20F · S/N 670393 · Cancelled Jun 6, 1973 · Exported to Canada · Commander Aviation Corp
- [N79441](https://openairdocs.org/deregistered/N79441-1972-07-27.md): Cessna 172K · S/N 172-58090 · Cancelled Jul 27, 1972 · Exported to Canada · Commander Aviation Corporation
- [N5644W](https://openairdocs.org/deregistered/N5644W-1972-04-27.md): Piper PA-28-180 · S/N 28-799 · Cancelled Apr 27, 1972 · Exported to Canada · Built 1966 · Mid State Aviation Inc
- [N3727V](https://openairdocs.org/deregistered/N3727V-1972-04-18.md): Cessna 140 · S/N 15004 · Cancelled Apr 18, 1972 · Exported to Canada · Daub Roger
- [N5673T](https://openairdocs.org/deregistered/N5673T-1972-01-14.md): Cessna 172E · S/N 17251573 · Cancelled Jan 14, 1972 · Exported to Canada · Mid State Aviation Inc
- [N8774P](https://openairdocs.org/deregistered/N8774P-1970-07-01.md): Piper PA-24-260 · S/N 24-4225 · Cancelled Jul 1, 1970 · Exported to Canada · Midstate Aviation Inc
- [N5761Z](https://openairdocs.org/deregistered/N5761Z-1969-05-20.md): Piper PA-22-108 · S/N 22-9603 · Cancelled May 20, 1969 · Exported to Canada · Mid State Aviation Inc
- [N7985W](https://openairdocs.org/deregistered/N7985W-1968-10-10.md): Piper PA-28-180 · S/N 28-2039 · Cancelled Oct 10, 1968 · Exported to Canada · Mid-State Aviation Inc
- [N4789D](https://openairdocs.org/deregistered/N4789D-1968-09-24.md): Cessna 182A · S/N 34889 · Cancelled Sep 24, 1968 · Exported to Canada · Mid State Aviation Inc
- [N6313R](https://openairdocs.org/deregistered/N6313R-1968-04-03.md): Piper PA-28-140 · S/N 28-21479 · Cancelled Apr 3, 1968 · Exported to Canada · Built 1966 · Mid State Aviation Inc
- [N2734X](https://openairdocs.org/deregistered/N2734X-1967-05-22.md): Cessna 180H · S/N 18051534 · Cancelled May 22, 1967 · Exported to Canada · Mid State Aviation Inc
- [N29687](https://openairdocs.org/deregistered/N29687-1962-09-17.md): Taylorcraft BC12-65 · S/N 2531 · Cancelled Sep 17, 1962 · Earl M Haakenson
- [N2233B](https://openairdocs.org/deregistered/N2233B-1954-10-28.md): Luscombe 8F · S/N 6660 · Cancelled Oct 28, 1954 · Exported to Canada · Hartman E E

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

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