De Pere, WI
Registered aircraft · 33
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 = 'DE PERE' 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 = 'DE PERE' 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.
N115KTCommander 114TC · S/N 20044N1335CPiper PA-22-135 · S/N 22-1136N2270HErcoupe 415-C · S/N 2895N234MWCessna 310I · S/N 310I0034N2367TNavion NAVION G · S/N NAV-4-2367N237ECessna C-165 · S/N 554N2485HEngineering & Research 415-C · S/N 3110N2522NReichwald Brian T BH MARATHON · S/N HD05146MN280JHHalbrook Jim RANS S6S · S/N 12051716N2856ARoot Gary W HATZ CLASSIC · S/N 007N2934MPiper PA-12 · S/N 12-1447N30639Cessna 177B · S/N 17701375N32310Rearwin 175 · S/N 1519N3288ACessna 170B · S/N 25932N3727BBeech 77 · S/N WA-133N388TDDehavilland DHC-1 CHIPMUNK · S/N CI-0730N442MManoucher Adli VIRUS SW · S/N 791 SWN 100N4464HPiper PA-15 · S/N 15-252N47ACAero Commander 500 S · S/N 3200N5549VBuckeye BREEZE · S/N 16833N55783Piper PA-28-180 · S/N 28-7305467N569AJCirrus Design SF50 · S/N 0770N5725HPiper PA-16 · S/N 16-337N58RXEvolution REV X · S/N X1003N613ELCirrus Design SR20 · S/N 10666N6897YPiper PA-23-250 · S/N 27-4250N76324Cessna 120 · S/N 10738N797SSOtto Loren H SONEX · S/N 919N79MRCessna TR182 · S/N R18201271N8241DBeech J35 · S/N D-5343N9084BChampion 7FC · S/N 7FC-167N9106JPiper PA-28-180 · S/N 28-3148N93691Ercoupe 415-C · S/N 1014Registration pending
Back to De Pere, WI