OpenAirDocs.org
Warren, OH

Cancelled registrations · 53

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

N80043Filer Raymond W KITFOX MODEL 1 · S/N 81Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Molek JonN951Simpson Arthur J-3 REPLICA L4 · S/N 951Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Molek JonN38095Piper J3F-65 · S/N 6780Cancelled Dec 15, 2018 · Revoked, canceled · Built 1941 · Toda Paul E SrN530ZMJon Molek ACUB · S/N O-360-2Cancelled May 9, 2018 · Registration expired, pending cancellation · Molek JonN707EZDavid Hanson LONG EZ · S/N 026048Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Hanson David JN7331HPiper J3C-65 · S/N 20592Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1946 · Molek JonN19082Cessna 150L · S/N 15074153Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1972 · Flack Kenneth JN486LBBrochetti Louis PIETENPOL AIRCAMPER · S/N 2Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1990 · Catchpole Ronald DN7777LBeech C-45 · S/N 451168Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1945 · Molek Eugene AN1005PMooney M20R · S/N 29-0283Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 2002 · Fmr Consulting LLCN3539BBeech D18S · S/N A-1005Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1954 · Molek Jon PN42622Molek Jonathan P BUSHBY MUSTANG · S/N 180Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Molek Jonathan PN714PDCessna 150M · S/N 15079320Cancelled Sep 23, 2013 · Revoked, pending cancellation · Crawford David BN63328Cessna 172P · S/N 17275423Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1981 · Molek JanelleN3913PPiper PA-22-150 · S/N 22-3583Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1956 · Molek Jonathan PN25240Luscombe 8A · S/N 1145Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1940 · Betts StevenN64075Boeing B75N1 · S/N 75-7656Cancelled Aug 6, 2013 · Revoked, canceled · Built 1943 · Allen Russell HN107RDBeech E50 · S/N LH-107Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1957 · Molek JonN9482HBoeing E75N1 · S/N 75-5190Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1943 · Molek Jodi LN65687Boeing E75N1 · S/N 75-8241Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1943 · Molek Jodi LN3478JCessna 150G · S/N 15066178Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1967 · Brown John R JrN3733Dimas TEENIE 2 · S/N STD1Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1973 · Pirtz Joseph EN1227BLuscombe 8A · S/N 5854Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1947 · Molek JonN7063PPiper PA-24-180 · S/N 24-2215Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1960N67813Maffett-Helmheckel TEENIE II · S/N 510675Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1973N26119Piper J4A · S/N 4-834Cancelled Oct 12, 2012 · Registration expired · Built 1939 · Shaffer William JN8885Pitts S-1C · S/N 1Cancelled Sep 10, 2012 · Revoked, canceled · Wike JackN4839KRyan NAVION · S/N NAV41839Cancelled Aug 7, 2012 · Revoked, canceled · Built 1949 · Smith Robert LN102NRAmerican Champion 7ECA · S/N 1382-2000Cancelled Aug 15, 2003 · Exported to Canada · Built 2000 · Gibson Aircraft Sales And Service LtdN67150Mcclounie PIENTENPOL AIRCAMPER · S/N 06-060-1Cancelled Oct 7, 1999 · Triennial form not returned · Trumbull County Joint Vocational SchoolN66789Cessna 150M · S/N 15076282Cancelled Dec 28, 1992 · Triennial form not returned · Magyar Dennis JN185KGCessna A185F · S/N 18502682Cancelled Jun 8, 1992 · Exported to Canada · Gibson Aviation IncN4003JHelio H800 · S/N H3Cancelled Jun 3, 1992 · Exported to Canada · Gibson Maintenance CoN6120RCessna T210F · S/N T210-0020Cancelled Aug 24, 1982 · Trumbull County Air CharterN50161Cessna 150H · S/N 15069103Cancelled Jun 16, 1980 · Crawford David BN2481VCessna 120 · S/N 14702Cancelled May 18, 1976 · Thomas William FN7432HPiper J3C-65 · S/N 20696Cancelled Jun 6, 1974 · Exported to Canada · Hall Ernest CN900MDPiper PA-23 · S/N 23-174Cancelled Jul 27, 1972 · Exported to Canada · Hicks LeeN5904RCessna 172G · S/N 175-53573Cancelled Mar 10, 1972 · Exported to Canada · Jones Barry WallaceN3056DCessna 310 · S/N 35256Cancelled Aug 11, 1971 · Logan J LN1496APiper PA-22 · S/N 22-407Cancelled Sep 30, 1965 · Robert ElstonN70319Piper J3C-65 · S/N 17296Cancelled Jul 5, 1961 · Exported to Canada · Roy G LyonN9738HConsolidated Vultee BT-13A · S/N 7803Cancelled Jul 12, 1956 · Turnbull FrederickN9743HConsolidated Vultee BT-13A · S/N 7586Cancelled Feb 14, 1956 · Webster HerbertN56306Timm N2T-1 · S/N 286Cancelled Oct 11, 1955 · Grate John BN1761Eaglerock LONG WING EAGLEROCK · S/N 284Cancelled Jan 1, 1940 · Built 1927 · Kingsley AdouttN21299Heath Malcolm R PH1 · S/N 3Cancelled Sep 1, 1939 · Built 1937 · Heath Malcolm RN637VCurtiss Wright CR-2 · S/N 3002Cancelled Aug 1, 1938 · Kirk Karl HN7997Babcock ALL-AMERICAN CADET L · S/N 501Cancelled Nov 23, 1936 · Sherwood Robert Et AlN823HStandard J-1 · S/N 41236Cancelled Aug 1, 1935 · Hall Ernest Craft
Back to Warren, OH