OpenAirDocs.org
Churubusco, IN

Registered aircraft · 25

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N101JAStolp Starlet SA500 · S/N 2Registration pendingBuilt 1972N129DAXag V40 · S/N 810222799JG0Lahey Brent AN15HHHulboy CASSUTT III M · S/N 1-16Built 1986 · Hulboy Jeffrey KN1736DCessna 170A · S/N 20179Built 1951 · Hoffman Drew AN1948EAeronca 7AC · S/N 7AC-5515Built 1946 · Hoffman Drew AN197JCStamm J/Knopp C VARIEZE · S/N 2063Built 1987 · Good Stephen LN20604Cessna 172M · S/N 17261434Built 1973 · Leffler Paul EN230FUEa Vision EA J100 · S/N 85595Soartech LLCN2372EAeronca 7AC · S/N 7AC-5949Built 1946 · Hulboy Jeffrey KN3709EAeronca 11AC · S/N 11AC-1857Built 1947 · Pippenger James WN4038BBellanca 17-30A · S/N 76-30822Built 1976 · Harris James ThomasN40580Word Raymond A CYGNET SF-2A · S/N 398Built 1992 · Mattes Michael AN430MDMattes Michael A BUTTERCUP · S/N MB-1Built 2011 · Mattes Michael AN4913UCessna 210E · S/N 21058613Built 1965 · Garvey F PatrickN55057Piper PA-28-180 · S/N 28-7305302Built 1973 · Smooth Air LLCN600JHHulboy Jeffrey K BREEZY RLU-1 · S/N JKH-1Built 1981 · Hulboy Jefffrey KN6148ECessna 172 · S/N 46248Built 1958 · Plant Robert LN622VPGeese Douglas A VP-1 · S/N DAG-1Geese Douglas AN640DGGeese Douglas A 640 · S/N DAG-20041Built 2009 · Geese Douglas AN7179KHeideman Wilbert D CORBEN JUNIOR ACE · S/N WH-2Mattes Michael AN762TSSorg CYGNET · S/N SORG1Built 2002 · Sorg Timothy LeeN7799FCessna 150F · S/N 15063899Built 1966 · Geese Douglas AN8537NPiper J3C-65 · S/N 19117Dewald David JN87927Piper J3C-65 · S/N 15545Built 1946 · Brewer MarcusN935MBMarcus Brewer RV7 · S/N MB3Built 2012 · Brewer Marcus
Back to Churubusco, IN