OpenAirDocs.org
Osceola, WI

Registered aircraft · 34

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 = 'OSCEOLA'
  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.

N120CFRochette Marc P18 REPLICA KIT · S/N TC0707018Built 2007 · Matts Cats LLCN149ACAmerican Champion 7EC · S/N 1032-2011Built 2001 · Osceola Aerosport LLCN1682YCessna 172C · S/N 17249382Built 1962 · Storby Steven RN1973CLet BLANIK L-13 · S/N 025725Built 1973 · Red Wing Soaring AssociationN1974CLet L-13 BLANIK · S/N 026032Built 1974 · Red Wing Soaring AssociationN251LADiamond Aircraft Ind DA 40 NG · S/N 40.NC191Built 2022 · Sr Aviation Holdings LLCN31CBCameron Balloons O-84 · S/N 0-84-149Built 1975 · Johnson Richard MN323SBLet L-23 SUPER BLANIK · S/N 917917Built 1991 · Red Wing Soaring AssocN323WDCirrus Design SR22 · S/N 2085Built 2006 · Durand Paul CN343DBBeech D-45 · S/N BG-317Built 1957 · Brown Patrick T TrusteeN35009Cessna 177B · S/N 17702155Built 1974 · Handrahan Sara J TrusteeN440TNNunnelee Burl KITFOX 4 · S/N 001Built 2013 · Stroik Robert JN50271Bellanca 8KCAB · S/N 572-79Built 1979 · Sawyer Johnson IncN52220Cessna 172P · S/N 17274444Built 1980 · Meyer Jeffrey KN55034Bellanca 8KCAB · S/N 420-78Built 1978 · Osceola Aerosport LLCN5601ACessna 172 · S/N 28201Built 1956 · Osceola Aerosport LLCN5762GGreat Lakes 2T-1A-2 · S/N 1003Built 1981 · Brown Patrick T TrusteeN58634Cessna 182P · S/N 18262191Built 1973 · Poutre Robert PN5VBBeech E-55 · S/N TE-1179Built 1980 · Custom Fire Apparatus IncN6311XCessna 340A · S/N 340A0482Built 1978 · Matts Cats LLCN6496JPiper PA-28-180 · S/N 28-4928Built 1968 · Budke Kris JN652RHCessna 172M · S/N 17266850Built 1976 · Twohy David SN6575ECessna 175 · S/N 56075Built 1959 · Poutre Robert PN7579EChampion 7FC · S/N 7FC-267Built 1958 · Strand Ronald GN7627SBellanca 7ECA · S/N 1163-76Built 1976 · Johnson Richard MN779RDAmerican Champion 7GCBC · S/N 1425-2007Built 2006 · Custom Fire Apparatus IncN79118Cessna 172K · S/N 17257893Built 1969 · Osceola Aerosport LLCN841RQCessna U206F · S/N U20603273Built 1976 · Mueller Steven LN85294Aeronca 7AC · S/N 7AC4032Built 1946 · Burch Daniel CN9265ZLaister Sailplane LP-15 · S/N 8Built 1976 · Kennedy Steven RN9599KChristen Industries A-1 · S/N 1111Built 1989 · Red Wing Soaring AssociationN97HPAviat A-1B · S/N NF0002Built 2003 · Poutre Robert Paul TrusteeN99591Ercoupe 415-C · S/N 2214Built 1946 · Olson Bruce IN999WHPilatus B-4 · S/N 162Red Wing Soaring Association
Back to Osceola, WI