Hillsboro, OH
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 = 'OH' AND g.registrant_city = 'HILLSBORO' 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 = 'HILLSBORO' 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.
N105BBeech G35 · S/N D-4399N2066RKoonts Craig ROTORWAY EXEC 162F · S/N 6645N217HBBell Homer K ROTOWAY EXEC · S/N 1240N2769FCessna 182J · S/N 18256869N28326Compton Williamson ROTOR WAY EXEC · S/N 3006N2870BBell 47G-2 · S/N 1975N2940UCessna 172D · S/N 17250540N3111FCessna 182J · S/N 18257211N355RKDahlman Francis G BEDE BD-4 · S/N 140N38660Piper J5A · S/N 5-1049N43AJGordon Andrew J SCORPION 152 · S/N 11152N480PBJeff Brawley CHALLENGER II · S/N CH2-1293-1066N48613Grumman Acft ENG Cor-Schweizer G-164A · S/N 1682N50807Davis Verble RAF DAVIS · S/N 01N568FDDJI INSPIRE 1 · S/N W13DCC23020803N5JCCorcoran James BUSHBY MUSTANG-II · S/N 518N635VFDJI INSPIRE 1 · S/N W13DCH19040193N6538QAlon A2 · S/N A-138N762STLoban Grant SCORPION 162F · S/N 0001First renewal noticeN85802Aeronca 11AC · S/N 11AC-211N8750BCessna 172 · S/N 36450N8795KUniversal Stinson 108-1 · S/N 108-1795N8908BCessna 172 · S/N 36708N93CFFarmer J C/Farmer E COZY MK-IV · S/N MK0052N94887Ercoupe G · S/N 5015
Back to Hillsboro, OH