OpenAirDocs.org
Carmel, IN

Cancelled registrations · 44

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 = 'IN' AND d.registrant_city = 'CARMEL'
  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.

N919CXKubicek Factory S R O BB34D · S/N 2354Cancelled May 16, 2025 · Exported to Mexico · Built 2024 · Balloon The Nations LLCN191RRKubicek Factory S R O BB92Z · S/N 2167Cancelled Apr 28, 2025 · Exported to Mexico · Built 2023N225WPCompagnie Daher TBM 700 · S/N 1362Cancelled Dec 12, 2022 · Exported to Canada · Sugar Skies Aviation LLCN913CXKubicek Factory S R O BB26AZ · S/N 1920Cancelled Nov 22, 2022 · Exported to Mexico · Balloon The Nations LLCN7675MDJI PHANTOM 3 PROFESSION · S/N P76DCE22016801Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Miller Anthony DN3253HDillon-Stits Skycoupe SA-7D · S/N P-550Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Poliak Mark A TrusteeN2764HEngineering & Research ERCOUPE 415-C · S/N 3389Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1946 · Poliak Mark A TrusteeN49456Cessna 152 · S/N 15281282Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Hanson Daniel JN592JADJI S1000+ · S/N 01R0045776Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Osprey Assessments LLCN715BKNational Ballooning 858 · S/N 159Cancelled Nov 29, 2018 · Registration pending, canceled · Built 2007N212ZFVans RV-12 · S/N 120136Cancelled Mar 26, 2018 · First renewal notice · Built 2011 · Levine Norman BN1703Cirrus Design SR22T · S/N 0806Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 2014 · Weaver Aircraft LLCN762YZPegasus QUANTUM SUPERSPORT · S/N 7621Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 2000 · March Keith LN630BCCarr William B SONEX · S/N 0630Cancelled Oct 18, 2016 · First renewal notice · Built 2007 · Carr William BN1777ECessna T310R · S/N 310R1569Cancelled Jan 4, 2016 · Built 1979 · M & C Aviation Services LLCN88RRReimer-Stewart SONERAI II · S/N 013Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1978 · Reimer Ronald FN6RRStasenka-Mataya STARDUSTER SA 300 · S/N 367Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1972 · Reimer Ronald FN65393Aerostar International RX-7 · S/N RX7-3139Cancelled Nov 6, 2014 · First renewal notice · Built 1987 · Hoffbauer Glen N JrN54CWMaxted Charles JAVELIN WICHAWK · S/N 178Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1982 · Turner Steven RN87EFFolkening ED SHADOW · S/N 2Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1987 · Folkening EdN230SCCooper Scott T SHADOW · S/N 1Cancelled May 9, 2013 · Sale reported, canceledN214RAShort Terry G RUTAN SOLITAIRE · S/N TS7763204Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1987 · Cass MalcolmN4051SBalloon Works FIREFLY 7 · S/N 7948Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1979 · Wright Edwad BN2395JBeech 23 · S/N M-362Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1963 · C & S Agency IncN1301RCessna 182P · S/N 18264867Cancelled Jul 9, 2012 · Sale reported, canceled · Built 1976N19CBCessna T337G · S/N P3370019Cancelled Jul 29, 2009 · Registration revoked · Built 1972 · Stogsdill Willis WN52470Boeing A75N1(PT17) · S/N 75-4722Cancelled Jan 13, 2009 · Triennial form not returned · Built 1943 · Hawk Robert HN149CExtra Flugzeugbau EA300/200 · S/N 08Cancelled Aug 6, 2008 · Exported to France · Built 1997 · Tracy Douglas SN4054LBalloon Works FIREFLY 7 · S/N 10098Cancelled Jan 12, 2006 · Triennial form not returned · Built 1980 · Marten Christopher MN8017DRobinson Helicopter R22 BETA · S/N 1009Cancelled Mar 15, 2001 · Triennial form not returned · Wright Aivation CorporationN50AVAvian Balloon SKYHAWK · S/N 50Cancelled Jan 11, 2001 · Skypoint IncN70027Avian Balloons TURBO 8 · S/N 117Cancelled Jan 11, 2001 · Skypoint IncN337JCCessna M337B · S/N 337M0137Cancelled Apr 5, 1996 · Exported to Australia · Gem Aviation IncN2CLPiper PA-28R-200 · S/N 28R7335045Cancelled Feb 10, 1992 · Triennial form not returned · Henson Keith AN9645TCessna 210 · S/N 57445Cancelled Feb 4, 1992 · Triennial form not returned · Acumen Investors CorporationN60AVAvian Balloon FALCON II · S/N 18Cancelled May 16, 1991 · Second triennial mailing, no response · Mercer Dennis AN3769APiper PA-22-135 · S/N 22-2011Cancelled Dec 17, 1974 · Exported to Canada · Built 1954 · Fitzgerald William V JrN192PFairchild M-62A · S/N T43-5031Cancelled Nov 22, 1974 · Hoftiezer Allen LN22ECPiper PA-28-140 · S/N 28-7225179Cancelled Apr 24, 1974 · Health Service Associates CorpN20957Waco ARE · S/N 5083Cancelled Nov 22, 1972 · Built 1940 · Meeks Billy GN35133Skyway SKYWAY AC-35 · S/N 350001Cancelled Jul 29, 1968 · Skyway Engineering Co IncN109YSkycopter C-165 · S/N 1259001Cancelled Oct 5, 1962 · Skyway Engineering Co IncN3820BBeech 35 · S/N D-4085Cancelled Mar 25, 1959 · Reeder & Kline Machine Co IncN51504Piper J3C-65 · S/N 9827Cancelled Nov 15, 1955 · Shugart Mark
Back to Carmel, IN