Chippewa Falls, WI
Registered aircraft · 51
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 = 'WI' AND g.registrant_city = 'CHIPPEWA 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 = 'WI' AND g.registrant_city = 'CHIPPEWA 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.
N102THHaen Tom SMITH SUPER CUB · S/N 0568N170ASCessna 170A · S/N 19824N174RAAmerican Champion 7GCBC · S/N 1390-2005N18162Cessna 150L · S/N 15073834N181SGCessna 560 · S/N 560-0181N1901HPiper PA-28-161 · S/N 28-7716059N2014GBeech C24R · S/N MC-606N2035MPiper J3C-65 · S/N 20803N2050VCessna 140 · S/N 14263N21BCBeech A36TC · S/N EA-65N23148Cessna 150H · S/N 15068754N25080Simonar PIETENPOL · S/N 917N294DMDiamond Aircraft Ind DA 42 NG · S/N 42.N413N299GSSlattery Gordon C AVID MAGNUM · S/N 119MN31376Dehavilland DHC-1 · S/N DHB-580N324CVDJI AGRAS T50 · S/N 1581F6BUB248T001N3UPN32562Piper J3C-65 · S/N 5457N34WECessna T310R · S/N 310R1597N3578TTaylorcraft F19 · S/N F-044N3903FCessna 172 · S/N 36803N395DBBoll Don SONEX · S/N 0396N4366UCessna 150D · S/N 15060366N443QNEa Vision EA J100 · S/N 85614N4955TCessna TR182 · S/N R18201804N514EKWalter E Kelm RV-9A · S/N 90887N6071WPiper PA-28-140 · S/N 28-20083N61RFRon Fowler MUSTANG II · S/N M-II-1044N62984Bellanca 7GCBC · S/N 363-72N6299RCessna 150F · S/N 15061599N644CVDJI AGRAS T50 · S/N 63YBM4C0020072N65970Boeing A75N1(PT17) · S/N 75-4936N7059VMooney M20F · S/N 22-1401N7062PBellanca 7GCBC · S/N 419-73N70817Piper J3C-65 · S/N 17834N7084LPowrachute PEGASUS · S/N A044PEGN7135SSlattery Gordon C RED DEUCE · S/N GCS-YBBHN7197GCessna 172K · S/N 17258897N723CVDJI AGRAS T40 · S/N 1581F574B239600100K6N733CACessna 172N · S/N 17268181N7775SBellanca 8GCBC · S/N 227-76N7996BCessna 172 · S/N 29796N80855Cessna 172M · S/N 17266774N8268HPiper PA-28-181 · S/N 28-8190043N8283PPiper PA-24-250 · S/N 24-3535N87638Apland Douglas C TEDDY BEAR · S/N A001N878PRCessna 510 · S/N 510-0362N9230DPiper PA-22 · S/N 22-6290N9455WChallenger/Elwood II · S/N 2642N9644QCessna 172M · S/N 17265728N9845QPiper PA-18-135 · S/N 18-3550
Back to Chippewa Falls, WI