OpenAirDocs.org
Marion, IN

Cancelled registrations · 51

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

N2684Bowers Fly Baby 1A-BIS · S/N CW-1Cancelled Sep 20, 2019 · Sale reported, canceledN96974Cessna 182Q · S/N 18266920Cancelled Jun 20, 2019 · Built 1979 · Johnson Dale FN2298KKirkpatrick 5151 JIM · S/N 31827Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Jones Christopher SN111BSShinn Beveridge JBS3 · S/N 1006Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1988 · Hiller William FN447WHHiller William HILLER MONI · S/N 502Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 2003 · Hiller William FN4723LPiper PA-28-180 · S/N 28-4045Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1967 · R A M Services IncN582WWHiller William STARLET · S/N 501Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2001 · Hiller William FN8606YBuckeye Industries DREAM MACHINE · S/N 4892Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 2000 · Emmons Tracy MN58RGlobe GC-1A · S/N 130Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1946 · Hiller William FN27841Enyeart Robert D HUMMER B · S/N 0224BCancelled Mar 26, 2013 · Sale reported, canceledN39961Taylorcraft BC12-D · S/N 6620Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1945 · Hiller WilliamN1112RAmateur Built BIPLANE · S/N WR-1Cancelled May 24, 2012 · Registration pending, canceled · Built 1967N223CDCirrus Design SR20 · S/N 1110Cancelled Feb 25, 2012 · Built 2000 · Marion Pilots Club IncN6160KCessna 150M · S/N 15077561Cancelled Sep 16, 2008 · Triennial form not returned · Built 1975 · Marion Steel Fabrication IncN96HAPiper PA-28-181 · S/N 2843061Cancelled Aug 28, 2008 · Triennial form not returned · Built 1996 · Stick And Rudder IncN247JCSchaefer John MONI · S/N 304Cancelled Feb 23, 2006 · Triennial form not returned · Built 1989 · Hiller WilliamN104GALearjet 24 · S/N 112Cancelled Apr 11, 2000 · Exported to Mexico · Cvs Systems IncN4156RPiper PA-32S-300 · S/N 32S40471Cancelled Mar 12, 1996 · Triennial form not returned · Bakane Ramesh BN834APiper PA-22 · S/N 22134Cancelled Mar 6, 1996 · Purdy Dwight EN4832PPurdy Dwight RALLY 3 · S/N 25490Cancelled Sep 14, 1993 · Deshong Rodney AN4933Pietenpol GN-1 · S/N GN-1-135Cancelled Aug 11, 1983 · Lehman George JN5378UCessna U206 · S/N U20605259Cancelled Feb 4, 1980 · Exported to Bolivia · World Gospel MissionN6295JPiper PA-28-151 · S/N 28-7615359Cancelled Feb 1, 1980 · Flying Assoc IncN7410ACessna 172 · S/N 29510Cancelled Sep 16, 1976 · Grasshopper Flying Club IncN3578APiper PA-22-135 · S/N 22-1853Cancelled Jun 25, 1975 · Walsh Boyd AN9435EAeronca 11AC · S/N 11AC-1072Cancelled May 3, 1974 · Palmer George ON29026General G1-80 · S/N 13Cancelled Sep 21, 1970 · Forrest Franklin HardinN2022ZCessna 150C · S/N 15059822Cancelled Jul 13, 1970 · Mc Quiston G RN4741QCessna A185E · S/N 185-1195Cancelled May 8, 1967 · Exported to Bolivia · World Gospel MissionN183TPiper PA-18 105 · S/N 18-2297Cancelled Nov 24, 1965 · Exported to Canada · Stick & Rudder Flying IncN68196Cessna T-50 · S/N 4302Cancelled May 21, 1965 · Bouslog M Bryant JrN3810PPiper PA-22-150 · S/N 22-3499Cancelled May 20, 1965 · Paul L KindschiN1971PPiper PA-18A · S/N 18-4205Cancelled Aug 3, 1962 · Exported to Canada · Aerial Crop Aids IncN5283PPiper PA-24 · S/N 24-322Cancelled Nov 19, 1958 · Robinson GlenN84308Aeronca 7AC · S/N 7AC-3003Cancelled Feb 23, 1956 · L & S Flying Association IncN3875EAeronca 11AC · S/N 11AC-S73Cancelled Nov 18, 1955 · Built 1947 · Marion Flying Service IncN4327EAeronca 7BCM · S/N 7BCM-528Cancelled Nov 17, 1955 · Marion Flying Service IncN63956Fairchild M-62C(PT-23A) · S/N 4733AECancelled Oct 24, 1955 · Mansfield David Walter Applewhite And Max SmallN63961Fairchild M-62C(PT-23A) · S/N 338HOCancelled Oct 24, 1955 · Edington William L & Marion LawsonN69882Consolidated Vultee BT-13A · S/N 9085Cancelled Oct 14, 1955 · B & M Aero Service IncN57837Cessna T-50 · S/N 5854Cancelled Oct 11, 1955 · Bouslog Bryant MN9671HConsolidated Vultee SNV-1 · S/N 6280Cancelled Oct 5, 1955 · B & M Aero Service IncN4348MPiper PA-12 · S/N 12-3286Cancelled Apr 28, 1954 · Morris Roy JrN2040EAeronca 7AC · S/N 7AC-5610Cancelled Apr 22, 1953 · Buchananjack GN2558MPiper PA-12 · S/N 12-1041Cancelled Jan 16, 1952 · B & M Aero Service IncN4146EAeronca 11CC · S/N 11CC-54Cancelled Nov 30, 1951 · Built 1947 · Marion Flying Service IncN49574Piper J3C-65 · S/N 10273Cancelled Aug 1, 1951 · Arthur S ParkerN30131Waco UPF-7 · S/N 5528Cancelled Sep 16, 1949 · Built 1940 · Haisley Oil CompanyN34445Aeronca 65-LB · S/N LB14631Cancelled Sep 21, 1948 · Built 1941 · Marion Aviation Club IncN36711Stinson 10A · S/N 8111Cancelled Sep 7, 1948 · Built 1941 · Garrison Charles L
Back to Marion, IN