OpenAirDocs.org
El Reno, OK

Cancelled registrations · 49

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 = 'EL RENO'
  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.

N6462PPiper PA-24-250 · S/N 24-1577Cancelled Dec 8, 2020 · Sale reported, canceled · Built 1959N798RCAmerican Drones FLAME 550 · S/N 071916-02-07Cancelled May 2, 2020 · Registration expired, pending cancellation · Canadian County Emergency ManagementN803JEAmerican Drones EAGLE 690 · S/N 062116-03-12Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Canadian County Emergency ManagementN7019NBeech V35A · S/N D-8619Cancelled Sep 4, 2018 · First renewal notice · Built 1967 · On Top Flying Co LLCN57053Powerchute PC2000 · S/N A 182 POWCancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 2001 · Barber Brock AN51884Quad City Ultralight Acft CHALLENGER II · S/N CH201950169Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1996 · Jantzen KennethN215BPPerkins Bob PERKS PLANE · S/N 001Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Perkins Robert DN2046PPiper PA-23-150 · S/N 23-629Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1956 · Canadian Valley Vocational TechnicalN5487RCessna 172RG · S/N 172RG0063Cancelled May 12, 2017 · Built 1979 · Canadian Valley Technology CenterN500ABCessna 421B · S/N 421B0369Cancelled Mar 16, 2016 · Graves Aircraft IncN5185FCessna 172F · S/N 17253128Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1965 · Canadian Valley Technology CenterN347PBPiper PA-23-250 · S/N 27-4182Cancelled Dec 16, 2014 · Registration pending, canceled · Built 1969N64536Fairchild M-62A · S/N T424167Cancelled Aug 6, 2013 · Revoked, canceled · Built 1942 · Escott FredN65055Anahuac TAURO 300 · S/N TA-0010Cancelled Aug 6, 2013 · Revoked, canceled · Escott FredN9065AHughes TH-55A · S/N 64-18071Cancelled Apr 16, 2013 · Sale reported, pending cancellationN7912BCessna 172 · S/N 29712Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1956N3560QCessna A188 · S/N 188-0510Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1969 · Escott FredN9942GCessna A188A · S/N 18800742Cancelled Sep 17, 2009 · Registration revoked · Built 1971 · Escott FredN7016GCessna 150L · S/N 15074603Cancelled Sep 3, 2009 · Triennial form not returned · Built 1973 · Graves Aircraft IncN2764TBeech 95-C55 · S/N TE-372Cancelled Apr 14, 2008 · Triennial form not returned · Built 1967 · Skycraft Aviation IncN165JPPiper PA-31-350 · S/N 31-7952197Cancelled Sep 23, 2004 · Triennial form not returned · Skycraft Aviation IncN288GCCrouch Griffin GC · S/N 001Cancelled Oct 27, 2003 · Triennial form not returned · Crouch GriffinN9686YBeech P35 · S/N D-7110Cancelled Apr 27, 1999 · Triennial form not returned · Graves Aircraft IncN36KBBeech B35 · S/N D2239Cancelled Nov 3, 1997 · Triennial form not returned · Skycraft Aviation IncN414WJCessna 414 · S/N 4140648Cancelled Jul 11, 1996 · Triennial form not returned · Skycraft Aviation IncN96TMPiper PA-31-310 · S/N 31108Cancelled Mar 2, 1994 · Butler Aircraft Sales Export IncN6618CPiper PA-31-350 · S/N 317552091Cancelled Dec 9, 1991 · Exported to Argentina · Graves Aircraft IncN6494VCessna 172RG · S/N 172RG0729Cancelled Apr 11, 1991 · Exported to Australia · Butler Aircraft Sales Export IncN6132ACessna 210N · S/N 21063509Cancelled Mar 29, 1991 · Exported to Australia · Butler Aircraft Sales Export IncN81978Aeronca 7AC · S/N 7AC603Cancelled Jan 4, 1991 · Allen TerryN31425Aerotek PITTS S-2A · S/N 2158Cancelled Sep 1, 1983 · Exported to South Africa · Carder K E Et AlN197WCessna 150G · S/N 15066582Cancelled Nov 20, 1982 · Administratively canceled · Ankney Glen FN5BZBeech BE-55-D55A · S/N TE721Cancelled May 7, 1980 · Exported to Canada · Bostick Motor Co IncN45708Cessna 150M · S/N 15077029Cancelled May 30, 1979 · Exported to Canada · Built 1975 · Skycraft Aviation IncN2061XCessna 182H · S/N 182-56161Cancelled Jun 9, 1978 · Exported to Canada · Graves Aircraft IncN1720SAero Commander 600 S-2D · S/N 600-1318DCancelled Jun 2, 1978 · Exported to Israel · Fred Escott DBA Escott Ag SalesN3578YCessna 182 · S/N 18254478Cancelled Jun 28, 1977 · Exported to Canada · Graves Aircraft IncN77319Cessna 120 · S/N 11761Cancelled Feb 8, 1971 · Gibwhite IncN5112NCessna T-50 · S/N 2626Cancelled Sep 3, 1970 · Bonebrake Bill M IncN4556DBeech G35 · S/N D-4745Cancelled Apr 15, 1965 · Cheyenne Mobile Homes IncN86983Engineering & Research 415-C · S/N 156Cancelled Feb 24, 1956 · Nolder J CN59556Cessna T-50 · S/N 2654Cancelled Oct 12, 1955 · Built 1943 · Phelps Malcom EN1270DCessna 170A · S/N 19846Cancelled Sep 21, 1954 · Vandiver R HN19795Aeronca K · S/N K-289Cancelled Apr 27, 1951 · Built 1938 · Doyle George EN4694NConsolidated Vultee BT-13A · S/N 2340Cancelled Apr 25, 1951 · El Reno Aviation IncN15535Interstate S-1 CADET · S/N 1Cancelled Jan 29, 1951 · Williams W FN2301HErcoupe 415-C · S/N 2926Cancelled Oct 14, 1949 · Built 1946 · Cook Clifford AN19786Aeronca KC · S/N KC-19Cancelled Aug 17, 1948 · Coulter N C And Ramsey Glen EN995NHugh E Zimmerman ZIMMERMAN · S/N 1Cancelled Jan 15, 1940 · Nottingham J H
Back to El Reno, OK