# Cancelled registrations: Phillipsburg, OH

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

Cancelled aircraft registrations in Phillipsburg, OH.

- [N995BP](https://openairdocs.org/deregistered/N995BP-2020-10-14.md): Harvey Albert J PULSAR XP · S/N 364 · Cancelled Oct 14, 2020 · Exported to New Zealand · Built 1998 · Steel Aviation Inc
- [N44804](https://openairdocs.org/deregistered/N44804-2018-01-23.md): Piper PA-28-140 · S/N 28-7525007 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1974 · Tnt Aviation LLC
- [N727EB](https://openairdocs.org/deregistered/N727EB-2015-05-21.md): Bihn Edward J BIHN 500 · S/N 001 · Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1997 · Bihn Edward J
- [N7248Y](https://openairdocs.org/deregistered/N7248Y-2011-08-09.md): Piper PA-30 · S/N 30-273 · Cancelled Aug 9, 2011 · First renewal notice · Built 1964 · Miller Aircraft Inc
- [N5376E](https://openairdocs.org/deregistered/N5376E-2010-07-30.md): Beech K35 · S/N D-5904 · Cancelled Jul 30, 2010 · Triennial form not returned · Built 1959 · Miller Aircraft Inc
- [N7689U](https://openairdocs.org/deregistered/N7689U-2009-11-17.md): Cessna 150M · S/N 15077815 · Cancelled Nov 17, 2009 · Exported to Canada · Built 1976 · Miller Aircraft Inc
- [N8621W](https://openairdocs.org/deregistered/N8621W-2006-03-15.md): Piper PA-28-235 · S/N 28-10135 · Cancelled Mar 15, 2006 · Exported to Canada · Built 1963 · Miller Aircraft Inc
- [N722B](https://openairdocs.org/deregistered/N722B-2000-05-01.md): Beech A35 · S/N D-1729 · Cancelled May 1, 2000 · Miller Aircraft Inc
- [N27812](https://openairdocs.org/deregistered/N27812-1997-02-18.md): Piper PA-31-350 · S/N 317852163 · Cancelled Feb 18, 1997 · Second triennial mailing, no response · Miller Aircraft Inc
- [N733DW](https://openairdocs.org/deregistered/N733DW-1996-04-30.md): Cessna 172N · S/N 17268224 · Cancelled Apr 30, 1996 · Phillipsburg Aviation Inc
- [N581T](https://openairdocs.org/deregistered/N581T-1980-12-31.md): Tomblingson BREEZY RUL-1 · S/N ET-3 · Cancelled Dec 31, 1980 · Revoked, pending cancellation · Built 1971 · Miller Flying Service
- [N6536F](https://openairdocs.org/deregistered/N6536F-1977-07-15.md): Cessna 150F · S/N 15063136 · Cancelled Jul 15, 1977 · Exported to Canada · Miller Flying Service Inc
- [N9312K](https://openairdocs.org/deregistered/N9312K-1977-07-14.md): Stinson 108-2 · S/N 108-2312 · Cancelled Jul 14, 1977 · Exported to Canada · Miller Flying Service Inc
- [N1943P](https://openairdocs.org/deregistered/N1943P-1977-07-13.md): Piper PA-22-150 · S/N 22-2694 · Cancelled Jul 13, 1977 · Exported to Canada · Built 1955 · Miller Flying Service Inc
- [N7720Y](https://openairdocs.org/deregistered/N7720Y-1977-06-30.md): Piper PA-30 · S/N 30-809 · Cancelled Jun 30, 1977 · Exported to Canada · Huffakfer Keith L
- [N1652F](https://openairdocs.org/deregistered/N1652F-1977-05-20.md): Cessna 172H · S/N 17255047 · Cancelled May 20, 1977 · Exported to Canada · Miller Flying Service Inc
- [N5134S](https://openairdocs.org/deregistered/N5134S-1977-05-11.md): Piper PA-28-140 · S/N 28-7125466 · Cancelled May 11, 1977 · Exported to Canada · Built 1971 · Miller Flying Service Inc
- [N5377R](https://openairdocs.org/deregistered/N5377R-1977-05-05.md): Cessna 172F · S/N 17252911 · Cancelled May 5, 1977 · Exported to Canada · Miller Flying Service Inc
- [N19027](https://openairdocs.org/deregistered/N19027-1977-04-18.md): Cessna 150L · S/N 15074105 · Cancelled Apr 18, 1977 · Exported to Canada · Miller Flying Service Inc
- [N7030B](https://openairdocs.org/deregistered/N7030B-1976-12-14.md): Piper PA-22-150 · S/N 22-4281 · Cancelled Dec 14, 1976 · Exported to Canada · Miller Flying Service Inc

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

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