# Cancelled registrations: Jamestown, ND

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

Cancelled aircraft registrations in Jamestown, ND.

- [N6015W](https://openairdocs.org/deregistered/N6015W-2023-09-11.md): Air Tractor AT-401 · S/N 401-0947 · Cancelled Sep 11, 2023 · Built 1994 · Remmick Darwin R
- [N9542S](https://openairdocs.org/deregistered/N9542S-2018-08-10.md): Champion 7ECA · S/N 266 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1965 · Allen Lance
- [N6374Z](https://openairdocs.org/deregistered/N6374Z-2013-04-29.md): Piper PA-25 · S/N 25-493 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1961 · Richardson Mark
- [N3241U](https://openairdocs.org/deregistered/N3241U-2013-04-01.md): Didier Duwayne MITCHELL P-38 · S/N L-369 · Cancelled Apr 1, 2013 · Sale reported, canceled
- [N3623](https://openairdocs.org/deregistered/N3623-2012-09-18.md): Hasselfeldt BENSEN B-8 · S/N 471771 · Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1971
- [N7267R](https://openairdocs.org/deregistered/N7267R-2012-06-14.md): Cessna 182S · S/N 18280522 · Cancelled Jun 14, 2012 · Exported to Australia · Built 1999 · Baker Richard A
- [N56967](https://openairdocs.org/deregistered/N56967-2012-05-10.md): Piper PA-28-140 · S/N 28-7425072 · Cancelled May 10, 2012 · Exported to Canada · Built 1973 · Jamestown Aviation Inc
- [N9015S](https://openairdocs.org/deregistered/N9015S-2010-03-30.md): Weatherly 620B · S/N 1611 · Cancelled Mar 30, 2010 · Exported to Canada · Built 1996 · Central Ag Spraying Inc
- [N8139G](https://openairdocs.org/deregistered/N8139G-2000-12-07.md): Cessna A188B · S/N 18801246 · Cancelled Dec 7, 2000 · Exported to Brazil · Farm Air Service Inc
- [N654](https://openairdocs.org/deregistered/N654-2000-05-11.md): Mccarty Timothy G TAILWIND W-8 · S/N 269 · Cancelled May 11, 2000 · Triennial form not returned · Mccarty Timothy G
- [N9882K](https://openairdocs.org/deregistered/N9882K-1999-10-05.md): Piper PA-28R-201T · S/N 28R-7803075 · Cancelled Oct 5, 1999 · Triennial form not returned · Mastel Isadore
- [N9599P](https://openairdocs.org/deregistered/N9599P-1994-08-24.md): Piper PA-25-235 · S/N 257656006 · Cancelled Aug 24, 1994 · Administratively canceled · Sprayers Inc
- [N8625L](https://openairdocs.org/deregistered/N8625L-1994-05-19.md): Piper PA-25-235 · S/N 255056 · Cancelled May 19, 1994 · Exported to Uruguay · Jamestown Aviation Inc
- [N6011F](https://openairdocs.org/deregistered/N6011F-1985-09-18.md): Cessna 182P · S/N 18264062 · Cancelled Sep 18, 1985 · Jamestown Aviation Inc
- [N6647L](https://openairdocs.org/deregistered/N6647L-1982-12-30.md): Piper PA-31-310 · S/N 31-586 · Cancelled Dec 30, 1982 · Exported to Canada · Jamestown Aviation Inc
- [N4831Y](https://openairdocs.org/deregistered/N4831Y-1982-04-29.md): Piper PA-25-260 · S/N 25-4624 · Cancelled Apr 29, 1982 · Exported to Canada · Sprayers Inc
- [N900GB](https://openairdocs.org/deregistered/N900GB-1978-08-09.md): Piper PA-31-310 · S/N 31-7401231 · Cancelled Aug 9, 1978 · Exported to Canada · Jamestown Aviation Inc
- [N537J](https://openairdocs.org/deregistered/N537J-1978-06-01.md): Piper PA-31 · S/N 317401268 · Cancelled Jun 1, 1978 · Exported to Canada · Jamestown Aviation Inc
- [N4120Y](https://openairdocs.org/deregistered/N4120Y-1978-04-03.md): Bellanca 7GCBC · S/N 949-76 · Cancelled Apr 3, 1978 · Exported to Canada · Built 1976 · Jamestown Aviation Inc
- [N138ND](https://openairdocs.org/deregistered/N138ND-1976-02-25.md): Cessna U206B · S/N U206-0911 · Cancelled Feb 25, 1976 · Jamestown Aviation Inc
- [N4449Y](https://openairdocs.org/deregistered/N4449Y-1973-07-19.md): Piper PA-25-235 · S/N 25-4092 · Cancelled Jul 19, 1973 · Exported to Canada · Built 1966 · Jamestown Aviation Inc
- [N5243Q](https://openairdocs.org/deregistered/N5243Q-1973-04-27.md): Cessna 150L · S/N 15073143 · Cancelled Apr 27, 1973 · Built 1972 · Comet Aviation Inc
- [N2570U](https://openairdocs.org/deregistered/N2570U-1973-03-02.md): Cessna 172D · S/N 17250170 · Cancelled Mar 2, 1973 · Exported to Canada · Comet Aviation Inc
- [N82279](https://openairdocs.org/deregistered/N82279-1970-12-31.md): Aeronca 7AC · S/N 7AC-908 · Cancelled Dec 31, 1970 · Trautman Paul A
- [N70107](https://openairdocs.org/deregistered/N70107-1970-07-14.md): Piper J3C-65 · S/N 17081 · Cancelled Jul 14, 1970 · Jamestown Aviation Inc
- [N7441Z](https://openairdocs.org/deregistered/N7441Z-1970-07-14.md): Piper PA-25-235 · S/N 25-3431 · Cancelled Jul 14, 1970 · Jamestown Aviation Inc
- [N8307Z](https://openairdocs.org/deregistered/N8307Z-1970-07-14.md): Cessna 210-5(205) · S/N 205-0307 · Cancelled Jul 14, 1970 · Jamestown Flying Inc
- [N5376S](https://openairdocs.org/deregistered/N5376S-1970-06-23.md): Cessna 337A · S/N 337-0476 · Cancelled Jun 23, 1970 · North Central Enginers
- [N7900B](https://openairdocs.org/deregistered/N7900B-1970-05-11.md): Cessna 172 · S/N 29700 · Cancelled May 11, 1970 · Exported to Canada · Simmers Francis H
- [N2499U](https://openairdocs.org/deregistered/N2499U-1968-01-12.md): Cessna 172D · S/N 17250099 · Cancelled Jan 12, 1968 · Exported to Canada · Sheetz E L
- [N40183](https://openairdocs.org/deregistered/N40183-1960-09-21.md): Stinson 108 · S/N 108-113 · Cancelled Sep 21, 1960 · Built 1946 · Walsh Walter J
- [N76792](https://openairdocs.org/deregistered/N76792-1956-01-26.md): Cessna 140 · S/N 11224 · Cancelled Jan 26, 1956 · Exported to Canada · Smith Flying Service
- [N18769](https://openairdocs.org/deregistered/N18769-1948-05-04.md): Commonwealth REARWIN 9000-L · S/N 575D · Cancelled May 4, 1948 · Sandberg William
- [N661](https://openairdocs.org/deregistered/N661-1935-03-01.md): Standard STANDARD J-1 · S/N 104 · Cancelled Mar 1, 1935 · Wehler John
- [N1306](https://openairdocs.org/deregistered/N1306-undated.md): National Airways System AIR KING · S/N 115 · Cancellation date not recorded · Buttles George A

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

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