OpenAirDocs.org
Racine, WI

Cancelled registrations · 60

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

N702RCRamon A Centeno SONEX · S/N 1318Cancelled May 15, 2023 · Sale reported, canceled · Built 2016N5817PPiper PA-24-250 · S/N 24-897Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1959 · Fleischmann Fred SN135JLasalle Robert J CHALLENGER II · S/N CH2-0101-W-2043Cancelled Jul 22, 2021 · Built 2001 · Lasalle Robert JN3510QCessna 172M · S/N 17261656Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1973 · Snamiske George JN505CJJohnson S Curtis QUICKSILVER · S/N 0243Cancelled Jul 13, 2017 · First renewal notice · Johnson S CurtisN35BJBeech C35 · S/N D-2848Cancelled Jun 23, 2017 · Registration expired, pending cancellation · Built 1951 · N35bjN1572JPiper PA-28-140 · S/N 28-23978Cancelled Jan 4, 2017 · First renewal notice · Built 1967 · Blue Moon Aviation LLCN484RCCoss Robert A AVID STOL · S/N 484Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1991 · Coss Robert AN838BWWolff W W HUMMEL BIRD · S/N 3531-PCancelled Aug 29, 2013 · Sale reported, canceled · Built 2008N3276QKunath Gabor Berges TURNER T 40A · S/N 192T40ACancelled Jun 6, 2013 · Registration expired, pending cancellation · Gabor Claudia AN38057Born Again Restorations BAR/CURTISS JN-4D · S/N B-010Cancelled May 9, 2013 · Sale reported, canceled · Built 2001N757DXCessna 152 · S/N 15279667Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Gensler William DBAN4381KJerde John M MAXAIR DRIFTER XP503 · S/N 4290Cancelled Mar 19, 2013 · Sale reported, canceledN2944PPiper PA-22-150 · S/N 22-3213Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1955 · Weeks Vaughan BN30LSBossart Byron MONI · S/N PL490Cancelled Feb 11, 2013 · Sale reported, canceledN4743JBeech A23A · S/N M-1018Cancelled Sep 20, 2012 · Revoked, canceled · Built 1967 · Suburban Aviation Equipment IncN203SSBalonismo Me Ricardo Dealmeida SS-30-0S · S/N 200376Cancelled Aug 21, 2012 · Registration pending, canceledN40LFFarnsworth Lemoyne E ACRO II · S/N 3Cancelled Jun 19, 2008 · Sale reported · Built 1985N912BHHyatt Robert G JR AVID FLYER · S/N 1253DCancelled Oct 7, 2005 · Exported to Canada · Built 1992 · Hyatt Robert G JrN5039SPiper PA-28R-200 · S/N 28R-35773Cancelled Nov 10, 2004 · Triennial form not returned · Built 1970 · Versa Air-I LLCN2359CCessna R182 · S/N R18200160Cancelled May 20, 2004 · Triennial form not returned · Built 1978 · Fleischmann Air IncN557RFFeulner Robert C KITFOX II · S/N 557Cancelled Sep 21, 2000 · Sale reportedN5590MGovernment Aircraft Factories N22B · S/N N22B83Cancelled Aug 26, 1995 · Triennial form not returned · S C Johnson & Son IncN911DPPflugrad Daniel G KR-2DP · S/N 071987Cancelled Dec 19, 1994 · Triennial form not returned · Pflugrad Daniel GN1845TPiper PA-28-140 · S/N 28-7125278Cancelled Jul 3, 1984 · Administratively canceled · Cramer Robert JN8415TCessna 182B · S/N 52315Cancelled Feb 22, 1984 · Administratively canceled · C Air IncN1598UCessna 172M · S/N 17267177Cancelled Nov 23, 1983 · Administratively canceled · Gensler William DBAN60181Beech C24R · S/N MC-648Cancelled Jul 22, 1983 · Exported to Germany · Glatzel H DavidN3038KSuperior CULVER V · S/N V-257Cancelled Jul 11, 1977 · Hansen Erle SN21534Cessna 182P · S/N 18261696Cancelled Aug 29, 1975 · Skylane Of Racine IncN8670BCessna 172 · S/N 36370Cancelled Apr 9, 1973 · Exported to Canada · Built 1958 · Air Trades IncN7569UWnuk Ronald S-10 · S/N 101Cancelled Jun 30, 1970 · Deweese Joh AN9905HConsolidated Vultee BT-13A · S/N 7253Cancelled May 27, 1969 · Elmo Norval HalversonN6269ZPiper PA-25 · S/N 25334Cancelled Feb 13, 1969 · Built 1960 · American States IncN71560Luscombe 8A · S/N 2987Cancelled May 22, 1965 · Johnson Donald J & Gay StewartN77138Cessna 140 · S/N 11596Cancelled May 22, 1965 · Anderson ArvidN39926Taylorcraft BC12-D · S/N 6579Cancelled May 20, 1965 · Built 1945 · Morgan William JN50077Boeing A75N1 · S/N 75-987Cancelled May 20, 1965 · Built 1940 · American States IncN79560Boeing B75N1 · S/N 757980Cancelled May 20, 1965 · American States IncN9911HBoeing B75N1 · S/N 75-7307Cancelled May 20, 1965 · American States IncN19003Poberezny Paul H LITTLE POOPDECK · S/N 1Cancelled Apr 16, 1965 · Chambasian Sam Et AlN99302Erco 415-C · S/N 1925Cancelled Jul 19, 1960 · Exported to Canada · Michael SalvanoN1408HAeronca 15AC · S/N 15AC-460Cancelled Jul 22, 1958 · Exported to Canada · Hay Manufacturing CoN69787Consolidated Vultee BT-13A · S/N 6222Cancelled Mar 1, 1956 · Bode AlfredN55187Consolidated Vultee BT-13A · S/N 5510Cancelled Nov 30, 1955 · Morrow Cole HN97347Stinson 108 · S/N 108-347Cancelled Nov 25, 1955 · Built 1946 · Racine Flying Service IncN50460Taylorcraft DCO-65 · S/N L4617Cancelled Nov 21, 1955 · Klyzub Carl MN69796Consolidated Vultee BT-13A · S/N 9553Cancelled Oct 25, 1955 · Burks Don RN70006Consolidated Vultee BT-13A · S/N 6989Cancelled Oct 12, 1955 · Eugene KlabacksN3130ACessna 170 · S/N 25774Cancelled Jul 11, 1955 · Mitzen Frank
Back to Racine, WI