Appleton, WI
Registered aircraft · 123
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 = 'APPLETON' 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 = 'APPLETON' 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.
N423AWBombardier CL-600-2B19 · S/N 7636N424AWBombardier CL-600-2B19 · S/N 7656N427ZWBombardier CL-600-2B19 · S/N 7685N430AWBombardier CL-600-2B19 · S/N 7719N431AWBombardier CL-600-2B19 · S/N 7256N432AWBombardier CL-600-2B19 · S/N 7257N433AWBombardier CL-600-2B19 · S/N 7289N434AWBombardier CL-600-2B19 · S/N 7322N436AWBombardier CL-600-2B19 · S/N 7734N440AWBombardier CL-600-2B19 · S/N 7766N44223Laszlo Arthur SR CELESTE · S/N CH 207920864N4429APiper PA-22-150 · S/N 22-3758N442AWBombardier CL-600-2B19 · S/N 7778N443AWBombardier CL-600-2B19 · S/N 7781N445AWBombardier CL-600-2B19 · S/N 7804N446AWBombardier CL-600-2B19 · S/N 7806N447AWBombardier CL-600-2B19 · S/N 7812N44819Piper PA-28-151 · S/N 287515041N448AWBombardier CL-600-2B19 · S/N 7814N449AWBombardier CL-600-2B19 · S/N 7818N450AWBombardier CL-600-2B19 · S/N 7823N451AWBombardier CL-600-2B19 · S/N 7832N453AWBombardier CL-600-2B19 · S/N 7838N454AWBombardier CL-600-2B19 · S/N 7842N462AWBombardier CL-600-2B19 · S/N 7875N466AWBombardier CL-600-2B19 · S/N 7899N468AWBombardier CL-600-2B19 · S/N 7916N4802LPiper PA-28-180 · S/N 28-4141N4830PVans RV-12 · S/N 12024N499CTFlight Design CTSW · S/N 07-03-09N5001YHead Balloons AX8-105 · S/N 478N50726Aeronca 0-58B · S/N 058B-4392N5072JCessna 310R · S/N 310R0804N50TDPiper PA-30 · S/N 30-827N513YZCirrus Design SR22T · S/N 9349N517JCPiper PA-28-140 · S/N 28-7125098N540ACBellanca 7ECA · S/N 1206-77N5483FAlon A-2A · S/N B-283N5617WPiper PA-28-160 · S/N 28-758N609MGGremminger Greg W MAGNI M-16 · S/N 16-00-1124N6102KRepublic RC-3 · S/N 285N624MCRuss Ronald A RV-9A · S/N 90579N69BYAmerican Champion 7GCBC · S/N 1411-2006N69HWHussey-Waddell DA-2A · S/N 69N717JSBeech 35-C33 · S/N CD-965N72475Cessna 140 · S/N 9643N732ACEmbraer-Empresa Brasileira De EMB-505 · S/N 50500070N7493WPiper PA-28-180 · S/N 28-2900N749LBArbc Inc DBA Lindstrand 77A · S/N 5477N79575Cessna 172K · S/N 17258188
Back to Appleton, WI