# Cancelled registrations: Winfield, KS

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

Cancelled aircraft registrations in Winfield, KS.

- [N933HP](https://openairdocs.org/deregistered/N933HP-2022-10-27.md): Cirrus Design SF50 · S/N 0071 · Cancelled Oct 27, 2022 · Exported to Netherlands · Built 2018 · R & B Aviation LLC
- [N3123D](https://openairdocs.org/deregistered/N3123D-2022-02-05.md): Powrachute PC 2000 · S/N A274POW · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2002 · Beeman Gary A
- [N1970E](https://openairdocs.org/deregistered/N1970E-2018-02-07.md): Aeronca 7AC · S/N 7AC-5537 · Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1946 · Swan Christopher L
- [N1689B](https://openairdocs.org/deregistered/N1689B-2017-10-27.md): Temco Luscombe 11A · S/N 11-195 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1949 · Koller Derek G
- [N5404S](https://openairdocs.org/deregistered/N5404S-2015-04-30.md): Cessna 337A · S/N 337-0504 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1966 · Waymire Charles R
- [N62772](https://openairdocs.org/deregistered/N62772-2013-08-05.md): Boeing A75N1(PT17) · S/N 75645 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1940 · Winfield Air Svc
- [N89142](https://openairdocs.org/deregistered/N89142-2012-11-15.md): Cessna 152 · S/N 15282646 · Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1978
- [N8646L](https://openairdocs.org/deregistered/N8646L-1995-01-31.md): Raven Industries RX6 · S/N RX6151 · Cancelled Jan 31, 1995 · Triennial form not returned · Flottman Rex L
- [N47797](https://openairdocs.org/deregistered/N47797-1980-02-12.md): Cessna 152 · S/N 15283251 · Cancelled Feb 12, 1980 · Exported to Gabon · Built 1979 · Cessna Aircraft Company
- [N758KN](https://openairdocs.org/deregistered/N758KN-1980-02-12.md): Cessna R172K · S/N R1723158 · Cancelled Feb 12, 1980 · Exported to Pakistan · Cessna Aircraft Co
- [N7349L](https://openairdocs.org/deregistered/N7349L-1980-02-08.md): Cessna A152 · S/N A1520793 · Cancelled Feb 8, 1980 · Exported to Venezuela · Cessna Aircraft Co
- [N6200D](https://openairdocs.org/deregistered/N6200D-1979-08-03.md): Cessna 172N · S/N 17272630 · Cancelled Aug 3, 1979 · Exported to Canada · Cessna Aircraft Co
- [N7387L](https://openairdocs.org/deregistered/N7387L-1978-10-20.md): Cessna A152 · S/N A1520806 · Cancelled Oct 20, 1978 · Exported to South Africa · Cessna Acft Co
- [N11423](https://openairdocs.org/deregistered/N11423-1974-03-31.md): Cessna 150L · S/N 15075409 · Cancelled Mar 31, 1974 · Exported to Guatemala · Cessna Aircraft Co
- [N11404](https://openairdocs.org/deregistered/N11404-1973-12-12.md): Cessna 150L · S/N 15075393 · Cancelled Dec 12, 1973 · Exported to New Zealand · Cessna Aircraft Company
- [N9924G](https://openairdocs.org/deregistered/N9924G-1973-12-12.md): Cessna A150L · S/N A1500469 · Cancelled Dec 12, 1973 · Exported to New Zealand · Cessna Aircraft Co
- [N11232](https://openairdocs.org/deregistered/N11232-1973-11-14.md): Cessna 150L · S/N 15075267 · Cancelled Nov 14, 1973 · Exported to South Africa · Cessna Aircraft Company
- [N11385](https://openairdocs.org/deregistered/N11385-1973-11-14.md): Cessna 150L · S/N 15075374 · Cancelled Nov 14, 1973 · Exported to Australia · Cessna Aircraft Co
- [N9910G](https://openairdocs.org/deregistered/N9910G-1973-11-14.md): Cessna A150L · S/N A1500461 · Cancelled Nov 14, 1973 · Exported to Australia · Cessna Aircraft Co
- [N11194](https://openairdocs.org/deregistered/N11194-1973-10-23.md): Cessna 150L · S/N 5075248 · Cancelled Oct 23, 1973 · Exported to Australia · Cessna Aircraft Co
- [N7756Q](https://openairdocs.org/deregistered/N7756Q-1973-10-03.md): Cessna 310Q · S/N 310Q0256 · Cancelled Oct 3, 1973 · Gordon & Piatt Inc
- [N10446](https://openairdocs.org/deregistered/N10446-1973-09-06.md): Cessna 150L · S/N 15074861 · Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company
- [N10458](https://openairdocs.org/deregistered/N10458-1973-09-06.md): Cessna 150L · S/N 15074867 · Cancelled Sep 6, 1973 · Exported to South Africa · Cessna Aircraft Company
- [N10475](https://openairdocs.org/deregistered/N10475-1973-09-06.md): Cessna 150L · S/N 15074875 · Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company
- [N10480](https://openairdocs.org/deregistered/N10480-1973-09-06.md): Cessna 150L · S/N 15074879 · Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company
- [N10485](https://openairdocs.org/deregistered/N10485-1973-09-06.md): Cessna 150L · S/N 15074883 · Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company
- [N10664](https://openairdocs.org/deregistered/N10664-1973-09-06.md): Cessna 150L · S/N 15074958 · Cancelled Sep 6, 1973 · Exported to Bolivia · Cessna Aircraft Co/Commercial Aircraft Division
- [N4686](https://openairdocs.org/deregistered/N4686-1971-10-15.md): Daniels GYROCOPTER D-3 · S/N 19693 · Cancelled Oct 15, 1971 · Daniels Chester L
- [N3815K](https://openairdocs.org/deregistered/N3815K-1971-01-18.md): Globe GC-1B · S/N 3504 · Cancelled Jan 18, 1971 · Daniels Chester Lee
- [N3360C](https://openairdocs.org/deregistered/N3360C-1966-02-10.md): Beech F35 · S/N D-4026 · Cancelled Feb 10, 1966 · Joe Collins Buick
- [N37154](https://openairdocs.org/deregistered/N37154-1951-08-15.md): Fairchild 24W-41A · S/N W41A-205 · Cancelled Aug 15, 1951 · Built 1941 · Daniels Chester L
- [N3155K](https://openairdocs.org/deregistered/N3155K-1951-06-27.md): Fairchild F-47 · S/N C-103 · Cancelled Jun 27, 1951 · Fairchild Personal Planes Div
- [N77669](https://openairdocs.org/deregistered/N77669-1951-05-02.md): Fairchild 24R-46 · S/N R46369 · Cancelled May 2, 1951 · Exported to Canada · Fairchild
- [N77511](https://openairdocs.org/deregistered/N77511-1951-02-01.md): Piper J3C-65 · S/N 22001 · Cancelled Feb 1, 1951 · Jones Warren F
- [N77646](https://openairdocs.org/deregistered/N77646-1949-10-03.md): Fairchild 24W-46 · S/N W46346 · Cancelled Oct 3, 1949 · Exported to Venezuela · Fairchild
- [N77616](https://openairdocs.org/deregistered/N77616-1949-02-17.md): Fairchild 24R-46 · S/N R46284 · Cancelled Feb 17, 1949 · Fairchild
- [N77617](https://openairdocs.org/deregistered/N77617-1949-02-17.md): Fairchild 24R-46 · S/N R46297 · Cancelled Feb 17, 1949 · Fairchild
- [N77620](https://openairdocs.org/deregistered/N77620-1949-02-17.md): Fairchild 24W-46 · S/N W46320 · Cancelled Feb 17, 1949 · Fairchild Personal Plane Div
- [N77629](https://openairdocs.org/deregistered/N77629-1948-09-21.md): Fairchild 24R-46 · S/N R46385 · Cancelled Sep 21, 1948 · Exported to Mexico · Fairchild Personal Planes Division
- [N77676](https://openairdocs.org/deregistered/N77676-1948-09-20.md): Fairchild 24R-46A · S/N R46317 · Cancelled Sep 20, 1948 · Exported to Mexico · Fairchild
- [N77699](https://openairdocs.org/deregistered/N77699-1948-07-16.md): Fairchild 24R-46 · S/N R-46340 · Cancelled Jul 16, 1948 · Exported to Mexico · Fairchild
- [N77675](https://openairdocs.org/deregistered/N77675-1948-05-06.md): Fairchild 24R-46 · S/N R46-375 · Cancelled May 6, 1948 · Exported to Mexico · Fairchild
- [N77679](https://openairdocs.org/deregistered/N77679-1948-05-06.md): Fairchild 24R-46 · S/N R46-379 · Cancelled May 6, 1948 · Exported to Mexico · Fairchild
- [N77685](https://openairdocs.org/deregistered/N77685-1948-05-06.md): Fairchild 24R-46 · S/N R46-329 · Cancelled May 6, 1948 · Exported to Mexico · Fairchild
- [N81252](https://openairdocs.org/deregistered/N81252-1948-03-12.md): Fairchild 24W-46 · S/N W46300 · Cancelled Mar 12, 1948 · Exported to Canada · Fairchild Personal Planes Division
- [N77633](https://openairdocs.org/deregistered/N77633-1947-10-21.md): Fairchild 24R-46 · S/N R46354 · Cancelled Oct 21, 1947 · Exported to Mexico · Fairchild Personal Planes
- [N7884](https://openairdocs.org/deregistered/N7884-1935-09-07.md): Lincoln LINCOLN PAGE 3 · S/N 255 · Cancelled Sep 7, 1935 · Savoy Neal

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

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