# Registered aircraft: Rochester, MI

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N100PH](https://openairdocs.org/aircraft/N100PH.md): Paul Heasman SLING TSI · S/N 257SK · Built 2023 · Heasman Paul
- [N143RH](https://openairdocs.org/aircraft/N143RH.md): Jostock Michael E ZODIAC CH 601 · S/N 51151 · Built 1999 · Jostock Michael E
- [N14SV](https://openairdocs.org/aircraft/N14SV.md): Nord STAMPE SV4C · S/N 537 · Built 1947 · Baron Robert David
- [N20777](https://openairdocs.org/aircraft/N20777.md): Cessna 182P · S/N 18261195 · Marthew Aviation LLC
- [N2158Z](https://openairdocs.org/aircraft/N2158Z.md): Piper PA-28-181 · S/N 28-7990403 · Built 1979 · Tribute Aero LLC
- [N2811A](https://openairdocs.org/aircraft/N2811A.md): Mooney M20R · S/N 29-0503 · Built 2008 · Adrien Aviation LLC
- [N363WT](https://openairdocs.org/aircraft/N363WT.md): Cirrus Design SR22T · S/N 9290 · Built 2023 · J S Aviation LLC
- [N3904B](https://openairdocs.org/aircraft/N3904B.md): Brown Raymond AIR COMMAND · S/N 01 · Built 2009 · Smith Scott W
- [N3970J](https://openairdocs.org/aircraft/N3970J.md): Jeason Martin W QUICKSILVER MX II · S/N 1364 · Built 1983 · Jeason Martin W
- [N40768](https://openairdocs.org/aircraft/N40768.md): Piper PA-28R-200 · S/N 28R-7435122 · Built 1973 · Trescone Dennis M
- [N4214M](https://openairdocs.org/aircraft/N4214M.md): Robinson Helicopter R44 · S/N 2008 · Built 2009 · Lawler Helicopter Leasing LLC
- [N44076](https://openairdocs.org/aircraft/N44076.md): Piper PA-28-151 · S/N 28-7415576 · Built 1974 · Robinson Richard
- [N5372V](https://openairdocs.org/aircraft/N5372V.md): Cessna 172RG · S/N 172RG0516 · Built 1980 · Cooper'S Hawk Aviation LLC
- [N551CG](https://openairdocs.org/aircraft/N551CG.md): Vans RV-12 · S/N 120020 · Built 2010 · Whp Holdings LLC
- [N6055Z](https://openairdocs.org/aircraft/N6055Z.md): Cessna 162 · S/N 16200202 · Built 2012 · Fackler Ken
- [N698TC](https://openairdocs.org/aircraft/N698TC.md): Cessna 525A · S/N 525A0051 · Built 2001 · Ava Aviation LLC
- [N772M](https://openairdocs.org/aircraft/N772M.md): Beech A36TC · S/N EA-14 · Built 1979 · Cayle Jonathan
- [N774CG](https://openairdocs.org/aircraft/N774CG.md): Holt Timothy C RV-10 · S/N 40635 · Built 2012 · Holt Timothy C
- [N79UW](https://openairdocs.org/aircraft/N79UW.md): Raven S55A · S/N S55A-519 · Built 1979 · Brittingham Carl H
- [N8124V](https://openairdocs.org/aircraft/N8124V.md): Cessna R172K · S/N R1722316 · Built 1977 · Farhat Jamal M
- [N8413T](https://openairdocs.org/aircraft/N8413T.md): Piper PA-34-220T · S/N 34-8133170 · Built 1981 · Dmh Aviation LLC
- [N9760C](https://openairdocs.org/aircraft/N9760C.md): Piper PA-28-161 · S/N 28-7816526 · Built 1978 · Street Steven J

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'MI' AND g.registrant_city = 'ROCHESTER'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/MI/Rochester/aircraft

---
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.