Hutchinson, KS
Registered aircraft · 35
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 = 'KS' AND g.registrant_city = 'HUTCHINSON' 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 = 'KS' AND g.registrant_city = 'HUTCHINSON' 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.
N1181WBell 47G-3B-1 · S/N 2948N1424APiper PA-22 · S/N 22-338N147HCBell 47G-3B-2 · S/N 6790N2011NCessna 140 · S/N 12247N2082YBeazley BRIEGLEB BG12BD · S/N 202Registration pendingN20NAGrumman American Avn. AA-5B · S/N AA5B-0560N22980Cessna 150H · S/N 15068656N22DZApplebay Sailplanes ZUNI · S/N 4N2503QEllis Ben R SKY RANGER · S/N SK 3001N265SPAerosport IKARUS C42 FB80 · S/N 0512-6779N294DPDustin D Petz RANS S-21 · S/N 01190038N3304TGlasflugel H 301 LIBELLE · S/N 13N371RSCessna 172G · S/N 17254229N38JSSinclair BJ-1B DUSTER · S/N 003N420JBeech F33A · S/N CE-894N42577Cessna 182L · S/N 18259088N45486Silvaire LUSCOMBE 8E · S/N 2013N46108Taylorcraft DCO-65 · S/N 5151N467NCInfinity Power Parachutes COMMANDER 582 · S/N IPP 12-405N470FTXag P150 · S/N 1863FPEG82235023J90RN614JSHart Larry T RANS 6ES COYOTE II · S/N 06051671N65406Powrachute PC 2000 · S/N A-292POWN6858HCessna 172M · S/N 17265612N75479Infinity Power Parachutes C-912S · S/N IPP8-365N7614KPiper PA-20 · S/N 20-430N78266Cessna 172K · S/N 17257549N825SCTl-Ultralight S R O TL 2000 STING S4 · S/N 15 ST 434N8264BCessna 172 · S/N 36064N859GSApplebay Sailplanes ZUNI · S/N 13N89256Cessna 140 · S/N 8280N92639Cessna 182N · S/N 18260292N9297ZBuckeye DREAM MACHINE · S/N 3692N954DBBarbour Danny KITFOX IV · S/N ICU 102N957JLSchultz Robert H WITTMAN W-10 · S/N RHS-1N98277Piper J3C-65 · S/N 18451
Back to Hutchinson, KS