OpenAirDocs.org
Stillwater, OK

Cancelled registrations · 76

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

N8146GCessna 210K · S/N 21059446Cancelled Jun 5, 2023 · Revoked, canceled · Built 1971 · Universal Aviation IncorporatedN567UABFD Systems GD-40 · S/N BFD-OSU-001Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2017 · Oklahoma State UniversityN330SSStan O Sigle OVERLANDER · S/N 003Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2016 · Sigle Stan ON55911Skystar KITFOX LITE · S/N L9902-023Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2004 · Sigle Stanley ON9621AMcdonnell Douglas DC-9-83(MD-83) · S/N 53592Cancelled Mar 2, 2020 · Built 1998 · Oklahoma Department Of Career & Tech EducationN491AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49684Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1989 · Oklahoma State UniversityN2571KBalloon Works FIREFLY 7-15 · S/N F7-789Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Mitchell Brian LN119RHHale KR-1 · S/N KR119Cancelled Feb 6, 2018 · Registration expired, pending cancellation · Built 1978 · Plumlee Jerry JN8070GCessna 177RG · S/N 177RG0070Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1971 · Oklahoma State Department Of Vocational TechnicalN7901FCessna 150F · S/N 15064001Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1966 · Mushtaq AhmedN2032PAbernathy Patrick ABERNATHY GYROPLANE · S/N A-51256Cancelled May 4, 2015 · Registration expired, pending cancellation · Abernathy Patrick JN9064QHughes TH-55A · S/N 64-18219Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Oklahoma State Department Of Vocational TechnicalN9064YHughes TH-55A · S/N 64-18129Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Oklahoma State Department Of Vocational TechnicalN5882GCessna 150K · S/N 15071382Cancelled Oct 30, 2014 · Registration expired, pending cancellation · Built 1969 · Beckloff Roger WN7042PAbernathy Patrick J BENSEN B-8 · S/N PA4562Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Abernathy Patrick JN90647Hughes TH-55A · S/N 64-18012Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Oklahoma State Department Of Vocational TechnicalN9318YBeech 95-55 · S/N TC-11Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1960 · Oklahoma State Department Vocational TechnicalN90644Hughes TH-55A · S/N 64-18092Cancelled May 17, 2013 · Registration expired, pending cancellation · Oklahoma State Department Of Vocational TechnicalN42CQBeech 65-A90 · S/N LJ-245Cancelled May 16, 2013 · Registration expired, pending cancellation · Oklahoma State Department Of Vocational TechnicalN777RDRockwell International 690B · S/N 11366Cancelled May 13, 2013 · Registration expired, pending cancellation · Garr Aero IncN8007MCessna 401 · S/N 401-0056Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1967 · Oklahoma State Department Of Vocational TechnicalN5405ECherokee II C2 C-1 · S/N 1Cancelled May 10, 2013 · Sale reported, canceled · Built 1965N117FDDelacerda Fred G SENERI V-1 · S/N V919Cancelled May 6, 2013 · Registration expired, pending cancellation · Delacerda Fred GN49352Cessna 152 · S/N 15283450Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1979 · Garr Aero IncN4633Cessna 336 · S/N 336-0171Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1964N411JNCessna 411 · S/N 411-0172Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1966 · Oklahoma State Department Of Vocational TechnicalN373ECessna 337C · S/N 337-0937Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1968 · Waller George C JrN3690YCessna 210C · S/N 21058190Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1963 · Oklahoma State Department Of Vocational TechnicalN2592BPiper PA-38-112 · S/N 38-79A0139Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1978 · Mihura MarkN4310TPiper PA-28R-200 · S/N 28R-7235005Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1971 · Oklahoma State Department Of Vocational TechnicalN1326WMooney M20E · S/N 214Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1963 · Oklahoma State Department Of Vocational TechnicalN2522LCessna 172H · S/N 17255722Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1966 · Millard Charles R JrN150BECessna 150M · S/N 15077265Cancelled Jun 25, 2012 · Exported to Fiji · Built 1975 · Sigle Avery JamesN2MZSundance Avia Enterprise AIR CAM · S/N 90Cancelled Jun 3, 2011 · Exported to Australia · Hill Jimmy WN2509GCessna 182B · S/N 51809Cancelled Apr 12, 2011 · Expired dealer · Built 1958 · Varnell GaryN73364Cessna 172M · S/N 17267403Cancelled Nov 9, 2010 · Exported to Canada · Built 1976 · Albright James PN9692HStinson VULTEE V-77 · S/N 77-322Cancelled Sep 18, 2009 · Registration revoked · Built 1944 · Evans Hugh AN3509RBeech A23 · S/N M-665Cancelled Jul 27, 2009 · Exported to Canada · Built 1965 · Graves Ivan S TrusteeN923SBLet L-23 SUPER BLANIK · S/N 917923Cancelled Aug 16, 2006 · Triennial form not returned · Built 1992 · Cimarron Soaring IncN660YGrumman G-164 · S/N 202Cancelled Jun 8, 1999 · Second triennial mailing, no response · Tomlinson TommyN94450Cessna 152 · S/N 15285676Cancelled Jul 17, 1996 · Exported to India · Stillwater Flight Center IncN3940XPiper PA-28R-200 · S/N 28R7535361Cancelled Feb 20, 1992 · Triennial form not returned · Stillwater Flight Center IncN112NRAero Commander 112 · S/N 3Cancelled Jun 22, 1983 · Sale reported · Built 1974N106FPCessna 172RG · S/N 172RG0629Cancelled Jun 9, 1982 · Exported to Australia · Garr Aero IncN8207ECessna 172N · S/N 17272152Cancelled Dec 2, 1981 · Exported to Canada · Varnell GaryN5275UCessna 172RG · S/N 172RG0318Cancelled Jun 23, 1981 · Exported to Canada · Universal Aviation IncN10854Cessna 150L · S/N 15075090Cancelled Apr 11, 1981 · Administratively canceled · Oklahoma State University Of AgriN9446ECessna 172N · S/N 17272266Cancelled Feb 24, 1981 · Exported to Canada · Varnell GaryN6203DCessna 172N · S/N 172-72632Cancelled Feb 23, 1981 · Exported to Canada · Varnell GaryN75819Cessna 172N · S/N 17267976Cancelled Aug 2, 1979 · Universal Aviation Inc
Back to Stillwater, OK