Lake Village, IN
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 = 'IN' AND g.registrant_city = 'LAKE VILLAGE' 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 = 'IN' AND g.registrant_city = 'LAKE VILLAGE' 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.
N139PKBalony Kubicek Spol Sro BB22E · S/N 1301N22054Firefly Balloons FIREFLY 7-15 · S/N F7-2038N235WEPiper PA-25-235 · S/N 25-7556108N2413TPiper PA-28-180 · S/N 28-7205053N2500EPiper PA-38-112 · S/N 38-78A0474N315HFAndrew P Richardson RICHARDSON 69 · S/N 009N3888CCessna 180 · S/N 31036N4425YBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3820N4678PPiper PA-23-250 · S/N 27-207N4880VBellanca 17-30 · S/N 30122N4932ZPiper PA-22-108 · S/N 22-8524N6135VBeech S35 · S/N D-7787N7416YBalloon Works FIREFLY 8B · S/N F8B-084N88245Bellanca 7GCBC · S/N 747-74N8845Bellanca 7KCAB · S/N 365-73N92335Cessna 182N · S/N 18260158N9236CPiper PA-28R-201 · S/N 28R-7837181N97MTStemme S10-V · S/N 14-042MN999WRSchempp-Hirth K.G. JANUS C · S/N 8
Back to Lake Village, IN