Registered aircraft · 18

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'STURGEON BAY' ORDER BY g.n_number

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 = 'STURGEON BAY'
  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 = 'STURGEON BAY'
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.

N1HTConsolidated Aeronautics LAKE LA-4-200 · S/N 1104Built 1984 · Allen Adrian Jefrey N207BAIcon A5 · S/N 00156Built 2022 · Czerwonka Thomas W N23MWPartenavia P68 · S/N 151Built 1978 · Northeast Wisconsin Aero LLC N248TDCostruzioni Aeronautiche Tecna P2010 TDI · S/N 148/USBuilt 2021 · Jak Aviation LLC N35870Piper J3C-65 · S/N 6628Cub Time LLC N3640GCessna 310R · S/N 310R0880Built 1977 · Tailwind Flight Center - Sue LLC N5083FAeropro CZ EUROFOX · S/N 18206Built 2006 · Bauer Thomas G N5642TMaule MXT-7-180A · S/N 21049CBuilt 1998 · Mark C Petersen N57ASCompagnie Daher TBM 700 · S/N 1535Built 2024 · Ttx Air LLC N612TXPilatus PC-12/47E · S/N 1353Built 2012 · Ttx Air LLC N618BSSpencer A Cosner 269A TH55A · S/N 7Built 2018 · Bauer Thomas G N619TXCirrus Design SR22T · S/N 1459Built 2016 · Ttx Air LLC N6556SCessna 150H · S/N 15067356Built 1967 · Pflederer Raymond F N6606DCessna 172N · S/N 17272893Registration pendingBuilt 1979 N7243XBeech A36 · S/N E-2335Built 1986 · C&S Manufacturing Corporation N7363WPiper PA-28-180 · S/N 28-1243Built 1963 · Burke David L N906VTMichaud David M RANS COYOTE S6S · S/N 01081849---8Built 2009 · Michaud David M N9315NPiper PA-28R-200 · S/N 28R-35015Diir County Flying Inc

Back to Sturgeon Bay, WI