# Cancelled registrations: Blackwell, OK

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

Cancelled aircraft registrations in Blackwell, OK.

- [N5560L](https://openairdocs.org/deregistered/N5560L-2018-01-25.md): Raven Industries RALLY RX7 · S/N RX7-161 · Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1979 · Gasbag International Airways Ltd
- [N107BG](https://openairdocs.org/deregistered/N107BG-2018-01-09.md): Oklahoma Light SPORT HORNET · S/N 071 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Oklahoma Light Aircraft LLC
- [N714WX](https://openairdocs.org/deregistered/N714WX-2013-05-03.md): Cessna 152 · S/N 15279500 · Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1977 · Brown Lari
- [N4227P](https://openairdocs.org/deregistered/N4227P-2012-11-21.md): Piper PA-23-160 · S/N 23-1723 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1959 · Million Tom L
- [N73949](https://openairdocs.org/deregistered/N73949-1996-05-30.md): Bell 47J-2 · S/N 2837 · Cancelled May 30, 1996 · Exported to Greece · Stettnisch Jerry A DBA
- [N5154J](https://openairdocs.org/deregistered/N5154J-1992-09-23.md): Cessna 172N · S/N 17273716 · Cancelled Sep 23, 1992 · Triennial form not returned · Kice David J
- [N9576A](https://openairdocs.org/deregistered/N9576A-1952-01-16.md): Cessna 170A · S/N 19137 · Cancelled Jan 16, 1952 · Mcculloch Doyle
- [N645C](https://openairdocs.org/deregistered/N645C-1949-06-02.md): Stinson 108-3 · S/N 108-3645 · Cancelled Jun 2, 1949 · Blackwell Aircraft Sales
- [N72835](https://openairdocs.org/deregistered/N72835-1949-05-02.md): Cessna 140 · S/N 10024 · Cancelled May 2, 1949 · Mauk Walter D
- [N33273](https://openairdocs.org/deregistered/N33273-1943-05-08.md): Piper J5A · S/N 5-474 · Cancelled May 8, 1943 · Walter D Mauk
- [N4535](https://openairdocs.org/deregistered/N4535-1940-05-20.md): Travel Air 2000 · S/N 390 · Cancelled May 20, 1940 · Walter D Mauk
- [N196V](https://openairdocs.org/deregistered/N196V-1933-03-08.md): Cessna CG-2 · S/N 68 · Cancelled Mar 8, 1933 · Blackwell Glider Club
- [N1600](https://openairdocs.org/deregistered/N1600-1933-01-11.md): Swallow SWALLOW · S/N 131 · Cancelled Jan 11, 1933 · Built 1927 · Varner Everett E
- [N144V](https://openairdocs.org/deregistered/N144V-1932-04-04.md): Cessna GC-1 · S/N 249 · Cancelled Apr 4, 1932 · Skyways Inc
- [N162K](https://openairdocs.org/deregistered/N162K-1932-04-04.md): Monocoupe 113 · S/N 356 · Cancelled Apr 4, 1932 · Built 1930 · Lynn John B
- [N4805](https://openairdocs.org/deregistered/N4805-1932-04-04.md): Ford 4-AT-B · S/N 17 · Cancelled Apr 4, 1932 · Skyway Inc
- [N435W](https://openairdocs.org/deregistered/N435W-1932-03-22.md): Travel Air B-4000 · S/N 1328 · Cancelled Mar 22, 1932 · Lee Orville
- [N4251](https://openairdocs.org/deregistered/N4251-1931-04-13.md): Travel Air 5000 · S/N 170 · Cancelled Apr 13, 1931 · Built 1927 · Lee O J
- [N1378](https://openairdocs.org/deregistered/N1378-1928-05-10.md): Travel Air Manufacturing BIPLANE · S/N 137 · Cancelled May 10, 1928 · Lee Orville
- [N59532](https://openairdocs.org/deregistered/N59532-undated.md): Piper J4E · S/N 4-1644 (43-3006) ARMY · Cancellation date not recorded · Built 1943 · North G H

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

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