Indianola, IA
Registered aircraft · 79
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 = 'IA' AND g.registrant_city = 'INDIANOLA' 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 = 'IA' AND g.registrant_city = 'INDIANOLA' 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.
N134APApollo MONSOON · S/N 00018N14XRKubicek Factory S R O BB14XR · S/N 2649N16076Cameron Balloons US N-105 · S/N 5966N1870FCessna 210F · S/N 21058770N205DMooney M20J · S/N 24-3005N21961Firefly Balloons FIREFLY 7-15 · S/N F7-2039N2269SHead Balloons AX8-105 · S/N 361N2475TPiper PA-38-112 · S/N 38-78A0812N24WDCirrus Design SR22T · S/N 8717N25718Balloon Works FIREFLY 7B-15 · S/N F7B-349N2672EAeronca 7AC · S/N 7AC-6252N2881LCessna 172H · S/N 17256081N291YACessna 172 · S/N 28164N2974NPiper PA-28-181 · S/N 28-8090022N299ZZArbc Inc DBA Lindstrand 77X · S/N 5821N3038PAir Tractor AT-402B · S/N 402B-1284N3069WArbc Inc DBA Lindstrand 77X · S/N 5644N312LBLindstrand Balloons 77A · S/N 5255N31782National Ballooning 755-12 · S/N 55126N317SJKubicek Factory S R O BB26Z · S/N 2439N3181HNational Ballooning 858 · S/N 170N3181YNational Ballooning 858 · S/N 167N3182BNational Ballooning 858 · S/N 178N3182CNational Ballooning 858 · S/N 163N3183UNational Ballooning 858 · S/N 179N3186EAeronca 11AC · S/N 11AC-1528N324TSPiper PA-32-260 · S/N 32-841N3333BPiper PA-22 · S/N 22-2148N3466FCessna 182J · S/N 18257466N3574KPiper PA-28-181 · S/N 28-8090197N3580LRaven Industries RALLY RX7 · S/N RX7-3216N3736KPiper PA-28-140 · S/N 28-23713N405KCPiper PA-46-310P · S/N 46-8408044N4228YNational Ballooning 752-12 · S/N 0121N446LBArbc Inc DBA Lindstrand 60X · S/N 5474N465XArbc Inc DBA Lindstrand 65X · S/N 5637N4827LPiper PA-28-180 · S/N 28-4170N5016KHead Balloons AX7-70R · S/N 460N50777Cessna 150J · S/N 15069546N515XRBalony Kubicek Spol S R L BB16XR · S/N 1805N5205SPiper PA-32-300 · S/N 32-40894N5304UCameron Balloons US O-84 · S/N 6153N554SDBeech 95-B55 (T42A) · S/N TC-646N55884Piper PA-28-180 · S/N 28-7305491N56100Mooney M20J · S/N 24-1362N575BMDJI AGRAS T50 · S/N 1581F6BUB2492001GH2ZN5767HPiper PA-16 · S/N 16-381N5806Bryant Lyle W T-BIRD II · S/N 004836N58062Mooney M20J · S/N 24-1540N6027Air Tractor AT-602 · S/N 602-1275
Back to Indianola, IA