OpenAirDocs.org
Indianapolis, IN

Cancelled registrations · 559

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

N6149LAmerican AA-1 · S/N AA1-0349Cancelled Apr 13, 2024 · Registration pending, canceled · Built 1970N845BDJI PHANTOM 2 · S/N PH646015536Cancelled Jul 4, 2023 · Butler Fairman & Seufert IncN8208KStinson 108-1 · S/N 108-1208Cancelled May 20, 2023 · Revoked, canceled · Built 1946 · Brown Fred AN8580JCessna 150G · S/N 15066480Cancelled May 2, 2023 · Sale reported, canceledN166JWRobinson Helicopter R66 · S/N 0341Cancelled May 1, 2023 · Exported to Canada · Built 2013 · Rotor Leasing LLCN95492Phoenix Powered Parachutes LIBERTY · S/N N-0575Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Oesterle William SN4605XCessna 150G · S/N 15064655Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1966 · Raplap Flying LLCN674LWPrecision Drone PACESETTER · S/N DB000229Cancelled Feb 1, 2023 · Registration expired, pending cancellation · Weihe Engineers IncN771YHDJI PHANTOM 2 · S/N PT645424561Cancelled Jan 21, 2023 · Registration expired · Hokanson Companies IncN911MWBuckeye BREEZE LX · S/N 16366Cancelled Dec 8, 2022 · Registration expired, pending cancellation · Built 2003 · Wheatcraft Michael LN48MSAero Commander 685 · S/N 12065Cancelled Nov 7, 2022 · Expired dealer · Built 1977 · Eagle Creek Aviation Services IncN113MGLet BLANIK L-13 · S/N 026053Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1974 · Henry Airplane LLCN208CLRockwell International 690A · S/N 11297Cancelled Nov 5, 2022 · Expired dealer · Built 1975 · Eagle Creek Aviation Services IncN853LDiamond Aircraft Ind DA 40 NG · S/N 40.NC055Cancelled Jun 10, 2022 · Built 2019 · Lift Aircraft LLCN4DDDiehl KR-2 · S/N 001Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Freeman Myron DN2920QPiper PA-32R-300 · S/N 32R-7780266Cancelled Feb 24, 2022 · Registration expired, pending cancellation · Built 1977 · Indy Lance LLCN27605Piper PA-31-325 · S/N 31-7812077Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Jmk Development LLCN833HCAero Commander 690A · S/N 11150Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1974 · Eagle Creek Aviation Services IncN623NPGulfstream American G-1159A · S/N 357Cancelled Apr 13, 2021 · Non-citizen corporation, flight hours not reported · Built 1982 · European Skybus IncN690ATRockwell International 690A · S/N 11202Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1974 · Eagle Creek Aviation Services IncN7509QHyam Robert TEENIE TWO · S/N 510089Cancelled Mar 27, 2021 · Registration expired · Built 1996 · Hofmann Michael DN24CCRockwell Commander 690A · S/N 11201Cancelled Mar 26, 2021 · Exported to Canada · Built 1974 · Eagle Creek Aviation Services IncN1345LMartin Larry R MARTIN LM-701 · S/N LM001Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2006 · Andrews Kevin MN817UNDJI INSPIRE 1 · S/N W18DD125070502Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Nelson Scott RN27161Gulfstream American AA-5A · S/N AA5A0886Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Kuhns Peter JN311ELGulfstream Aerospace G-IV · S/N 1095Cancelled Sep 22, 2020 · Sale reported · Built 1989N840JKGulfstream AM Corp Comm Div 690C · S/N 11697Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1981 · Eagle Creek Aviation Services IncN817TSDJI PHANTOM 4 · S/N 07DDD2MV103771Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Nelson Scott RN2104GCessna 182A · S/N 51404Cancelled Apr 10, 2020 · Revoked, canceled · Built 1958 · Scharo AviationN7345HPiper J3C-65 · S/N 20605Cancelled Feb 21, 2020 · Revoked, canceled · Built 1946 · Campbell Robert FN790QZDJI PHANTOM 3 ADVANCED · S/N P76DCG14010583Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Zeta Tau AlphaN48141Fairchild M-62A · S/N T437029Cancelled Dec 30, 2019 · Revoked, canceled · Built 1943 · Associated Flyers IncN34501Aeronca 65-LB · S/N L15081Cancelled Nov 25, 2019 · Revoked, canceled · Built 1941 · Dean Ted RN1974EAeronca 7AC · S/N 7AC5541Cancelled Oct 18, 2019 · Revoked, canceled · Built 1946 · M And N ClubN721HADJI INSPIRE 1 PRO · S/N W21ACI16011518Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Austin Matthew RN722ZADJI INSPIRE 1 · S/N W13DCC28030392Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Austin Matthew RN9675HFairchild M-62A · S/N T434384Cancelled Sep 6, 2019 · Revoked, canceled · Built 1943 · Circle Equip Co IncN81860Aeronca 7AC · S/N 7AC-483Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Shank William CN5075RCessna 172M · S/N 17263313Cancelled Jul 3, 2019 · Exported to Philippines · Built 1974 · American Aircraft & Marine LLCN7141YPiper PA-30 · S/N 30-163Cancelled May 6, 2019 · Revoked, canceled · Built 1963 · Indianapolis Morris Plan CorpN930AXDJI PHANTOM 2 VISION + · S/N PH645487995Cancelled May 6, 2019 · Registration expired, pending cancellation · Axis Surveying LLCN962CBAeronavics SKYJIB 8 · S/N HFAS00126Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Camerabee LLCN963CBSky-Hero SPYDER 700 · S/N HFASH0120Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Camerabee LLCN964CBBlade 350QX · S/N HFAQ3501Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Camerabee LLCN965CBFreefly Systems ALTA · S/N 855316Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Camerabee LLCN826WTDJI PHANTOM 3 PROFESSION · S/N P76DCD13011626Cancelled Feb 27, 2019 · Registration expired, pending cancellation · Shelnutt RonaldN21071Aeronca KCA · S/N KCA43Cancelled Feb 8, 2019 · Revoked, pending cancellation · Built 1938 · Hiatt MauriceN2108Brantly B-2 · S/N 154Cancelled Feb 8, 2019 · Revoked, pending cancellation · Built 1961 · Shank IndustriesN9496Whittemore WHITTEMORE-01 · S/N 001Cancelled Jan 28, 2019 · Revoked, canceled · Whittemore James RN46039Aeronca 0-58B · S/N 058B12233Cancelled Jan 24, 2019 · Revoked, canceled · Built 1943 · Schatz Robert C
Back to Indianapolis, IN