# Cancelled registrations: Hettinger, ND

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

Cancelled aircraft registrations in Hettinger, ND.

- [N2027K](https://openairdocs.org/deregistered/N2027K-2018-01-03.md): Weatherly 620B · S/N 1577 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1994 · Air Dakota Flite Inc
- [N1614X](https://openairdocs.org/deregistered/N1614X-1996-03-04.md): Cessna 210L · S/N 21060650 · Cancelled Mar 4, 1996 · Exported to Namibia · Stippich Laverne
- [N51132](https://openairdocs.org/deregistered/N51132-1981-06-12.md): Boeing PT-17 · S/N 752248 · Cancelled Jun 12, 1981 · Exported to United Kingdom · Lindquist Jay B
- [N9439V](https://openairdocs.org/deregistered/N9439V-1980-01-16.md): Mooney M20C · S/N 700048 · Cancelled Jan 16, 1980 · Kirschman John
- [N5411R](https://openairdocs.org/deregistered/N5411R-1977-04-25.md): Cessna 172F · S/N 17252951 · Cancelled Apr 25, 1977 · Exported to Canada · Lindquist Jay B
- [N7206V](https://openairdocs.org/deregistered/N7206V-1976-05-27.md): Intermountain CALLAIR A-9 · S/N 1241 · Cancelled May 27, 1976 · Lindquist Jay B
- [N2903E](https://openairdocs.org/deregistered/N2903E-1971-08-13.md): Aeronca 7AC · S/N 7AC-6486 · Cancelled Aug 13, 1971 · Howard J Alexander
- [N2499A](https://openairdocs.org/deregistered/N2499A-1970-12-31.md): Piper PA-18-135 · S/N 18-1966 · Cancelled Dec 31, 1970 · Erdmann Armond O /Erdmann Cynthia M
- [N1649E](https://openairdocs.org/deregistered/N1649E-1970-11-19.md): Aeronca 7BCM · S/N 7AC-5214 · Cancelled Nov 19, 1970 · Exported to Canada · Built 1946 · Bartz Robert A
- [N86852](https://openairdocs.org/deregistered/N86852-1965-06-03.md): Bellanca 14-13 · S/N 1214 · Cancelled Jun 3, 1965 · Galbreth C G
- [N1964C](https://openairdocs.org/deregistered/N1964C-1965-06-02.md): Cessna 170B · S/N 26109 · Cancelled Jun 2, 1965 · Halvorson Richard D
- [N5930B](https://openairdocs.org/deregistered/N5930B-1965-05-20.md): Cessna 182A · S/N 33930 · Cancelled May 20, 1965 · Clark R S
- [N1134N](https://openairdocs.org/deregistered/N1134N-1961-11-27.md): Cessna T-50 · S/N 1478 · Cancelled Nov 27, 1961 · Stevens Thomas B
- [N38864](https://openairdocs.org/deregistered/N38864-1961-11-27.md): Piper J5B · S/N 5-1098 · Cancelled Nov 27, 1961 · Built 1941 · Ullman Jay
- [N5201M](https://openairdocs.org/deregistered/N5201M-1961-07-18.md): Taylorcraft BC12-D · S/N 10501 · Cancelled Jul 18, 1961 · Exported to Canada · Built 1947 · Erdmann Armond O/Erdmann Cynthia M
- [N50196](https://openairdocs.org/deregistered/N50196-1953-11-16.md): Consolidated Vultee BT-13A · S/N 9304 · Cancelled Nov 16, 1953 · Stevens Thomas B

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

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