# Cancelled registrations: Vandalia, OH

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

Cancelled aircraft registrations in Vandalia, OH.

- [N241PS](https://openairdocs.org/deregistered/N241PS-2023-02-04.md): Bombardier CL-600-2B19 · S/N 7909 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Psa Airlines Inc
- [N216PS](https://openairdocs.org/deregistered/N216PS-2022-12-31.md): Bombardier CL-600-2B19 · S/N 7882 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2003 · Psa Airlines Inc
- [N8349Y](https://openairdocs.org/deregistered/N8349Y-2017-02-28.md): Piper PA-30 · S/N 30-1496 · Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1967 · Richardson Kenneth
- [N125V](https://openairdocs.org/deregistered/N125V-2013-09-20.md): Swing Brian S VELOCITY RG · S/N DM 074 · Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Swing Brian S
- [N3BQ](https://openairdocs.org/deregistered/N3BQ-2012-07-30.md): Cessna 140 · S/N 11589 · Cancelled Jul 30, 2012 · Registration pending, canceled · Built 1946
- [N951R](https://openairdocs.org/deregistered/N951R-2004-02-19.md): Mcdonnell Douglas DC-8-63 · S/N 46092 · Cancelled Feb 19, 2004 · Triennial form not returned · Emery Worldwide Airlines Inc
- [N37253](https://openairdocs.org/deregistered/N37253-1994-08-05.md): Beech 77 · S/N WA122 · Cancelled Aug 5, 1994 · Triennial form not returned · Crossroads Aero Club Inc
- [N133MB](https://openairdocs.org/deregistered/N133MB-1994-02-07.md): Robinson Helicopter R22 BETA · S/N 1133 · Cancelled Feb 7, 1994 · Triennial form not returned · M G Helicopters Inc
- [N42BR](https://openairdocs.org/deregistered/N42BR-1990-11-29.md): Piper PA-31-310 · S/N 317712021 · Cancelled Nov 29, 1990 · Exported to Australia · Aviation Sales Inc
- [N55892](https://openairdocs.org/deregistered/N55892-1974-06-27.md): Piper PA-28-180 · S/N 28-7305493 · Cancelled Jun 27, 1974 · Exported to Germany · Skyways Inc
- [N51208](https://openairdocs.org/deregistered/N51208-1972-08-01.md): Cessna 150J · S/N 15069839 · Cancelled Aug 1, 1972 · Exported to Canada · Aviation Sales Inc
- [N50594](https://openairdocs.org/deregistered/N50594-1972-07-13.md): Cessna 150J · S/N 15069421 · Cancelled Jul 13, 1972 · Exported to Canada · Aviation Sales Inc
- [N849PS](https://openairdocs.org/deregistered/N849PS-1972-07-05.md): Piper PA-23-250 · S/N 27-3913 · Cancelled Jul 5, 1972 · Exported to Canada · Skyways Inc
- [N3172R](https://openairdocs.org/deregistered/N3172R-1972-04-24.md): Piper PA-28R-180 · S/N 28R-31120 · Cancelled Apr 24, 1972 · Exported to Germany · Built 1969 · Skyways Inc
- [N79407](https://openairdocs.org/deregistered/N79407-1971-12-03.md): Cessna 172K · S/N 17258058 · Cancelled Dec 3, 1971 · Van Dusen Aircraft Supply Ohio Division Inc
- [N22818](https://openairdocs.org/deregistered/N22818-1971-01-26.md): Cessna 150H · S/N 15068538 · Cancelled Jan 26, 1971 · Aviation Sales Inc
- [N5041Z](https://openairdocs.org/deregistered/N5041Z-1971-01-25.md): Piper PA-22 · S/N 22-8661 · Cancelled Jan 25, 1971 · Skyways Inc
- [N88M](https://openairdocs.org/deregistered/N88M-1970-09-18.md): W B B Associates BIGOS RACER · S/N 101 · Cancelled Sep 18, 1970 · Dayton Air Racing Association
- [N2157C](https://openairdocs.org/deregistered/N2157C-1970-06-17.md): Cessna 195B · S/N 16142 · Cancelled Jun 17, 1970 · L Horbe William De
- [N5314](https://openairdocs.org/deregistered/N5314-1970-01-02.md): Beech D50C · S/N DH-284 · Cancelled Jan 2, 1970 · Ohio Aviation Co
- [N1902E](https://openairdocs.org/deregistered/N1902E-1965-05-25.md): Aeronca 7AC · S/N 7AC5469 · Cancelled May 25, 1965 · Skyways Inc
- [N84603](https://openairdocs.org/deregistered/N84603-1965-05-24.md): Aeronca 7AC · S/N 7AC3310 · Cancelled May 24, 1965 · Skyways Inc
- [N1342E](https://openairdocs.org/deregistered/N1342E-1965-05-22.md): Aeronca 7AC · S/N 7AC-4903 · Cancelled May 22, 1965 · Skyways Inc
- [N2889E](https://openairdocs.org/deregistered/N2889E-1965-05-22.md): Aeronca 7AC · S/N 7AC6472 · Cancelled May 22, 1965 · Skyways Inc
- [N6792P](https://openairdocs.org/deregistered/N6792P-1965-05-20.md): Piper PA-24-250 · S/N 24-1925 · Cancelled May 20, 1965 · Skyways Inc
- [N18388](https://openairdocs.org/deregistered/N18388-1964-05-26.md): Barkley - Grow T8P-1 · S/N 1 · Cancelled May 26, 1964 · Exported to Canada · Built 1937 · Dayton Aircraft Sales Inc
- [N44594](https://openairdocs.org/deregistered/N44594-1956-07-06.md): Beech D18S · S/N A-3 · Cancelled Jul 6, 1956 · Exported to Canada · Ohio Aviation Company
- [N39633](https://openairdocs.org/deregistered/N39633-1956-03-05.md): Aeronca 7AC · S/N 7AC-4 · Cancelled Mar 5, 1956 · Built 1945 · Skyways Inc
- [N64728](https://openairdocs.org/deregistered/N64728-1956-02-17.md): Consolidated Vultee BT-13A · S/N 2595 · Cancelled Feb 17, 1956 · Skyways Inc
- [N61561](https://openairdocs.org/deregistered/N61561-1955-10-12.md): Consolidated Vultee BT-13B (SNV-2) · S/N 79-234 · Cancelled Oct 12, 1955 · Mcintyre Ken R
- [N61635](https://openairdocs.org/deregistered/N61635-1955-10-12.md): Fairchild PT-23 · S/N H0-308 · Cancelled Oct 12, 1955 · Skyways Inc
- [N7482K](https://openairdocs.org/deregistered/N7482K-1951-11-15.md): Piper PA-20 · S/N 20-395 · Cancelled Nov 15, 1951 · Mackall H C Jr
- [N4397K](https://openairdocs.org/deregistered/N4397K-1949-06-14.md): Ryan NAVION · S/N NAV-4-1397 · Cancelled Jun 14, 1949 · Built 1948 · Southern Ohio Aviation Co
- [N91119](https://openairdocs.org/deregistered/N91119-1949-04-22.md): North American NAVION · S/N NAV443 · Cancelled Apr 22, 1949 · Souther Ohio Aviation Co
- [N17459](https://openairdocs.org/deregistered/N17459-1948-04-22.md): Waco ZGC-7 · S/N 4553 · Cancelled Apr 22, 1948 · Built 1937 · Dayton Airways Inc
- [N368H](https://openairdocs.org/deregistered/N368H-1932-06-01.md): Davis V-3 · S/N 104 · Cancelled Jun 1, 1932 · Johnson Edward A

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

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