# Cancelled registrations: Jerome, ID

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

Cancelled aircraft registrations in Jerome, ID.

- [N6197W](https://openairdocs.org/deregistered/N6197W-2021-06-22.md): Cessna P210N · S/N P21000728 · Cancelled Jun 22, 2021 · Exported to Canada · Built 1981 · Caribou Inc
- [N902PM](https://openairdocs.org/deregistered/N902PM-2020-02-28.md): P&M QUIK · S/N 8664 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2013 · Callen Gregory T
- [N151UX](https://openairdocs.org/deregistered/N151UX-2019-05-04.md): Trimble Navigation UX5 · S/N EBX00635 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Field Data Solutions Inc DBA
- [N3264D](https://openairdocs.org/deregistered/N3264D-2018-04-05.md): Cessna 180 · S/N 32062 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1955 · Wirthlin Rex D
- [N2644T](https://openairdocs.org/deregistered/N2644T-2018-01-12.md): Olsen Aaron SABRE 1 · S/N 122855 · Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1998 · Olsen Aaron
- [N8813J](https://openairdocs.org/deregistered/N8813J-2013-06-05.md): Eagle EAGLE DW-1 · S/N DW-1-0083-82 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1982 · Valley Flyers Inc DBA
- [N2808Y](https://openairdocs.org/deregistered/N2808Y-2007-05-22.md): Raven S-60A · S/N S60A-412 · Cancelled May 22, 2007 · Lee Marion L
- [N5853Q](https://openairdocs.org/deregistered/N5853Q-2000-10-03.md): Mooney M20E · S/N 792 · Cancelled Oct 3, 2000 · Appel John
- [N7583P](https://openairdocs.org/deregistered/N7583P-1998-11-09.md): Piper PA-24-250 · S/N 242794 · Cancelled Nov 9, 1998 · Triennial form not returned · Neace Ken
- [N7040Z](https://openairdocs.org/deregistered/N7040Z-1964-08-12.md): Piper PA-25-235 · S/N 252803 · Cancelled Aug 12, 1964 · Peterson Leon J DBA North Side Aero Service
- [N2048B](https://openairdocs.org/deregistered/N2048B-1955-06-20.md): Luscombe 8F · S/N 6475 · Cancelled Jun 20, 1955 · Exported to Canada · H J Scheid
- [N8671A](https://openairdocs.org/deregistered/N8671A-1954-05-26.md): Beech A35 · S/N D-2081 · Cancelled May 26, 1954 · Idaho Gas & Appliance Corp
- [N1962K](https://openairdocs.org/deregistered/N1962K-1953-11-17.md): Luscombe 8E · S/N 4689 · Cancelled Nov 17, 1953 · Exported to Canada · Built 1947 · Guy B Prunty & Son Inc
- [N17825](https://openairdocs.org/deregistered/N17825-1948-04-23.md): Taylor J-2 · S/N 1260 · Cancelled Apr 23, 1948 · Built 1937 · Bolyard Clifford C
- [N12514](https://openairdocs.org/deregistered/N12514-1947-10-03.md): Beazley Nicholas 8G · S/N K-52 · Cancelled Oct 3, 1947 · Elmer L Kennison
- [N12701](https://openairdocs.org/deregistered/N12701-1935-04-01.md): Tilby Jd/Tilby Bo/Vinyard He SECONDARY GLIDER · S/N A-2 · Cancelled Apr 1, 1935 · Built 1932 · Tilby J O/Tilby B O/Vinyard H 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 = 'ID' AND d.registrant_city = 'JEROME'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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