OpenAirDocs.org
Sheboygan, WI

Cancelled registrations · 33

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

N718CSStenson Chad R AVID FLYER AEROBAT · S/N 309Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Stenson Chad RN428MDUnited Consultants UC-1 · S/N UC3-R362Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1967 · Vollrath Andrew JacksonN701DWBeech A23A · S/N M-977Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1966 · White RichardN923CPCessna 421C · S/N 421C1009Cancelled Apr 22, 2015 · Exported to Canada · Built 1980 · Sheboygan Chevrolet Buick Gmc CadillacN57175Aero Commander 690 · S/N 11004Cancelled Apr 8, 2014 · Exported to Canada · Built 1972 · Aero-Metric IncN43833Taylorcraft BC12-D · S/N 7492Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1946 · Anderson Douglas FN448DMGulfstream American AA-5B · S/N AA5B0976Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1978 · Holtrop David PN3208CBeech E35 · S/N D-3867Cancelled Dec 21, 2011 · Third renewal notice · Built 1954 · Damrow CharlesN1503CBalloon Works FIREFLY 7 · S/N 11126Cancelled Jun 1, 2011 · Registration pending, canceled · Built 1982N11743Cessna 150L · S/N 15075607Cancelled Jul 15, 2010 · Exported to Canada · Built 1974 · Van Sluys TroyN1223SCirrus Design SR22 · S/N 0105Cancelled Nov 27, 2007 · Triennial form not returned · Built 2001 · Miller Communication Center LLCN88MDPiper/Waage Donald PA 18 · S/N 18-01001Cancelled Mar 26, 2002 · Waage Donald AN46EExtra Flugzeugbau EA 300/L · S/N 062Cancelled Nov 1, 2001 · Exported to Philippines · Built 1998 · Brotz Frank GN5734TCessna 172E · S/N 17251634Cancelled Mar 2, 1995 · Exported to Chile · Kohler Terry JN83MTBell 206A · S/N 355Cancelled Dec 9, 1991 · Exported to Chile · Terryair Chile IncN111CDEnstrom Helicopter 280C · S/N 1035Cancelled Aug 31, 1990 · Triennial form not returned · Kohler Terry JN8668EStits SA3B · S/N P-27.2Cancelled Jan 12, 1971 · Earl SkeltonN78085Globe GC-1B · S/N 2085Cancelled Oct 13, 1970 · William J SchmittN3738KGlobe GC-1B · S/N 1431Cancelled Aug 21, 1969 · Skyhaven Aircraft SalesN48248Taylorcraft DCO-65 · S/N L5347Cancelled Jun 23, 1969 · Pippert Pierre WN9959RBeech B95 · S/N TD-399Cancelled May 4, 1966 · Stiles CompanyN445BBeech 35 · S/N D-1461Cancelled Nov 19, 1958 · Schmitt William JN69781Fairchild M-62C · S/N HO 174Cancelled May 23, 1955 · Brotz Wilbur AntonN91157North American NAVION · S/N NAV453Cancelled Mar 18, 1954 · Cardenas Valentin ON421MStinson SM-8A · S/N 4012Cancelled Oct 16, 1940 · Built 1930 · Schmitt William JN1775Swallow SWALLOW · S/N 862Cancelled Jul 15, 1939 · Built 1927 · Frank ArthurN12519Corben Sportplane CORBEN B · S/N 11Cancelled May 17, 1936 · Clarence J HermannN5338Fred W Mohr MOHR MONOPLANE · S/N 1Cancelled Sep 11, 1934 · Jansen Loyal EdwardN6643Pheasant H-10 · S/N 129Cancelled Jun 24, 1934 · Messrs Norbert SchmitzN1581Curtiss CANUCK · S/N 2000Cancelled Feb 11, 1933 · Built 1926 · Zuelke BenN2546Standard J-1 · S/N 1868Cancelled Feb 10, 1933 · Graefe Robert FN4900Waco GXE · S/N 1455Cancelled Sep 21, 1931 · Sheboygan Airways IncN967Standard J-1 · S/N 133Cancelled Mar 20, 1930 · Built 1918 · Eisenman Ben
Back to Sheboygan, WI