Wausau, WI
Registered aircraft · 75
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 = 'WAUSAU' 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 = 'WAUSAU' 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.
N111SVNord STAMPE SV4C · S/N 1063N11454Cessna 150L · S/N 15075434N120PGCessna 120 · S/N 11978N12997Cessna 172M · S/N 17262437N13558Cessna 172M · S/N 17262847N1796PPiper PA-22-150 · S/N 22-2569N201AGMooney M20J · S/N 24-0405N21YKYakovlev YAK 52 · S/N 9211609/01N2287HEngineering & Research ERCOUPE 415-C · S/N 2912N22KKDehavilland BEAVER DHC-2 MK.1 · S/N 1600N240HYAirbus Helicopters Deutschland EC135 P3 · S/N 2170N2420EAeronca 7AC · S/N 7AC-5999N246ECCessna T210M · S/N 21062435N247NCDJI AGRAS T50 · S/N 1581F6BUB248U001DS61N28245Piper J5A · S/N 5-164N28550Grumman American Avn. AA-5B · S/N AA5B0673N2926HErcoupe 415-C · S/N 3551N32011Waco UPF-7 · S/N 5642N3235DBeech A36 · S/N E-2935N3310TCessna 177 · S/N 17700045N3363YCessna 210N · S/N 21063145N34707Cessna 177B · S/N 17701946N34LLMooney M20J · S/N 24-0047N35366Piper J3C-65 · S/N 6333N362ABPiper PA-32R-301T · S/N 32R-8029068N3685PBalloon Works FIREFLY 7 · S/N F7-072N3728MPiper PA-12 · S/N 12-2668N373RFFairchild Ralph B CHALLENGER II · S/N CH2-0203-2298N3ULWetzel Robert 601HD · S/N W001N40888Piper J5A · S/N 5-1198N42KKTextron 525 · S/N 525-1401N4323QCessna 172L · S/N 17260223N4373YPiper PA-12 · S/N 12-1440N4375HPiper PA-15 · S/N 15-160N4422FHarmening High Flyer EXECUTIVE · S/N 006078N454WLLearn Buid Fly WITTMAN LEGACY · S/N 001N4583HMooney M20J · S/N 24-0852N47738Piper PA-28R-201 · S/N 28R-7837003N490SCSix Chuter West LEGEND XL · S/N 3171N495MKNorth American SNJ-4 · S/N 88-13132N499DCConrad David J TAILWIND W10C · S/N 02.1219N505XBell Textron Canada 505 · S/N 65622N50DCConrad David J HATZ BIPLANE · S/N 282N514AGDJI AGRAS T40 · S/N 64TBKBC002004NN517AGDJI AGRAS T100 · S/N 1581F8ZLC25B90029096N5230NCessna 182Q · S/N 18267586N52455Aerostar International RX-7 · S/N RX7-3340N525FLPiper PA-28-140 · S/N 28-7125357N5297VAerostar International S-51A · S/N S51A-3018N53040Boeing A75N1(PT17) · S/N 75-799
Back to Wausau, WI