Hamersville, OH
Registered aircraft · 19
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 = 'HAMERSVILLE' 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 = 'HAMERSVILLE' 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.
N209TACostruzioni Aeronautiche Tecna P92 ECHO CLASSIC · S/N 1303N235KPoberezny Paul H POBER JR ACE · S/N 2N241RFFranke Roland STOL CH 701 · S/N 7-3172N2823ACessna 180 · S/N 30023N29988Waco UPF-7 · S/N 5485N320CKKlemp Gregory J SR CHALLENGER 1 · S/N 01990716N3635CCessna 180 · S/N 31133N6172TCessna 150E · S/N 15060872N653SMTrice Dick CHRISTIAN EAGLE II · S/N TRICE 0001N669CBCessna 180J · S/N 18052725N6841HPiper J3C-65 · S/N 20065N7622KPiper PA-20 · S/N 20-440N771BCCessna 310Q · S/N 310Q0601N8290CPiper PA-20-135 · S/N 20-1119N83439Aeronca 7AC · S/N 7AC-2106N8627ABeech E18S · S/N BA-283N86FHRobinson Helicopter R22 BETA · S/N 1861N9095ULiming Louis L HPL-1 HIGH WING-PARA · S/N HPL-1N927CMMckinney Charles A-26 VULCAN · S/N SA-26-014
Back to Hamersville, OH