Kenosha, WI

Cancelled registrations · 95

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'WI' AND d.registrant_city = 'KENOSHA'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N9358JPiper PA-28-180 · S/N 28-3457Cancelled Dec 2, 1992 · Kenosha Aero IncN97812Stinson 108-1 · S/N 108812Cancelled Jun 26, 1992N4909HCessna 152 · S/N 15284015Cancelled Mar 5, 1992 · Exported to Hungary · Kenosha Aero IncN6477PCessna 152 · S/N 15285024Cancelled Mar 5, 1992 · Exported to Hungary · Kenosha Aero IncN63BBeech E18S · S/N BA119Cancelled Oct 16, 1991 · Triennial form not returned · Northern Airmotive CorpN6338Republic F-84 · S/N 52-6370Cancelled Aug 1, 1984 · Gateway Technical InstituteN4779ECessna 172N · S/N 17271644Cancelled Apr 8, 1983 · Built 1978 · Kenosha Aero IncN48732Cessna 152 · S/N 15280941Cancelled Apr 8, 1983 · Built 1977 · Kenosha Aero IncN7486QCessna 182P · S/N 18261126Cancelled Nov 17, 1981 · Kenosha Aviation Service IncN24KBeech H-18 · S/N BA648Cancelled Oct 30, 1980 · Burl-Air Freight IncN16600Beech UC-45J · S/N 39749Cancelled Jun 24, 1980 · Gateway Technical InstituteN7190XCessna 150A · S/N 15059290Cancelled Sep 19, 1976 · Grieble Delmar F JrN899CStinson 108-3 · S/N 1083899Cancelled Apr 5, 1976 · Ozanne Ward RN3776NBeech 35 · S/N D-998Cancelled Jan 24, 1975 · Ladd Michael AN6847PPiper PA-24-250 · S/N 24-1981Cancelled Jan 15, 1975 · Kenosha Aircraft Sales And Leasing CorpN5179VBeech C-45H · S/N AF462Cancelled Mar 27, 1974 · K Airways IncN4670CCessna 170B · S/N 25614Cancelled Dec 10, 1973 · Lapoint GeraldN9733ACessna 170A · S/N 19194Cancelled Jun 25, 1973 · Exported to Canada · Built 1950 · Thompson Harold HN3030KCulver V · S/N 249Cancelled Feb 20, 1973 · Built 1946 · Kenosha Technical InstituteN2277YCessna 177 · S/N 17700077Cancelled Aug 3, 1972 · K Airways IncN45676Luscombe 8A · S/N 2203Cancelled Feb 2, 1972 · Built 1955 · Consultants IncN8139FCessna 402 · S/N 402-0233Cancelled Oct 29, 1971 · Built 1968 · K-Airways IncN5401Baker GYROCOPTER · S/N 397-22-4837Cancelled Jul 14, 1971 · Werner Donald CN9384VMooney M20C · S/N 700025Cancelled Apr 1, 1971 · Kenosha Aircraft Sales & LeasingN97766Stinson 108-1 · S/N 108766Cancelled Jan 25, 1971 · Duane J BienN3906JCessna 150G · S/N 150-65206Cancelled Oct 19, 1970 · K-Airways IncN63715Fairchild M-62C(PT-23A) · S/N 236Cancelled Sep 3, 1970 · Rose Paul FN4465VBeech 35 · S/N D-1281Cancelled Feb 12, 1969 · Borneman M GN36515Aeronca 65-CA · S/N C16041Cancelled Sep 13, 1968 · Phillips Jackson LN95940Taylorcraft BC12-D · S/N 8240Cancelled May 25, 1964 · Merril W GN47321Harlow S1B1 · S/N 160Cancelled Nov 29, 1951 · High Henry R Leonard J WallN4055MPiper PA-12 · S/N 12-2937Cancelled Apr 29, 1948 · Howe Gilbert LN5891Waco GXE · S/N 1546Cancelled Oct 3, 1947 · Foss HermanN6964Waco GXE · S/N 1701Cancelled Jul 15, 1941 · Joe Venson & Angelo VaccerelloN553Arrow Aircraft & Motors ARROW SPORT · S/N 307Cancelled Dec 18, 1940 · Rose James VincentN650NDavis D-1-K · S/N 507Cancelled Feb 12, 1939 · Built 1930 · Ragon Daniel MN242KAeromarine 39-B · S/N 13Cancelled Feb 9, 1933 · Spence James LN624VParks P-1 · S/N 1999Cancelled Dec 18, 1931 · Hansen Harold CN11860Curtiss Wright JR CW1 · S/N 1234Cancelled Oct 13, 1931 · Kenosha Aircraft CorpN5556Ryan B1 · S/N 121Cancelled Jan 30, 1931 · Kenosha Aircraft CorpN10030Caviezel E C SPORT · S/N 1Cancelled May 2, 1930 · Caviezel Ed JrN1903Aeromarine Plane & Motor EO · S/N 5079Cancelled Apr 29, 1930 · Built 1927 · Smith Hart GN1948Fischer Body STANDARD J1 · S/N 1Cancelled Apr 29, 1930 · Built 1927 · Smith Hart GN2190Standard J-1 · S/N 22684Cancelled Feb 14, 1930 · Built 1926 · Lacombe ClarenceN11493Aeronca C-3 · S/N A-163Cancellation date not recorded · Stahl Benjamin F Jr
Back to Kenosha, WI