# Cancelled registrations: Roosevelt, UT

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

Cancelled aircraft registrations in Roosevelt, UT.

- [N1654Q](https://openairdocs.org/deregistered/N1654Q-2022-07-02.md): Cessna 150L · S/N 15072954 · Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1971 · Swain Bensen
- [N123SK](https://openairdocs.org/deregistered/N123SK-2019-11-01.md): Beech C90 · S/N LJ-540 · Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Day Air LLC
- [N5270T](https://openairdocs.org/deregistered/N5270T-2019-09-06.md): Piper PA-28R-200 · S/N 28R-7235211 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1972 · Basin Aviation LLC
- [N3RS](https://openairdocs.org/deregistered/N3RS-2018-06-08.md): Beech 58P · S/N TJ-102 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1977 · King Well Service
- [N94583](https://openairdocs.org/deregistered/N94583-2018-01-24.md): Cessna 152 · S/N 15285737 · Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1983 · Betts Lynn M
- [N1843X](https://openairdocs.org/deregistered/N1843X-2018-01-03.md): Cessna 182H · S/N 18255943 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1964 · Bromley Donald C
- [N14797](https://openairdocs.org/deregistered/N14797-2018-01-02.md): Bellanca 17-31ATC · S/N 74-31078 · Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1973 · Gregory G Page Dds Pc
- [N89TS](https://openairdocs.org/deregistered/N89TS-2017-09-08.md): Boender David C KOLB TWINSTAR · S/N 89TS · Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Boender David C
- [N5485R](https://openairdocs.org/deregistered/N5485R-2017-02-17.md): Cessna A185F · S/N 18503038 · Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1976 · Krissman Robert R
- [N8537F](https://openairdocs.org/deregistered/N8537F-2014-11-24.md): Bell 47G-3B-1 · S/N 3390 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1965 · Leon Ross Rental & Investment
- [N120F](https://openairdocs.org/deregistered/N120F-2013-08-05.md): Beech 95-B55 (T42A) · S/N TC-684 · Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1964 · Leon Ross Drilling And Const Inc
- [N85876](https://openairdocs.org/deregistered/N85876-2013-06-27.md): Cessna T337D · S/N 337-1006 · Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1969 · Hancock Michael DBA
- [N9561Z](https://openairdocs.org/deregistered/N9561Z-2013-03-20.md): Beech C-45H · S/N AF-32 · Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1951
- [N8532F](https://openairdocs.org/deregistered/N8532F-2013-03-07.md): Bell 47G-3B · S/N 2790 · Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1965
- [N4728Z](https://openairdocs.org/deregistered/N4728Z-2012-11-27.md): Piper PA-22-108 · S/N 22-8274 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1961
- [N969JP](https://openairdocs.org/deregistered/N969JP-2004-07-26.md): Percival Jared VERI EZE · S/N JSP-01 · Cancelled Jul 26, 2004 · Triennial form not returned · Percival Jared S
- [N3978D](https://openairdocs.org/deregistered/N3978D-1971-01-15.md): Cessna 182A · S/N 34678 · Cancelled Jan 15, 1971 · Roosevelt Flyers Inc
- [N3638H](https://openairdocs.org/deregistered/N3638H-1951-04-25.md): Engineering & Research 415-CD · S/N 4263 · Cancelled Apr 25, 1951 · Built 1947 · Roosevelt Flying Service Inc

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

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