Neenah, WI
Registered aircraft · 50
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 = 'NEENAH' 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 = 'NEENAH' 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.
N100HMCessna 340A · S/N 340A-0559N10574Cessna 150L · S/N 15074916N14LKKellner Ken J LANCAIR IV-P · S/N LIV-496N14PVCessna 172S · S/N 172S9528N2306QBeech 23 · S/N M-358N2490WPeterson Andrew P TIERRA · S/N 001N251KBeech E18S · S/N BA-170N257KPDennis Philip Jennings HOT AIR BALLOON AX 8 · S/N D9001N262DLDouglas Osterberg DOLANCAIR IVP · S/N 433N2881QCessna 172L · S/N 17259881N291FCChenevert Frank O JR CHRISTEN EAGLE II · S/N CHENEVERT 0001N292REPiper PA-30 · S/N 30-768N3157YRobinson Helicopter R44 II · S/N 12053N3373UCessna 182 · S/N 18254773N3530VCessna 140 · S/N 14799N39933Taylorcraft BC12-D · S/N 6586N4181BBellanca 17-30A · S/N 75-30770N5084ACessna 172 · S/N 28084N541WPCirrus Design SR22 · S/N 1931N54YXHildebrandt Colin R WAIEX-B · S/N WXB0061N551XThomas N Helm SONEX ONEX · S/N ONX0137N56204Piper PA-28-180 · S/N 28-7305552N6059JLindstrand Balloons 90A · S/N 5156N6216SCessna 150G · S/N 15067016N629LFCirrus Design SR22 · S/N 2189N6370YPiper PA-23-250 · S/N 27-3645N64985Cessna 152 · S/N 15281512N66780Cessna 150M · S/N 15076273N6687VBellanca 17-30 · S/N 30029N6689UMooney M20C · S/N 2416N6704ACessna 172 · S/N 28804N7087HPiper J3C-65 · S/N 20337N7323HPiper J3C-65 · S/N 20583N7346JPiper PA-28-140 · S/N 28-24620N7415XCessna 172B · S/N 17247915N758SFCessna R172K · S/N R1723318N7777BTextron 700 · S/N 700-0129N8180LCessna 172H · S/N 17256380N822GGCirrus Design SR22T · S/N 8554N8308BCessna 172 · S/N 36108N84295Aeronca 7AC · S/N 7AC-2989N8555JCessna 150G · S/N 15066455N861BZPowrachute AIRWOLF 912 ULS · S/N A323VIKN87086Ercoupe 415-C · S/N 259N8712SCessna 150F · S/N 15062012N87771Piper J3C-65 · S/N 15429N8802Bellanca 7GCBC · S/N 492-73N92084Piper J3C-65 · S/N 16517N925BWCessna 560XL · S/N 560-5507N93395Ercoupe 415-C · S/N 718
Back to Neenah, WI