OpenAirDocs.org
Champaign, IL

Cancelled registrations · 50

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 = 'IL' AND d.registrant_city = 'CHAMPAIGN'
  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.

N7227YPiper PA-30 · S/N 30-250Cancelled Mar 1, 2025 · Registration pending, canceled · Built 1964N6338HDJI PHANTOM 3 PROFESSION · S/N P76DCE20017497Cancelled May 2, 2019 · Registration expired, pending cancellation · Hoemann Darrell HN9416Page B-8M · S/N 127Cancelled Mar 23, 2018 · Revoked, canceled · Built 1968 · Birt Bobby LN1721WBeech V35B · S/N D-9401Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1972 · Nogle And Black Aviation IncN6409BCessna T210M · S/N 21062760Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1978 · Precision Investments IncN5789BBLY Donald F SONERAI 2LT · S/N 1Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1998 · Dressler Martin FN13WBeech S35 · S/N D-7888Cancelled Dec 4, 2017 · Built 1965 · Nogle And Black Aviation IncN46TWPiper PA 46-350P · S/N 4622071Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Buerkett JonN555HZSpannaus Harry A CHLNGR II CLP WNG SP · S/N CH20998-CW1787Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1998 · Tcheng David KN95CRSayers Donald G CLASSIC ROSE · S/N CO22QCancelled May 22, 2017 · Registration expired, pending cancellation · Built 1995 · Leger James LN23FTRaven S55A · S/N S55A-678Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Tomato Express IncN86775Bellanca 14-13-2 · S/N 1136Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Frasca Thomas WN1988KCameron Balloons US N-77 · S/N 5253Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Muehling Martha MN71088Thunder Balloons AX7-77A · S/N 085Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1977 · Ho Hum IncN29STKlemm-Roger RUTAN VARI-EZE · S/N 820Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1979 · Klemm Roger CN1916JFleming 1916 SE-5A REPLICA · S/N 1Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1979 · Frasca Air Museum IncN85572Aeronca 7AC · S/N 7AC-4314Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Goldstein William MN74792Mooney M20B · S/N 1810Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Scheffing Glenn JN13GSmith MINIPLANE · S/N DSA-13Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1963 · Oneil Kevin AN4668DBeech G35 · S/N D-4858Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1956 · Neely AntwuanN22FTPiccard AX-6 · S/N 740Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1974 · Flying Tomato IncN84AARaven S-50A · S/N S50A-244Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1974N95344Taylorcraft BF · S/N 9744Cancelled Feb 26, 2013 · Revoked, canceled · Built 1946 · Mcpherson Kenneth RandolphN2406ZPiccard AX-6 · S/N 406Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1976 · Spirit Of Champaign Balloon CoN310KACessna 310D · S/N 39144Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1960 · Frasca Thomas WN5628MTaylorcraft BF · S/N 12029Cancelled Aug 27, 2012 · Revoked, canceled · Built 1948 · Waterless Cooking Utensil CoN1517MBalloon Works FIREFLY 7 · S/N 11082Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1981 · Schmidt Martin AN13768Piper PA-23-250 · S/N 27-4418Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Built 1969 · Burr J GarrieN5038QCessna 310N · S/N 310N-0138Cancelled Jun 26, 2000 · Wynja James TN15103Balloon Works FIREFLY 7-B · S/N F7B016Cancelled Jun 2, 1998 · Triennial form not returned · Reineke David CN3960PPiper PA-22-150 · S/N 223638Cancelled Oct 10, 1996 · Triennial form not returned · Schwenk John FN5490TPiper PA-28-180 · S/N 287205265Cancelled Jul 13, 1994 · Exported to Chile · Atkins Robert AN5702RRaven S55A · S/N S55A582Cancelled Apr 14, 1993 · Triennial form not returned · Central Sts Communications Svc IncN40466Balloon Works FIREFLY 7 · S/N 7901Cancelled Feb 17, 1993 · Wooge Glen SN9437PPiper PA-24-260 · S/N 24-4945Cancelled Oct 7, 1982 · Administratively canceled · G & R Farms IncN6237WPiper PA-28-140 · S/N 28-20279Cancelled May 7, 1981 · Birt Bobby LN93403Ercoupe 415-C · S/N 726Cancelled May 19, 1977 · Built 1946 · Andrew Frank W / Andrew Paul WN8574EChampion 7FC · S/N 362Cancelled Sep 3, 1970 · Built 1957 · Vortex Generating Co IncN1934EAeronca 7AC · S/N 7AC-5501Cancelled Dec 12, 1968 · Built 1946 · Adamson Dolores JN88WTemco D-16 · S/N NAV4-520 TTN-2Cancelled Sep 22, 1965 · Henderson Horace LN29800Taylorcraft BC12-65 · S/N 2648Cancelled May 25, 1965 · Champaign Flying ClubN45940Luscombe 8A · S/N 2467Cancelled Sep 19, 1964 · H Burton Shepard JrN549BOakland Airmotive SUPER V · S/N SV105D1567Cancelled Aug 26, 1964 · Built 1948 · Astro IncN51213Fairchild PT-19A · S/N T42-3627Cancelled Nov 21, 1962 · Built 1942 · Wheatley R CN6402ACessna 182 · S/N 33202Cancelled Oct 17, 1961 · Dever Hearing CoN72117Cessna 140 · S/N 9284Cancelled Feb 20, 1956 · Chanute Flying ClubN89707Cessna 140 · S/N 8756Cancelled Oct 24, 1955 · Flying Six Club IncN78197Globe GC-1B · S/N 2197Cancelled Jun 2, 1955 · Built 1946 · Drabik Robert FN234HFleet 2 · S/N 102Cancelled Aug 6, 1943 · Swallen Don C/O Champaign Aviation CoN774KWaco GXE · S/N 2058Cancelled May 16, 1931 · Alex Tate
Back to Champaign, IL