# Registered aircraft: Churubusco, IN

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

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

- [N101JA](https://openairdocs.org/aircraft/N101JA.md): Stolp Starlet SA500 · S/N 2 · Registration pending · Built 1972
- [N129DA](https://openairdocs.org/aircraft/N129DA.md): Xag V40 · S/N 810222799JG0 · Lahey Brent A
- [N15HH](https://openairdocs.org/aircraft/N15HH.md): Hulboy CASSUTT III M · S/N 1-16 · Built 1986 · Hulboy Jeffrey K
- [N1736D](https://openairdocs.org/aircraft/N1736D.md): Cessna 170A · S/N 20179 · Built 1951 · Hoffman Drew A
- [N1948E](https://openairdocs.org/aircraft/N1948E.md): Aeronca 7AC · S/N 7AC-5515 · Built 1946 · Hoffman Drew A
- [N197JC](https://openairdocs.org/aircraft/N197JC.md): Stamm J/Knopp C VARIEZE · S/N 2063 · Built 1987 · Good Stephen L
- [N20604](https://openairdocs.org/aircraft/N20604.md): Cessna 172M · S/N 17261434 · Built 1973 · Leffler Paul E
- [N230FU](https://openairdocs.org/aircraft/N230FU.md): Ea Vision EA J100 · S/N 85595 · Soartech LLC
- [N2372E](https://openairdocs.org/aircraft/N2372E.md): Aeronca 7AC · S/N 7AC-5949 · Built 1946 · Hulboy Jeffrey K
- [N3709E](https://openairdocs.org/aircraft/N3709E.md): Aeronca 11AC · S/N 11AC-1857 · Built 1947 · Pippenger James W
- [N4038B](https://openairdocs.org/aircraft/N4038B.md): Bellanca 17-30A · S/N 76-30822 · Built 1976 · Harris James Thomas
- [N40580](https://openairdocs.org/aircraft/N40580.md): Word Raymond A CYGNET SF-2A · S/N 398 · Built 1992 · Mattes Michael A
- [N430MD](https://openairdocs.org/aircraft/N430MD.md): Mattes Michael A BUTTERCUP · S/N MB-1 · Built 2011 · Mattes Michael A
- [N4913U](https://openairdocs.org/aircraft/N4913U.md): Cessna 210E · S/N 21058613 · Built 1965 · Garvey F Patrick
- [N55057](https://openairdocs.org/aircraft/N55057.md): Piper PA-28-180 · S/N 28-7305302 · Built 1973 · Smooth Air LLC
- [N600JH](https://openairdocs.org/aircraft/N600JH.md): Hulboy Jeffrey K BREEZY RLU-1 · S/N JKH-1 · Built 1981 · Hulboy Jefffrey K
- [N6148E](https://openairdocs.org/aircraft/N6148E.md): Cessna 172 · S/N 46248 · Built 1958 · Plant Robert L
- [N622VP](https://openairdocs.org/aircraft/N622VP.md): Geese Douglas A VP-1 · S/N DAG-1 · Geese Douglas A
- [N640DG](https://openairdocs.org/aircraft/N640DG.md): Geese Douglas A 640 · S/N DAG-20041 · Built 2009 · Geese Douglas A
- [N7179K](https://openairdocs.org/aircraft/N7179K.md): Heideman Wilbert D CORBEN JUNIOR ACE · S/N WH-2 · Mattes Michael A
- [N762TS](https://openairdocs.org/aircraft/N762TS.md): Sorg CYGNET · S/N SORG1 · Built 2002 · Sorg Timothy Lee
- [N7799F](https://openairdocs.org/aircraft/N7799F.md): Cessna 150F · S/N 15063899 · Built 1966 · Geese Douglas A
- [N8537N](https://openairdocs.org/aircraft/N8537N.md): Piper J3C-65 · S/N 19117 · Dewald David J
- [N87927](https://openairdocs.org/aircraft/N87927.md): Piper J3C-65 · S/N 15545 · Built 1946 · Brewer Marcus
- [N935MB](https://openairdocs.org/aircraft/N935MB.md): Marcus Brewer RV7 · S/N MB3 · Built 2012 · Brewer Marcus

## 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 = 'IN' AND g.registrant_city = 'CHURUBUSCO'
ORDER BY g.n_number
```

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