Centerburg, OH
Registered aircraft · 30
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 = 'OH' AND g.registrant_city = 'CENTERBURG' 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.
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 = 'OH' AND g.registrant_city = 'CENTERBURG' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N11358Cessna 150L · S/N 15075350N1204KVans RV-12IS · S/N 120267N141TSDJI AGRAS T50 · S/N 1581F6BUB243U001T2PQN15AAAebersold Alan L BABY GREAT LAKES · S/N 6908D-155BN1758NCessna 120 · S/N 12002N180MDFlorman Larry D CHRISTEN EAGLE II · S/N FLORMAN-0001N1875Stits Playmate SA-11A · S/N 9N250JBBolin George R ZENITH CH250 · S/N A-109N27569Taylorcraft BC-65 · S/N 2210N3343TCessna 177 · S/N 17700643N3AEHenley James H A31-1B1 · S/N 123N443JBBaldwin James H RV-6 · S/N 20023N45KAeronca 7AC · S/N 7AC5244N491JPPuent John D BD-4 · S/N 491N4984FRockwell International 114 · S/N 14246N5130CBeech B35 · S/N D-2415N53192Guy Jeffrey AGAPE - 2 · S/N 0001N624RCCahill Richard COZY · S/N 318N7022XFisher Michael E FISHER AEROSTAR · S/N AS1020First renewal noticeN7384TCessna 172A · S/N 46984N7517KPiper PA-18-105 SPECIAL · S/N 18-235N8196CPiper PA-22-135 · S/N 22-2301N84622Aeronca 7AC · S/N 7AC-3326N91369Barton BEDE 4 · S/N 492N9186DPiper PA-22-160 · S/N 22-6244N92GBBell PIETENPOL · S/N B402N9435NPiper PA-28R-200 · S/N 28R-35148N95MQShad Bell BABY LAKES · S/N SB001N9671UGrumman American Avn. AA-5A · S/N AA5A-0037N97896Stinson 108-1 · S/N 108-896
Back to Centerburg, OH