# Cancelled registrations: Syracuse, KS

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

Cancelled aircraft registrations in Syracuse, KS.

- [N86861](https://openairdocs.org/deregistered/N86861-2023-09-06.md): Bellanca 14-13-2 · S/N 1223 · Cancelled Sep 6, 2023 · Built 1946 · Gerard Donald J
- [N124FS](https://openairdocs.org/deregistered/N124FS-2018-03-09.md): Yakovlev YAK 52 · S/N 811614 · Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1981 · Englert Anthony L
- [N6424Z](https://openairdocs.org/deregistered/N6424Z-2017-05-15.md): Piper PA-25 · S/N 25-573 · Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1961 · Dikeman Darrel G
- [N6882Z](https://openairdocs.org/deregistered/N6882Z-2013-05-02.md): Piper PA-25-235 · S/N 25-2607 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1964 · Finkenbinder M Irene Trustee
- [N2289F](https://openairdocs.org/deregistered/N2289F-2012-12-07.md): Riley Edward J HUMMINGBIRD-PROSPECT · S/N 115 · Cancelled Dec 7, 2012 · Sale reported, pending cancellation · Built 1982
- [N101LT](https://openairdocs.org/deregistered/N101LT-2005-06-08.md): Piper AEROSTAR 601P · S/N 61P07608063377 · Cancelled Jun 8, 2005 · Triennial form not returned · Built 1980 · Columbine Farm LLC
- [N2983J](https://openairdocs.org/deregistered/N2983J-1973-10-18.md): Cessna 150G · S/N 15065783 · Cancelled Oct 18, 1973 · Syracuse Flying Club Inc
- [N59779](https://openairdocs.org/deregistered/N59779-1970-12-15.md): Boeing A75N1 · S/N 75-3161 · Cancelled Dec 15, 1970 · Built 1942 · Syracuse Flying Service
- [N85055](https://openairdocs.org/deregistered/N85055-1955-05-23.md): Aeronca 7AC · S/N 7AC-3782 · Cancelled May 23, 1955 · Robert W Burton/Or Ralph A Eyer
- [N73591](https://openairdocs.org/deregistered/N73591-1952-01-14.md): Consolidated Vultee BT-13A · S/N 11290 · Cancelled Jan 14, 1952 · Cheatum Lyle
- [N54691](https://openairdocs.org/deregistered/N54691-1951-07-24.md): North American AT-6B · S/N 84-7495 · Cancelled Jul 24, 1951 · Dikeman Darrell Gene
- [N4821N](https://openairdocs.org/deregistered/N4821N-1951-03-27.md): North American P-51C · S/N 42-103663 · Cancelled Mar 27, 1951 · Exported to Dominican Republic · Built 1944 · Dikeman Darrel G
- [N33862](https://openairdocs.org/deregistered/N33862-1948-11-24.md): Aeronca 65-CA · S/N CA-14171 · Cancelled Nov 24, 1948 · Ralph A Eyer
- [N48293](https://openairdocs.org/deregistered/N48293-1948-10-29.md): Aeronca L-3B · S/N 058B-5052 · Cancelled Oct 29, 1948 · Built 1942 · Allison & Lalicker Flying Service
- [N32115](https://openairdocs.org/deregistered/N32115-1948-09-21.md): Waco UPF-7 · S/N 5747 · Cancelled Sep 21, 1948 · Dikeman Darrel Gene
- [N579M](https://openairdocs.org/deregistered/N579M-1939-06-01.md): Lincoln LINCOLN PAGE 3 · S/N 1002 · Cancelled Jun 1, 1939 · Raymond Clarke
- [N8764](https://openairdocs.org/deregistered/N8764-1937-09-15.md): Swallow TP · S/N 164 · Cancelled Sep 15, 1937 · Kramer Norman

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

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