OpenAirDocs.org
Air Wisconsin Airlines LLC

Registered aircraft · 32

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'AIR WISCONSIN AIRLINES LLC' OR list_contains(g.other_registrant_names, 'AIR WISCONSIN AIRLINES LLC')
  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.

N405AWBombardier CL-600-2B19 · S/N 7362Built 1999 · Appleton, WIN408AWBombardier CL-600-2B19 · S/N 7568Built 2001 · Appleton, WIN410AWBombardier CL-600-2B19 · S/N 7490Built 2001 · Appleton, WIN412AWBombardier CL-600-2B19 · S/N 7582Built 2001 · Appleton, WIN413AWBombardier CL-600-2B19 · S/N 7585Built 2001 · Appleton, WIN414ZWBombardier CL-600-2B19 · S/N 7586Built 2001 · Appleton, WIN419AWBombardier CL-600-2B19 · S/N 7633Built 2002 · Appleton, WIN421ZWBombardier CL-600-2B19 · S/N 7346Built 1999 · Appleton, WIN423AWBombardier CL-600-2B19 · S/N 7636Built 2002 · Appleton, WIN424AWBombardier CL-600-2B19 · S/N 7656Built 2002 · Appleton, WIN427ZWBombardier CL-600-2B19 · S/N 7685Built 2002 · Appleton, WIN430AWBombardier CL-600-2B19 · S/N 7719Built 2002 · Appleton, WIN431AWBombardier CL-600-2B19 · S/N 7256Built 1998 · Appleton, WIN432AWBombardier CL-600-2B19 · S/N 7257Built 1998 · Appleton, WIN433AWBombardier CL-600-2B19 · S/N 7289Built 1999 · Appleton, WIN434AWBombardier CL-600-2B19 · S/N 7322Built 1999 · Appleton, WIN436AWBombardier CL-600-2B19 · S/N 7734Built 2002 · Appleton, WIN440AWBombardier CL-600-2B19 · S/N 7766Built 2003 · Appleton, WIN442AWBombardier CL-600-2B19 · S/N 7778Built 2003 · Appleton, WIN443AWBombardier CL-600-2B19 · S/N 7781Built 2003 · Appleton, WIN445AWBombardier CL-600-2B19 · S/N 7804Built 2003 · Appleton, WIN446AWBombardier CL-600-2B19 · S/N 7806Built 2003 · Appleton, WIN447AWBombardier CL-600-2B19 · S/N 7812Built 2003 · Appleton, WIN448AWBombardier CL-600-2B19 · S/N 7814Built 2003 · Appleton, WIN449AWBombardier CL-600-2B19 · S/N 7818Built 2003 · Appleton, WIN450AWBombardier CL-600-2B19 · S/N 7823Built 2003 · Appleton, WIN451AWBombardier CL-600-2B19 · S/N 7832Built 2003 · Appleton, WIN453AWBombardier CL-600-2B19 · S/N 7838Built 2003 · Appleton, WIN454AWBombardier CL-600-2B19 · S/N 7842Built 2003 · Appleton, WIN462AWBombardier CL-600-2B19 · S/N 7875Built 2003 · Appleton, WIN466AWBombardier CL-600-2B19 · S/N 7899Appleton, WIN468AWBombardier CL-600-2B19 · S/N 7916Appleton, WI
Back to Air Wisconsin Airlines LLC