Beach City, OH
Registered aircraft · 17
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 = 'BEACH CITY' 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 = 'BEACH CITY' 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.
N225HPGarrison Jerry CHRISTEN EAGLE II · S/N GAR01N2305PPiper PA-22-150 · S/N 22-2716N231NZMooney M20K · S/N 25-0336N23JWTaylorcraft 15A · S/N 5-14008N2805CCessna 170B · S/N 26348N399AVWilliam J Crone CCK-1865 · S/N CCK-1865-0098N4248LCessna 182N · S/N 18260226N43754Taylorcraft BC12-D · S/N 7413N4761MPiper PA-11 · S/N 11-355N50090Cessna 150H · S/N 15069057N5120TChampion 7ECA · S/N 479N6684ACessna 172 · S/N 28784N70383Piper PA-11 · S/N 17368N743BJJones Peter M BOEING/JONES 75 · S/N AR-41N750AMAndy Miller ZENITH CH750 STOL · S/N 75-7632N774RVCarr Bryan L RV-4 · S/N 2047N80786Globe GC-1B · S/N 189
Back to Beach City, OH