OpenAirDocs.org
Anderson, IN

Cancelled registrations · 88

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

N2006PPiper PA-23 · S/N 23-578Cancelled Apr 15, 2002 · Second triennial mailing, no response · Built 1956 · Keene Joseph BN2174LBeech V35B · S/N D-9929Cancelled Jul 2, 2001 · Whitaker JackN12852Cessna 208B · S/N 208B0469Cancelled Jan 26, 2001 · Exported to Canada · Anderson Aviation IncN8821VBellanca 17-30A · S/N 30345Cancelled Jul 24, 2000 · Jackson John RN404JHHinchman James R FISHER 404 CLASSIC · S/N CO68Cancelled Feb 16, 1994 · Exported to Germany · Hinchman James RN50249Calliari WM CAL 34 · S/N 0001Cancelled May 20, 1993 · Second triennial mailing, no response · Reed Jerry BN1183DKnowling Rodney T MITCHELL WING B-10 · S/N 311RK1Cancelled Apr 2, 1992 · Triennial form not returned · Knowling Rodney TN76168Cessna 140 · S/N 10565Cancelled Dec 17, 1981 · Built 1946 · Hancock FrankN9705XCessna 210B · S/N 21058005Cancelled Jan 25, 1977 · Pierce Industries IncN9353EAeronca 11AC · S/N 11AC-990Cancelled Apr 24, 1974 · Mabbitt Roy LN312EAero Commander 560 · S/N 560-185Cancelled Jun 11, 1973 · Exported to Brazil · Russell JamesN5853CBeech C35 · S/N D-2805Cancelled Oct 27, 1971 · Anderson Mattress CoN45811Luscombe 8A · S/N 2338Cancelled Jun 8, 1971 · James F WrightN54739Fairchild M-62A · S/N T42-1446Cancelled Sep 24, 1970 · Gibson MarlinN9583ACessna 170A · S/N 19144Cancelled May 21, 1965 · Fuller Paul MN2975HEngineering & Research ERCOUPE 415-C · S/N 3600Cancelled Feb 27, 1956 · Johnson Jesse JrN1357KLuscombe 8A · S/N 4084Cancelled Oct 4, 1955 · Ace Air ServiceN92342Piper J3C-65 · S/N 16797Cancelled Oct 24, 1951 · Darlington William ArthurN47499Piper J3C-65 · S/N 9879Cancelled Aug 1, 1951 · Flying Ravens ClubN28433Luscombe 8A · S/N 1300Cancelled Jul 31, 1951 · Built 1940 · Flying Ravens ClubN79031Consolidated Vultee BT-15 · S/N 9474Cancelled Mar 8, 1950 · Mcpherson Leland WN35978Piper J4E · S/N 4-1460Cancelled Oct 25, 1948 · Built 1941 · Teeters James LN585Pitcairn PA-6 · S/N 26Cancelled Jul 12, 1948 · Stanford N StraberN8382Curtiss-Robertson ROBIN · S/N 258Cancelled Apr 26, 1948 · Built 1929 · Lane John HN2358Curtiss Wright TRAVEL AIR 2000 · S/N 129Cancelled Mar 29, 1948 · Built 1928 · Walser Lovell DN8554Waco GXE · S/N 1892Cancelled Sep 11, 1941 · Duke GarlandN18248Welch OW6M · S/N 133Cancelled Mar 1, 1941 · Roy Lavern MabbittN15778Welch Orin WELCH OW-7M · S/N 113Cancelled Feb 1, 1940 · Built 1936 · Mabbitt LavernN953WAlbrecht ALBRECHT PARASOL GLI · S/N 3Cancelled May 1, 1939 · Albrecht James EN18392Welch Orin WELCH OW-7M · S/N 114Cancelled Oct 1, 1938 · Built 1937 · Welch GomerN415Orin Welch HIGH LIFT BIPLANE · S/N 105Cancelled Aug 8, 1934 · Exported to Canada · Built 1928 · Orin Welch Aircraft CoN817Orin Welch O W 1 · S/N 103Cancelled Aug 2, 1934 · Orin Welch Aircraft CoN1297Swallow SWALLOW · S/N 856Cancelled Feb 11, 1933 · Built 1927 · Orin Welch Aircraft CompanyN2897Waco 10 · S/N 778Cancelled Feb 11, 1933 · George L Roush & Orin WelchN157HStamps & Vertongen RSV 25-100 · S/N 150 SUBCancelled Dec 28, 1932 · Built 1929 · Wright-Tuttle Aircraft Motors CorpN8758Swallow TP · S/N 158Cancelled Sep 9, 1930 · Reynolds Myron BN1405Swallow SWALLOW · S/N AAC-50Cancelled Jul 23, 1929 · Built 1927 · Orin Welch Aircraft CoN5105Orin Welch O W 1 · S/N 101Cancelled Jun 6, 1929 · Orin Welch Aircraft Co
Back to Anderson, IN