Skip to content

Bloomington, IN

Cancelled registrations · 70

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

N40027Adams Balloon Loft A50S · S/N 402Cancelled Dec 27, 2025 · Registration pending, canceled · Built 2024 N902LRAndrew Philip Richardson SOLO SYSTEM ACE · S/N 003Cancelled Dec 27, 2025 · Registration pending, canceled · Built 2021 N826Glasflugel STD LIBELLE 201B · S/N 438Cancelled Dec 7, 2024 · Sale reported, canceled · Built 1973 N8438BPiper PA-28-236 · S/N 28-8211002Cancelled Oct 29, 2024 · Built 1981 · Cr Aviation LLC N97630Cessna 182Q · S/N 18267151Cancelled Aug 31, 2024 · Registration pending, canceled · Built 1979 N919QAAdams Balloons EGG · S/N 325Cancelled Oct 26, 2023 · Adams Balloons LLC N7003XAvian Balloons TURBO 8 · S/N 127Cancelled Sep 6, 2023 · Bloomington Balloon Rides LLC N693ET3D Robotics X8-M · S/N 0031002ACancelled Oct 1, 2022 · Registration expired, pending cancellation · Indiana University N6816RDJI PHANTOM 2 · S/N PH646014113Cancelled Aug 29, 2022 · Registration expired · Root & Associates LLC N6119YCameron Balloons US 0-105 · S/N 5997Cancelled Mar 4, 2022 · Built 1995 · Bloomington Balloon Rides LLC N252WFMooney M20K · S/N 25-1189Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Meadows Robert E N4446NBoeing A75 · S/N 75-6771Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1942 · Stearman Partners LLC N642YTDJI S1000+ · S/N 03P0010658Cancelled May 6, 2019 · Registration expired, pending cancellation · Indiana University N590YJDJI INSPIRE 1 · S/N W13DCD16030607Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Indiana University N1058SColumbia Aircraft Mfg LC41-550FG · S/N 41722Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Gibbons William S Jr N16943Piper J-2 · S/N 809Cancelled May 11, 2018 · Revoked, pending cancellation · Built 1936 · Williamson Charles R N113LLLime Lite Balloons BARCHETTA 60 · S/N 002Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Lime Lite Balloons LLC N119LLLime Lite Balloons BARCHETTA 60 · S/N 004Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Limelite Balloons LLC N818EDLime Lite Balloons LL69 · S/N 005Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Lime Lite Balloons LLC N114LLLimelite Balloons LL52 · S/N 001Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Limelite Balloons LLC N115LLLime Lite Balloons LL69 · S/N 003Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Lime Lite Balloons LLC N700FFPiper AEROSTAR 601P · S/N 61P06337963290Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1979 · Amt Inc N221TECameron Balloons V-56 · S/N 455Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1980 · Richardson Andy P N851DDDillon Donald D BASKET IM ENV 28K · S/N D001Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1991 · Oliver William M N125RBCameron Balloons U S N 120 · S/N 6306Cancelled May 24, 2013 · Exported to Canada · Built 2002 · Richardson Andrew P N6525TCessna 150 · S/N 17925Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1960 · Bmg Aviation Inc N3433WPiper PA-32-260 · S/N 32-295Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1966 · Freeman Robert C N1513PBalloon Works FIREFLY 7-B · S/N F7B-038Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1982 · Clark Charles Dean N4843KNavion NAVION A · S/N NAV-4-1843Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1949 N31AVAvian Balloon FALCON II · S/N 63Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1979 · Donnelly Shanon P N7300FPiper PA-28-140 · S/N 28-25188Cancelled Sep 5, 2012 · Registration pending, canceled N139LBAero Vodochody L-39 · S/N 630638Cancelled Sep 4, 2012 · Exported to Australia · Built 1976 · Bmg Aviation Inc N70025Avian Balloon FALCON II · S/N 116Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1983 N4809BCessna 152 · S/N 15283649Cancelled Jun 13, 2012 · Registration pending, canceled · Built 1979 N62181Fantasy Sky Promotions FANTASY EIGHT · S/N 081Cancelled Apr 6, 2012 · Built 1996 · Smith Warren D N168LBLindstrand Balloons 69A · S/N 5137Cancelled Mar 5, 2012 · Built 2000 · Smith Warren D N2465BCessna 182S · S/N 18280887Cancelled Apr 12, 2010 · Exported to Australia · Built 2000 · Lawrence James B N9149UCessna 150M · S/N 15078100Cancelled Sep 15, 2009 · Registration revoked · Built 1976 · Airborne Services Inc N1091TPiper PA-28-140 · S/N 28-25543Cancelled Jun 25, 2009 · Registration revoked · Built 1969 · Gillaspy Don E N961PDRobinson Helicopter R44 · S/N 1519Cancelled Aug 12, 2008 · Exported to Lithuania · Built 2005 · Pinnacle Air Services III Inc N1231GCirrus Design SR20 · S/N 1141Cancelled May 20, 2005 · Exported to Germany · Built 2001 · Balla Matthew N4130YCameron Balloons US N-105 · S/N 5727Cancelled Nov 15, 2004 · Triennial form not returned · Built 1991 · Oliver William M N6689LLake LA-4-200 · S/N 452Cancelled Apr 12, 2001 · Exported to Canada · Patton Barratt M N4272PRaven S55A · S/N S55A980Cancelled Feb 23, 1994 · Vencel Travis J N9012AAdams Balloon A50S · S/N 014Cancelled Feb 15, 1994 · Triennial form not returned · Oliver Wine Inc N49609Bell 206B · S/N 1784Cancelled Mar 4, 1993 · Exported to Canada · Rogers Group Inc N7404BCameron Balloons N-105 · S/N 5111Cancelled Feb 14, 1992 · Triennial form not returned · Oliver William W N8736MBeech 23 · S/N M525Cancelled Mar 25, 1991 · Triennial form not returned · Coppersmith Steven M N49KTCessna 210 · S/N 57127Cancelled May 24, 1983 · Mcleish Margaret E N10412Cessna 177B · S/N 17702322Cancelled Sep 11, 1982 · Administratively canceled · Torp Aero Service Inc

Back to Bloomington, IN