Skip to content

Bloomington, IL

Cancelled registrations · 65

Query with SQL

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 = 'BLOOMINGTON' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'BLOOMINGTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N880LKDoornbos Keith A MONNETT MONI · S/N 365Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1997 · Doornbos Keith A N157SFCessna 172S · S/N 172S11265Cancelled Aug 11, 2022 · Registration expired, pending cancellation · Built 2013 · Jad-Akd LLC N3098VBeech 35 · S/N D-516Cancelled Jun 26, 2020 · Revoked, canceled · Built 1947 · Haarman Donald W N30998Piper J4A · S/N 41273Cancelled Jun 12, 2020 · Revoked, canceled · Built 1940 · Mclean Co Avia Booster Club N34624Stinson 10A · S/N 8024Cancelled Nov 25, 2019 · Revoked, canceled · Built 1941 · Mccreedy James E N770GGDJI MATRICE 100 · S/N P77DCD2Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Growmark Inc N637RJDJI PHANTOM 2 VISION + · S/N PH645440710Cancelled May 3, 2019 · Registration expired, pending cancellation · Finch James M DBA N624NJDJI PHANTOM 3 PROFESSION · S/N P76DCH26A21010Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Finch Jim N64GNAerialtronics ALTURA ZENITH ATX8 · S/N 2490419Cancelled Feb 4, 2019 · Registration expired, pending cancellation · State Farm Mutual Automobile Insurance Co N35GNAerialtronics ALTURA ZENITH ATX8 · S/N 2490418Cancelled Jul 20, 2018 · Registration expired · State Farm Mutual Automobile Insurance Co N757MJCessna 152 · S/N 15279846Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Image Air Of Southwest Florida L C N485GNAltavian NOVA F6500 · S/N 3025Cancelled Jul 8, 2016 · State Farm Mutual Automobile Insurance Co N409AMDiamond Aircraft Ind DA20-C1 · S/N C0343Cancelled Jul 6, 2016 · Exported to Canada · Built 2005 · Image Air Of Southwest Florida Lc N8472APiper PA-32-301 · S/N 32-8206013Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1981 · Cross Winds Flying Club Inc N343HPiper PA-28-140 · S/N 28-20822Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Cutler James D N7646BTermite C-121 · S/N C-121Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1964 · Chestney James R N5881ZPiper PA-22-108 · S/N 22-9741Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1963 · Gaines Ralph E N9372Hiatt SCORPION TWO · S/N DCH-1Cancelled Mar 19, 2013 · Sale reported, canceled N470SRyan Aeronautical ST3KR · S/N 1400Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Rettick Enterprises Inc N35445Piper J-3 · S/N 6350Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1941 · Pannier Loren H N7734BPiper J3C-65 · S/N 12852Cancelled Aug 13, 2012 · Registration pending, canceled N30087Bensen B-8M · S/N SB8M-1Cancelled Feb 8, 2012 · Sale reported, pending cancellation · Built 1968 N12KABeech E-90 · S/N LW41Cancelled Oct 20, 2005 · Triennial form not returned · Built 1973 · Heritage Enterprises Inc N8173UPiper PA-32R-301 · S/N 32R-8013073Cancelled Nov 3, 2004 · Triennial form not returned · Built 1980 · Crosswinds Flying Club Inc N37627Steckler Stephen T TERN · S/N S.T.S. 1Cancelled Apr 16, 2003 · Triennial form not returned · Built 1981 · Prairie Aviation Museum N75238Piper PA-28-181 · S/N 28-7690315Cancelled Jan 7, 2002 · Triennial form not returned · Built 1976 · Hedmark Homer L N320ACCessna 320E · S/N 320E0097Cancelled Jan 29, 1998 · Triennial form not returned · Curry Alan C N4663XCessna TU206G · S/N U20605518Cancelled Dec 3, 1997 · Exported to Mexico · Eugene Martin Fams N6124PCessna 152 · S/N 15284979Cancelled Oct 22, 1996 · Triennial form not returned · Clark Aviation Inc N4362FPiper PA-46-310P · S/N 468408055Cancelled Jul 22, 1996 · Triennial form not returned · Bmi Enterprises N90875Piper PA-28-181 · S/N 288690015Cancelled Mar 12, 1996 · Triennial form not returned · S And R Aviation N175CBBurpee Charles M DUSTER BJ-1B · S/N 175Cancelled Feb 1, 1996 · Triennial form not returned · Burpee Charles M N302FWMooney M20J · S/N 241091Cancelled Dec 10, 1992 · Berner Louis A Jr N8205VPiper PA-28RT-201T · S/N 28R8231049Cancelled Dec 11, 1991 · Exported to Canada · Mid-America Aviation Inc N42908Piper J3C-65 · S/N 15243Cancelled Oct 11, 1991 · Exported to France · Built 1948 · Mid America Aviation Inc N3065YPiper PA-28-181 · S/N 287990391Cancelled Jun 18, 1991 · Exported to France · Mid-America Aviation Inc N25923Cessna 152 · S/N 15280860Cancelled May 21, 1991 · Exported to France N736GFCessna R182 · S/N R18200728Cancelled May 21, 1991 · Exported to France · Mid-America Aviation Inc N9143ZPiper PA-34-220T · S/N 3433123Cancelled May 13, 1991 · Exported to Germany · Mid America Aviation Inc N22244Piper PA-28-181 · S/N 287990073Cancelled Dec 5, 1990 · Exported to France · Mid-America Aviation Inc N39958Piper PA-28-181 · S/N 287990023Cancelled Dec 3, 1990 · Exported to France · Mid America Aviation Inc N33742Piper PA-34-200T · S/N 34-7570158Cancelled Mar 11, 1983 · Exported to Canada · Clark Aviation Inc N4700EAero Commander 680FL · S/N 1779148Cancelled Mar 30, 1981 · Pawson James R N1934TPiper PA-28-140 · S/N 28-7125482Cancelled Mar 13, 1981 · Built 1971 · Cross Winds Flying Club Inc N3480WPiper PA-32-260 · S/N 32-357Cancelled Jun 21, 1979 · Exported to Canada · Built 1966 · Don Welcome Sales & Service N35RSSpry EXPERIMENTAL TEENIE · S/N 21715Cancelled Aug 30, 1976 · Spry Robert H& Spry Thomas C N6081LAmerican AA-5 · S/N AA5-0181Cancelled Jun 26, 1974 · Exported to Canada · Bloomington Aviation Inc N7623NBeech V35A · S/N D-8852Cancelled Nov 15, 1973 · Houck Gleah H N8422GCessna 150 · S/N 15062522Cancelled Oct 17, 1972 · Exported to Canada · Built 1966 · Clark Aviation Inc N802BLuscombe 8F · S/N 6732Cancelled Mar 6, 1972 · Built 1951 · Rhodus Rodger E

Back to Bloomington, IL