Chagrin Falls, 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 = 'CHAGRIN FALLS' 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 = 'CHAGRIN FALLS' 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.
N141CKCameron Balloons US ZL-70 · S/N 6565N2092WBeech V35 · S/N D-8044N220DSBeech D50C · S/N DH-271N2534WBeech B24R · S/N MC-214N2747YBeech 95 · S/N TD-96N327EDBeach Charles E RV-4 · S/N EB-102-2033N330LTExtra Flugzeugproduktions-Und EA 300/LT · S/N LT009N3335UCessna 182F · S/N 18254735N369CBCessna 182Q · S/N 182-66699N382BALearjet 45 · S/N 2119N4319XPiper PA-28-181 · S/N 28-7690002N52078Aerostar International RX 8 · S/N RX8-3322N52811Aerostar International S-45A · S/N S45A-3001N53836Bellanca 7ECA · S/N 1124-75N6314PPiper PA-24-180 · S/N 24-1424N6409SBeech V35B · S/N D-9838N672Cessna T-50 · S/N 5921N731TZVans RV-12 · S/N 120972N781FNBalony Kubicek Spol Sro BB22XR · S/N 962N781MEBalony Kubicek Spol Sro BB26Z · S/N 793N8292BCessna 172 · S/N 36092N83MKCirrus Design SF50 · S/N 0198N8657QBeech S35 · S/N D-7738N916SAeropro CZ S R O A240 · S/N 30810N9288WPiper PA-28-235 · S/N 28-10965
Back to Chagrin Falls, OH