Bethany, OK

Cancelled registrations · 335

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

N5276BCessna 152 · S/N 15283825Cancelled May 30, 2008 · Exported to Argentina · Southern Wings Aircraft Sales LtdN985AVCessna 172R · S/N 17280577Cancelled Apr 21, 2008 · Exported to New Zealand · Built 1998 · Southern Wings Aircraft Sales LtdN3226XRobinson Helicopter R22 BETA · S/N 4112Cancelled Nov 19, 2007 · Exported to Poland · Built 2007 · Interstate Helicopters IncN444BTCessna 208B · S/N 208B-0675Cancelled Oct 16, 2007 · Exported to Japan · Built 1998 · Genesis Aircraft Marketing LLCN404NZCessna 404 · S/N 404-0216Cancelled Aug 2, 2006 · Exported to Tanzania · Built 1978 · Southern Wings Aircraft Sales LtdN74734Robinson Helicopter R44 II · S/N 10889Cancelled Dec 13, 2005 · Exported to Venezuela · Interstate Helicopters IncN690TDRockwell International 690A · S/N 11307Cancelled Apr 1, 2005 · Exported to Canada · Built 1975 · Genesis Aircraft Marketing LLCN55QQWilliams John/Williams Jason SMYTHE SIDEWINDER · S/N 212850Cancelled Jan 5, 2005 · Second triennial mailing, no response · Built 1997 · Williams JohnN421NZCessna 421C · S/N 421C0455Cancelled Nov 1, 2004 · Exported to New Zealand · Southern Wings Aircraft Sales LtdN310GARockwell International 690B · S/N 11422Cancelled Dec 29, 2003 · Exported to South Africa · Built 1977 · Genesis Aircraft Marketing LLCN713DMBeech E-55 · S/N TE-889Cancelled May 21, 2003 · Exported to Mexico · Built 1972 · Jim Clark & Associates IncN96PFPiper PA-28-161 · S/N 28-8116266Cancelled Feb 13, 2003 · Built 1981 · Oklahoma Irrigation IncN137WMAero Commander 685 · S/N 12024Cancelled Apr 19, 2002 · Exported to Colombia · Built 1973 · Flight Commander LLCN3251ACessna 170B · S/N 25895Cancelled Jan 29, 2002 · Sale reported · Built 1953N8LGGreen Larry JETWING · S/N 001Cancelled May 25, 2001 · Triennial form not returned · Green Larry JN580NJAero Commander 1121 · S/N 58Cancelled Dec 19, 2000 · Sale reportedN422BCIsrael Aircraft Industries 1124 · S/N 302Cancelled Aug 7, 2000 · Registration pendingN114JTRockwell International 114 · S/N 14211Cancelled Jun 22, 2000 · Exported to Canada · Commander Aircraft CoN669JECommander 114-B · S/N 14669Cancelled Mar 22, 2000 · Exported to Ecuador · Commander Aircraft CompanyN92JTCommander 114-B · S/N 14567Cancelled Dec 23, 1999 · Exported to United Kingdom · Commander Aircraft CoN24KKBeech 76 · S/N ME-149Cancelled Sep 13, 1999 · Triennial form undeliverable · Business Air Corporate Aviation LtdN6171NBeech B200 · S/N BB-1008Cancelled May 19, 1999 · Exported to New Zealand · Southern Wings Aircraft Sales LtdN1268CCessna 208B · S/N 208B0712Cancelled Feb 5, 1999 · Exported to Italy · Capital Aviation Trading LLC Owner TrusteeN65WMBeech B200 · S/N BB1087Cancelled Sep 14, 1998 · Exported to New Zealand · Southern WingsN77HQCommander 114-B · S/N 14622Cancelled Jul 23, 1998 · Exported to Netherlands · Commander Aircraft CoN244SWBeech B200 · S/N BB1054Cancelled Jul 8, 1998 · Exported to New Zealand · Southern Wings Aircraft Sales LtdN6119CCommander 114TC · S/N 20019Cancelled Jun 1, 1998 · Exported to Chile · Commander Aircraft CompanyN154TCBeech A100 · S/N B239Cancelled Mar 16, 1998 · Exported to Canada · Jim Clark And Associates IncN655VCommander 114-B · S/N 14655Cancelled Feb 2, 1998 · Exported to United Kingdom · Commander Aircraft CoN401MCCessna 208B · S/N 208B0401Cancelled Dec 31, 1997 · Exported to Germany · Capital Aviation Trading LLCN61032Commander 114-B · S/N 14632Cancelled Nov 3, 1997 · Commander Aircraft CompanyN22055Boeing 707-359B · S/N 20340Cancelled Jun 26, 1997 · Built 1970 · Enterprise Air IncN1115PCessna 208B · S/N 208B0583Cancelled Apr 21, 1997 · Exported to Netherlands · Capital Aviation Trading LLC TrusteeN1041FCessna 208B · S/N 208B0576Cancelled Mar 3, 1997 · Exported to Germany · Capital Aviation Trading LLC Owner TrusteeN9382CCessna T303 · S/N T30300175Cancelled Oct 20, 1995 · Exported to Germany · Capital Aviation Trading LLCN66JEIsrael Aircraft Industries 1124 · S/N 326Cancelled Sep 20, 1995 · Sale reportedN6035LCommander 114-B · S/N 14621Cancelled Feb 8, 1995 · Exported to Thailand · Built 1994 · Commander Aircraft CompanyN86201Enstrom F-28F · S/N 707Cancelled Jan 9, 1995 · Exported to Germany · Southern WingsN55391Socata TB 10 · S/N 1190Cancelled Nov 1, 1994 · Exported to Germany · Commander Aircraft CoN111YLAero Commander 1121 · S/N 42Cancelled Jul 7, 1994 · Triennial form not returned · Jet Service Enterprises IncN90HMIsrael Aircraft Industries 1123 · S/N 170Cancelled May 27, 1994 · Jet Service Enterprises IncN5800Convair C-131F · S/N 276Cancelled Dec 15, 1993 · Exported to Canada · Intl Trading Company Of Yukon IncN60132Commander 114-B · S/N 14592Cancelled Oct 13, 1993 · Exported to Germany · Commander Aircraft CompanyN514CARockwell International 114 · S/N 14013Cancelled Jul 29, 1993 · Exported to Turkey · Commander Aircraft CompanyN4769ECessna 172N · S/N 17271634Cancelled Jul 22, 1993 · Exported to Germany · Southern Wings Aircraft Sales LtdN768SBBeech C90 · S/N LJ955Cancelled Apr 5, 1993 · Exported to France · Executive Twin Aviation IncN445BLIsrael Aircraft Industries 1124A · S/N 382Cancelled Mar 5, 1993 · Jet Service Enterprises IncN47335Piper PA-28-181 · S/N 287890054Cancelled Nov 30, 1992 · Exported to Germany · Southern Wings Aircraft Sales LtdN6008XCommander 114-B · S/N 14554Cancelled Sep 24, 1992 · Exported to United Kingdom · Commander Aircraft CompanyN6007SCommander 114-B · S/N 14544Cancelled Jul 8, 1992 · Exported to Germany · Commander Aircraft Company
Back to Bethany, OK