# Cancelled registrations: Rochester, MI

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

Cancelled aircraft registrations in Rochester, MI.

- [N783WA](https://openairdocs.org/deregistered/N783WA-2022-12-03.md): Sensefly EBEE AG 3 · S/N EB-03-06560 · Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Oakland University Department Of Anthropology
- [N8744W](https://openairdocs.org/deregistered/N8744W-2018-05-21.md): Piper PA-28-235 · S/N 28-10284 · Cancelled May 21, 2018 · Revoked, canceled · Built 1964 · Jacobes John P
- [N3245B](https://openairdocs.org/deregistered/N3245B-2018-02-13.md): Brewster-Bernardi QUICKIE 2 · S/N 2507 · Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1982 · Mccomb Jeffrey T
- [N7002V](https://openairdocs.org/deregistered/N7002V-2014-12-03.md): Eagle Balloons C-7 · S/N E82727 · Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1982 · Baker Michael J
- [N1523X](https://openairdocs.org/deregistered/N1523X-2014-09-05.md): Balloon Works FIREFLY 7-B · S/N 10300 · Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1981 · Corey Jayson P
- [N68L](https://openairdocs.org/deregistered/N68L-2013-10-23.md): San Antonio MIDGET MUSTANG · S/N AL-1 · Cancelled Oct 23, 2013 · Revoked, canceled · Lanktree Albert M
- [N9894R](https://openairdocs.org/deregistered/N9894R-2013-07-01.md): Beech M35 · S/N D-6450 · Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1960 · Pierobon Luciano Iglio
- [N9063C](https://openairdocs.org/deregistered/N9063C-2013-06-27.md): Merwyn Taylor TOPPER · S/N 1 · Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1956 · Woodworth Gary Edward
- [N2430Z](https://openairdocs.org/deregistered/N2430Z-2013-06-18.md): General Balloon NEWPORT · S/N 430 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Birmingham Camera
- [N81BZ](https://openairdocs.org/deregistered/N81BZ-2013-06-07.md): Raven S55A · S/N S55A-744 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Sallised Ltd
- [N99099](https://openairdocs.org/deregistered/N99099-2013-05-30.md): Ercoupe 415-C · S/N 1722 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1946 · Waldrup Charles L
- [N97DP](https://openairdocs.org/deregistered/N97DP-2013-05-24.md): Piccard AX-6 · S/N 747 · Cancelled May 24, 2013 · Registration expired, pending cancellation · Built 1975 · Red Knapp Dairy Bar
- [N85BD](https://openairdocs.org/deregistered/N85BD-2013-05-06.md): Cessna 140 · S/N 10897 · Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1946 · Drum Burnell N
- [N94US](https://openairdocs.org/deregistered/N94US-2009-09-18.md): Piccard AX-6 · S/N 694 · Cancelled Sep 18, 2009 · Registration revoked · Built 1974 · C And C Rent All Inc
- [N103MH](https://openairdocs.org/deregistered/N103MH-2005-11-01.md): Robinson Helicopter R22 ALPHA · S/N 0454 · Cancelled Nov 1, 2005 · Triennial form not returned · Built 1984 · Lawler David M
- [N5322P](https://openairdocs.org/deregistered/N5322P-1998-03-16.md): Piper PA-24-250 · S/N 24365 · Cancelled Mar 16, 1998 · Triennial form not returned · Lee Albert E
- [N2246H](https://openairdocs.org/deregistered/N2246H-1995-01-30.md): Balloon Works FIREFLY 7 · S/N 7870 · Cancelled Jan 30, 1995 · Kollin Dennis T
- [N36088](https://openairdocs.org/deregistered/N36088-1995-01-30.md): Balloon Works FIREFLY 8-24 · S/N F8005 · Cancelled Jan 30, 1995 · Kollin Dennis
- [N4046D](https://openairdocs.org/deregistered/N4046D-1995-01-30.md): Balloon Works FIREFLY 7 · S/N 7898 · Cancelled Jan 30, 1995 · Second triennial mailing, no response · Kollin Dennis
- [N2192D](https://openairdocs.org/deregistered/N2192D-1981-05-08.md): Beech D35 · S/N D-3539 · Cancelled May 8, 1981 · Exported to Canada · Six November Fox Corp
- [N11N](https://openairdocs.org/deregistered/N11N-1980-11-07.md): Mcpherson PACIFIC AIRCRAFTD-8 · S/N 1 · Cancelled Nov 7, 1980 · Built 1969 · Engel Leland E
- [N8150F](https://openairdocs.org/deregistered/N8150F-1977-07-18.md): Cessna 150F · S/N 15064250 · Cancelled Jul 18, 1977 · Bascom John
- [N6816H](https://openairdocs.org/deregistered/N6816H-1973-07-30.md): Piper J3C-65 · S/N 20031 · Cancelled Jul 30, 1973 · Shick Jr Robert L
- [N550XX](https://openairdocs.org/deregistered/N550XX-1972-10-11.md): Piper PA-32-260 · S/N 327200003 · Cancelled Oct 11, 1972 · Gallaty Paul
- [N28721](https://openairdocs.org/deregistered/N28721-1971-12-07.md): Luscombe 8C · S/N 1482 · Cancelled Dec 7, 1971 · Exported to Canada · Flying D Inc
- [N2309E](https://openairdocs.org/deregistered/N2309E-1970-09-23.md): Aeronca 7AC · S/N 7AC-5881 · Cancelled Sep 23, 1970 · Exported to Canada · Charles William Pajares Jr
- [N45472](https://openairdocs.org/deregistered/N45472-1970-06-23.md): Silvaire LUSCOMBE 8A · S/N 1999 · Cancelled Jun 23, 1970 · Bildstein Joseph J
- [N550XX](https://openairdocs.org/deregistered/N550XX-1970-01-23.md): Piper PA-32-260 · S/N 32-675 · Cancelled Jan 23, 1970 · Exported to Canada · Gallaty Paul & Gallaty Norma
- [N26688](https://openairdocs.org/deregistered/N26688-1969-01-15.md): Taylorcraft BL-65 · S/N 2030 · Cancelled Jan 15, 1969 · Built 1940 · Furr Robert L
- [N7063C](https://openairdocs.org/deregistered/N7063C-1965-05-25.md): North American SNJ-4 · S/N 88-13288 · Cancelled May 25, 1965 · Juengel Lawrence D
- [N9340K](https://openairdocs.org/deregistered/N9340K-1965-03-23.md): Universal Stinson 108-2 · S/N 108-2340 · Cancelled Mar 23, 1965 · Robert L Furr
- [N28532](https://openairdocs.org/deregistered/N28532-1963-07-05.md): Fairchild 24R-46 · S/N R46-139 · Cancelled Jul 5, 1963 · Exported to Canada · Hensley Robert L
- [N51455](https://openairdocs.org/deregistered/N51455-1955-11-29.md): Aeronca 0-58B · S/N 8743 · Cancelled Nov 29, 1955 · Doucette Maurice Edward

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

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