OpenAirDocs.org
Moore, OK

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 = 'OK' AND d.registrant_city = 'MOORE'
  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.

N45WYAviat A-1C-180 · S/N 3115Cancelled Sep 28, 2020 · Exported to New Zealand · Built 2011 · Fx Consulting LtdN8090DPiper PA-18-150 · S/N 18-6088Cancelled Feb 9, 2019 · Revoked, canceled · Blackstone B JN377FSSix Chuter POWERCHUTE 2000 · S/N SR 7XL-2566Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Simms Jason AN5187MTaylorcraft BC12-D · S/N 10487Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1947 · Aircraft & Engine Enterprises IncN8119WPiper PA-28-161 · S/N 28-8016131Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1979 · Erico IncN4252GCirrus Design SR20 · S/N 2217Cancelled Dec 19, 2016 · First renewal notice · Built 2012 · Safe Aviation LLCN31EDPiper PA-34-200T · S/N 34-7770268Cancelled Aug 23, 2016 · Third renewal notice · Built 1977 · Aeronautical Navigation Inc (Aeronav)N26535Taylorcraft BL · S/N 1876Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1940 · Aircraft And Engine Enterprises IncN36309Taylorcraft BC12-65 · S/N 3227Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1941 · Aircraft & Engine Enterprises IncN9770TPiper PA-38-112 · S/N 38-78A0199Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1978 · Erico IncN709BHHaynes AX-7 · S/N 001Cancelled Dec 2, 2014 · Revoked, canceled · Built 1975 · Haynes BuddyN58965Taylorcraft DCO-65 · S/N L-5103Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Aircraft And Engine Enterprises IncN3986CCloutier Richard H CONDOR III+II · S/N 83-125-3-2Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1983 · Cloutier Richard HN1111VSkeeter 1M · S/N 1MCancelled Aug 26, 2013 · First renewal notice · Built 1966 · Eaves Leonard RN39179Taylorcraft DC-65 · S/N 4185Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1942 · Aircraft & Engine Enterprises IncN455KTTownsend K A DRAGONFLY · S/N 645Cancelled Aug 5, 2013 · Sale reported, canceledN1511TBalloon Works FIREFLY 7-B · S/N F7B-021Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1982N15236Balloon Works FIREFLY 7-B · S/N 10304Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1981N2132HBalloon Works FIREFLY 6B · S/N 6714Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1977N8003SPiper PA-28-181 · S/N 28-8290072Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Erico IncN7337VBellanca 17-30 · S/N 30196Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1969 · Walker Brian LN48647Taylorcraft L-2M · S/N L-5843Cancelled May 6, 2013 · Registration expired, pending cancellation · Aircraft And Engine Enterprises IncN714RLCessna 150M · S/N 15079374Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1977 · Erico IncN58039Taylorcraft DCO-65 · S/N L-5629Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1943 · Aircraft And Engine Enterprises IncN44393Taylorcraft BC12-D · S/N 10193Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1946 · Aircraft And Engine Enterprises IncN15330Balloon Works FIREFLY 7 · S/N 10178Cancelled Feb 26, 2013 · Sale reported, pending cancellation · Built 1980N31690Dart GC · S/N GC-63Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1946 · Aircraft & Engine Enterprises IncN2598KPiper PA-38-112 · S/N 38-79A0683Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Erico IncN4067ABalloon Works FIREFLY 7 · S/N 10009Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1979N313ZBeech M35 · S/N D-6465Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1960 · Aircraft & Engine Enterprises IncN30471Piper J3C-65 · S/N 4858Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1945N145CBCameron Balloons V-56 · S/N 338Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1978N5210UCessna 206 · S/N 206-0210Cancelled Jul 18, 2011 · Expired dealer · Built 1964 · Biggs L LoreneN1539SBalloon Works FIREFLY 7 · S/N 11140Cancelled Mar 4, 2011 · Expired dealer · Built 1982 · Sooner Balloon CorpN1439VCessna R172K · S/N R1722191Cancelled Apr 19, 2010 · Triennial form not returned · Eggleston KevinN1111RVampire 1 · S/N 1HPCancelled Jun 25, 2009 · Registration revoked · Built 1966 · Perry Hubert MN9085AAerostar International RX 8 · S/N RX8-3304Cancelled Jul 1, 2008 · Exported to Canada · Built 1997 · Evans Howard R TrusteeN40961Piper PA-28-140 · S/N 28-7425194Cancelled Aug 17, 2006 · Expired dealer · Built 1973 · Biggs AircraftN2255HBalloon Works FIREFLY 7 · S/N 7768Cancelled May 5, 2004 · Triennial form not returned · Built 1978 · Sooner Balloon CorpN6311NBritton Lauren Dean RAGWING SPECIAL · S/N 1Cancelled Nov 27, 2000 · Britton Lauren DN9544RBeech K35 · S/N D6131Cancelled Jul 14, 1997 · Triennial form not returned · Aircraft And Engine Enterprises IncN107QBeech K35 · S/N D5929Cancelled Feb 19, 1997 · Triennial form not returned · Aircraft & Engine Enterprises IncN2791VBeech 35 · S/N D185Cancelled Sep 16, 1995 · Triennial form not returned · Aircraft And Engine Enterprises IncN3902PPiper PA-22-150 · S/N 223571Cancelled Nov 6, 1992 · Triennial form not returned · Magee Michael JN4348UCessna 150D · S/N 15060348Cancelled Nov 14, 1991 · Triennial form not returned · Sooner Aircraft IncN717LGGarrett Larry L MONNETT MONI · S/N 146Cancelled Jan 25, 1984 · Garrett Larry LN3702NBeech 35 · S/N D-908Cancelled Nov 21, 1983 · Built 1947 · Aircraft & Engine Enterprises IncN3449LCessna U206B · S/N U206-0749Cancelled Jul 24, 1974 · Biggs FloydN42472Cessna 182L · S/N 18259031Cancelled Nov 7, 1972 · Exported to New Zealand · Built 1968 · Briggs AircraftN2964EAeronca 7AC · S/N 7AC-6550Cancelled Dec 31, 1970 · Built 1946 · Lathrop Jerry
Back to Moore, OK