# Registered aircraft: Belleville, MI

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

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

- [N102JH](https://openairdocs.org/aircraft/N102JH.md): Hickey John C KITFOX IV · S/N 1471 · Built 1992 · Hickey John C
- [N14378](https://openairdocs.org/aircraft/N14378.md): Paul Johnston F-10A · S/N F-4656 · Built 2012 · Johnston Paul
- [N1699R](https://openairdocs.org/aircraft/N1699R.md): Cessna R182 · S/N R18200522 · Built 1978 · Macdonald Eric J
- [N1925V](https://openairdocs.org/aircraft/N1925V.md): Cessna 140 · S/N 14123 · Built 1947 · Newell Robert J Jr
- [N20873](https://openairdocs.org/aircraft/N20873.md): Piper PA-28-181 · S/N 28-7990027 · Built 1978 · Mang Aero Club
- [N2198N](https://openairdocs.org/aircraft/N2198N.md): Cessna 140 · S/N 12434 · Built 1948 · Shaw Thomas A Jr
- [N240GH](https://openairdocs.org/aircraft/N240GH.md): Bell UH-1H · S/N 66-01126 · Built 1966 · Yankee Air Force Inc
- [N2470K](https://openairdocs.org/aircraft/N2470K.md): Luscombe 8E · S/N 5197 · Built 1947 · Sucich John J
- [N2562E](https://openairdocs.org/aircraft/N2562E.md): Aeronca 7AC · S/N 7AC-6145 · Built 1946 · Newell Robert J Jr
- [N315CJ](https://openairdocs.org/aircraft/N315CJ.md): Cessna 525B · S/N 525B0315 · Built 2009 · Flagship Private Air LLC
- [N324DK](https://openairdocs.org/aircraft/N324DK.md): Karaschin Rick A S-7S COURIER · S/N 1007486 · Built 2020 · Karaschin Rick A
- [N3386A](https://openairdocs.org/aircraft/N3386A.md): Hawker Beechcraft HAWKER 900XP · S/N HA0056 · Built 2008 · Bcma LLC
- [N34378](https://openairdocs.org/aircraft/N34378.md): Paul Johnston BEARHAWK PATROL · S/N 47P-129P/130P-P130P · Built 2021 · Johnston Paul
- [N3774](https://openairdocs.org/aircraft/N3774.md): North American B-25C · S/N 43-3634 · Built 1943 · Yankee Air Force Inc
- [N3931T](https://openairdocs.org/aircraft/N3931T.md): Piper PA-28R-180 · S/N 28R-30270 · Built 1967 · Hall Charles H
- [N42CM](https://openairdocs.org/aircraft/N42CM.md): Cessna 172M · S/N 17266374 · Mazor Chris
- [N43755](https://openairdocs.org/aircraft/N43755.md): Piper PA-28-181 · S/N 28-7890010 · Built 1977 · Mang Aero Club Inc
- [N45FM](https://openairdocs.org/aircraft/N45FM.md): Beech 58 · S/N TH-739 · Built 1976 · Burgner Vanessa C
- [N54115](https://openairdocs.org/aircraft/N54115.md): Cessna 172P · S/N 17274879 · Built 1981 · Mang Aero Club Inc
- [N6811G](https://openairdocs.org/aircraft/N6811G.md): Cessna 150L · S/N 15072311 · Built 1970 · Pearce Douglas S
- [N6MH](https://openairdocs.org/aircraft/N6MH.md): Dehavilland DHC-1B-2 · S/N 155 · Built 1950 · Paquette Daniel J
- [N705MS](https://openairdocs.org/aircraft/N705MS.md): Burkhart Grob G 103 TWIN II · S/N 3609 · Built 1981 · Adrian Soaring Club Inc
- [N7268H](https://openairdocs.org/aircraft/N7268H.md): Piper J3C-65 · S/N 20518 · Built 1946 · Timoszyk Daniel M
- [N726US](https://openairdocs.org/aircraft/N726US.md): Boeing 727-223 · S/N 22469 · Built 1981 · USA Jet Airlines Inc
- [N727US](https://openairdocs.org/aircraft/N727US.md): Boeing 727-223 · S/N 22470 · Built 1981 · USA Jet Airlines Inc
- [N7922B](https://openairdocs.org/aircraft/N7922B.md): Cessna 172 · S/N 29722 · Built 1957 · Manley Ronnie H
- [N8018P](https://openairdocs.org/aircraft/N8018P.md): Powrachute PC 2000 · S/N A17PQW · Built 2000 · Syring Leslie J Jr
- [N8071K](https://openairdocs.org/aircraft/N8071K.md): Stinson 108-2 · S/N 108-3071 · Built 1947 · Herring Benjamin L
- [N816W](https://openairdocs.org/aircraft/N816W.md): Flight Design CTLS · S/N F-08-07-08 · Built 2008 · Wade Phillip L
- [N831US](https://openairdocs.org/aircraft/N831US.md): Mcdonnell Douglas MD 83 · S/N 49791 · Built 1989 · USA Jet Airlines Inc
- [N832US](https://openairdocs.org/aircraft/N832US.md): Mcdonnell Douglas MD-88 · S/N 53259 · Built 1991 · USA Jet Airlines Inc
- [N833US](https://openairdocs.org/aircraft/N833US.md): Mcdonnell Douglas MD-88 · S/N 53215 · Built 1991 · USA Jet Airlines Inc
- [N834US](https://openairdocs.org/aircraft/N834US.md): Mcdonnell Douglas MD-88 · S/N 53115 · Built 1990 · USA Jet Airlines Inc
- [N835US](https://openairdocs.org/aircraft/N835US.md): Mcdonnell Douglas MD-88 · S/N 53172 · Built 1990 · USA Jet Airlines Inc
- [N836US](https://openairdocs.org/aircraft/N836US.md): Mcdonnell Douglas MD-88 · S/N 53214 · Built 1991 · USA Jet Airlines Inc
- [N837US](https://openairdocs.org/aircraft/N837US.md): Mcdonnell Douglas MD-88 · S/N 53257 · Built 1991 · USA Jet Airlines Inc
- [N842US](https://openairdocs.org/aircraft/N842US.md): Mcdonnell Douglas MD-88 · S/N 53380 · Built 1992 · USA Jet Airlines Inc
- [N8704](https://openairdocs.org/aircraft/N8704.md): Douglas DC3C-S4C4G · S/N 33048 · Built 1944 · Yankee Air Force Inc
- [N9610](https://openairdocs.org/aircraft/N9610.md): Ford 4-AT-B · S/N 42 · Yankee Air Force Inc
- [N9922Z](https://openairdocs.org/aircraft/N9922Z.md): Flight Design CTSW · S/N 06-08-02 · Built 2006 · Harrison Richard E
- [N992LK](https://openairdocs.org/aircraft/N992LK.md): Cirrus Design SR22 · S/N 0610 · Built 2003 · Icc Aviation LLC
- [N99AH](https://openairdocs.org/aircraft/N99AH.md): Schleicher ASW-15 · S/N 15135 · Built 1971 · Adrian Soaring Club

## 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 = 'BELLEVILLE'
ORDER BY g.n_number
```

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