# Cancelled registrations: Lamar, CO

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

Cancelled aircraft registrations in Lamar, CO.

- [N846DM](https://openairdocs.org/deregistered/N846DM-2021-12-23.md): Air Tractor AT-502 · S/N 502-0035 · Cancelled Dec 23, 2021 · Third renewal notice · Built 1988 · Air Care Inc
- [N4557J](https://openairdocs.org/deregistered/N4557J-2021-07-31.md): Piper PA-28R-180 · S/N 28R-30417 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1968 · Telfer Roe S
- [N3205M](https://openairdocs.org/deregistered/N3205M-2020-03-25.md): Yakovlev YAK 52 · S/N 855306 · Cancelled Mar 25, 2020 · Expired dealer · Built 1985 · Air Care Systems Inc
- [N8319Y](https://openairdocs.org/deregistered/N8319Y-2019-12-02.md): Piper PA-30 · S/N 30-1459 · Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Yoon Paul C
- [N8870Q](https://openairdocs.org/deregistered/N8870Q-2018-06-04.md): Aero Commander S2R · S/N 1470R · Cancelled Jun 4, 2018 · First renewal notice · Built 1969 · Air Care Leasing LLC
- [N201VA](https://openairdocs.org/deregistered/N201VA-2018-03-20.md): Mooney M20J · S/N 24-0299 · Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1977 · Woller Don L DBA
- [N75GS](https://openairdocs.org/deregistered/N75GS-2016-03-01.md): Rockwell International S-2R · S/N 5038R · Cancelled Mar 1, 2016 · Second renewal notice · Air Care Leasing LLC
- [N4996B](https://openairdocs.org/deregistered/N4996B-2014-10-14.md): Beech C-45H · S/N AF-67 · Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Leatherman Darrell
- [N94RM](https://openairdocs.org/deregistered/N94RM-2013-06-05.md): Morris Ray O PITTS S-1C · S/N 2 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1975 · Mcaskill Jeffery W
- [N735AT](https://openairdocs.org/deregistered/N735AT-2009-08-13.md): Cessna 182Q · S/N 18265277 · Cancelled Aug 13, 2009 · Exported to Canada · Built 1976
- [N230SB](https://openairdocs.org/deregistered/N230SB-2008-01-16.md): Strissel Dale R PITTS S1S 1979 · S/N 7-0422 · Cancelled Jan 16, 2008 · Second triennial mailing, no response · Built 1982 · Lyddon Steven R
- [N3153Y](https://openairdocs.org/deregistered/N3153Y-2007-05-30.md): Yakovlev YAK 52 · S/N 855006 · Cancelled May 30, 2007 · Exported to Norway · Air Care Systems Inc
- [N8606L](https://openairdocs.org/deregistered/N8606L-1996-02-12.md): Piper PA-25-260 · S/N 255032 · Cancelled Feb 12, 1996 · Exported to Mexico · Tinnes Allen H
- [N35973](https://openairdocs.org/deregistered/N35973-1991-06-29.md): Cessna TU206F · S/N U20602841 · Cancelled Jun 29, 1991 · Triennial form not returned · Lyddon Flying Service Inc
- [N7606Z](https://openairdocs.org/deregistered/N7606Z-1986-09-10.md): Piper PA-25-235 · S/N 25-3703 · Cancelled Sep 10, 1986 · Tinnes Allen H
- [N417DR](https://openairdocs.org/deregistered/N417DR-1980-07-02.md): Cessna 411A · S/N 4110265 · Cancelled Jul 2, 1980 · Built 1967 · Ferguson James E
- [N9705K](https://openairdocs.org/deregistered/N9705K-1977-03-25.md): Piper PA-32R-300 · S/N 32R-7680243 · Cancelled Mar 25, 1977 · Dexters Insurance Agency Inc
- [N6031L](https://openairdocs.org/deregistered/N6031L-1976-02-24.md): American AA-5 · S/N AA5-0131 · Cancelled Feb 24, 1976 · Exported to Canada · Civis James
- [N2068G](https://openairdocs.org/deregistered/N2068G-1974-08-15.md): Cessna 182A · S/N 51368 · Cancelled Aug 15, 1974 · Exported to Canada · Atkinson Construction Co
- [N6714E](https://openairdocs.org/deregistered/N6714E-1971-11-24.md): Cessna 175 · S/N 56214 · Cancelled Nov 24, 1971 · Eaton Dwain W
- [N2931V](https://openairdocs.org/deregistered/N2931V-1966-08-03.md): Beech 35 · S/N D315 · Cancelled Aug 3, 1966 · Built 1949 · Trumble William E
- [N88316](https://openairdocs.org/deregistered/N88316-1965-05-22.md): Piper J3C-65 · S/N 15934 · Cancelled May 22, 1965 · Val-Air Inc
- [N2263D](https://openairdocs.org/deregistered/N2263D-1965-04-16.md): Cessna 170B · S/N 20415 · Cancelled Apr 16, 1965 · Myers Motor Sales
- [N78269](https://openairdocs.org/deregistered/N78269-1955-10-12.md): Globe GC-1B · S/N 2269 · Cancelled Oct 12, 1955 · Bugg Robert M
- [N53038](https://openairdocs.org/deregistered/N53038-1951-10-26.md): Boeing A75N1 · S/N 75-2214 · Cancelled Oct 26, 1951 · Exported to Mexico · Built 1945 · Val Air Inc
- [N73738](https://openairdocs.org/deregistered/N73738-1951-10-26.md): Boeing B75N1 · S/N 75-6889 · Cancelled Oct 26, 1951 · Val-Air Inc
- [N2945](https://openairdocs.org/deregistered/N2945-1935-10-01.md): Eaglerock LONG WING EAGLEROCK · S/N 179 · Cancelled Oct 1, 1935 · Hatchett Roy K

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

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