OpenAirDocs.org
Worthington, OH

Cancelled registrations · 29

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 = 'OH' AND d.registrant_city = 'WORTHINGTON'
  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.

N13159Cessna 180K · S/N 18053166Cancelled Apr 10, 2024 · Built 1980 · N13159 LLCN222CPPiper PA-23-160 · S/N 23-1940Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1960 · Eagle Support Services LLCN3010SCameron Balloons US N-90 · S/N 6048Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1996 · Re/Max Of Central OhioN9181VAerostar International RAVEN S57-A · S/N S57A-3155Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1994 · Re/Max Of Central Ohio IncN4209BHelio H-391B · S/N 013Cancelled Jul 26, 2013 · Revoked, pending cancellation · Built 1955 · Worthington Aeronautical CorpN1120RRaven S-50A · S/N S50A-267Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1976 · Turley Gail DN3226GGolden Age Acft EHW-2 · S/N 8682-1Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Golden Age Aircraft Co IncN439BRRussell Robert SIDEWINDER · S/N 1BRCancelled Jun 13, 2013 · Registration expired, pending cancellation · Russell RobertN117KHSwift S1 · S/N 117Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1994 · Hadden KenN8028SKosar Robert D HP-18 · S/N 41Cancelled May 13, 2013 · Registration expired, pending cancellation · Kosar Robert DN83PTKrejchik Daniel PIETENPOL · S/N 1-4-HCancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1983 · Farkas JosephN87736Hiller OH-23G · S/N 63-12851Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1963N2319LBeech 23 · S/N M-145Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1963 · Ducatte GeraldN1247FBalloon Works FIREFLY 7 · S/N 146Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1974 · Kovach Meredith WN80718Cessna 172M · S/N 17266713Cancelled May 4, 2010 · Exported to Canada · Built 1976 · Mediatore Richard EN24PGPiper PA-34-220T · S/N 34-8433059Cancelled Jan 7, 2003 · Exported to Canada · Built 1984 · Tech Air IncN81148Hiller UH-12E · S/N 1552Cancelled Jul 7, 1999 · Triennial form not returned · Ohio Department Natural ResourcesN127SCessna 210L · S/N 21060163Cancelled Nov 10, 1997 · Exported to Croatia · Arnspiger Curt EN4392HRaven S55A · S/N S55A1045Cancelled Oct 10, 1995 · Triennial form not returned · Ohio Ad Fund Promotions IncN7014FHadden/Sobel CLOUD DANCER JN 4DII · S/N 0001Cancelled Mar 13, 1995 · Triennial form not returned · Hadden Edward KN5606VPiper PA-32R-300 · S/N 32R7780347Cancelled Aug 6, 1992 · Rwh Enterprises IncN3226GEubanks-Weaver BIPLANE · S/N RD-1-20Cancelled Jun 25, 1983 · Eubanks Eugene B EtalN6482LPiper PA-31 · S/N 31-446Cancelled May 7, 1981 · Kemple Joseph NN2CRCessna 210 · S/N 21059670Cancelled Mar 19, 1976 · Exported to Canada · Howell John WN8973TCessna 182 · S/N 52873Cancelled Jan 4, 1971 · Built 1960 · Central Ohio Flyers Assn IncN5375NCulver PQ-14B · S/N 44-68429Cancelled Sep 1, 1970 · Pears James RN12JEPiper PA-28-140 · S/N 28-20367Cancelled Jun 4, 1970 · Eggspuehler Jack JN9998ZBeech C-45H · S/N 52-10662Cancelled Dec 11, 1963 · Pontifical College JosephinumN90337Globe GC-1A · S/N 351Cancelled Sep 11, 1950 · Von Eschen Garvin L
Back to Worthington, OH