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.

N999SMCessna 172M · S/N 17262452Cancelled Jun 19, 1992 · Triennial form not returned · Mitchell SusieN432SWCessna 421C · S/N 421C1024Cancelled Dec 12, 1991 · Exported to Germany · Southern Wings Aircraft Sales LtdN114BKRockwell International 114 · S/N 14500Cancelled Oct 24, 1991 · Exported to Germany · Aeronautical Systems CorporationN479GERockwell International 114 · S/N 14118Cancelled Oct 15, 1991 · Exported to Italy · Aeronautical Systems CorpN887MMCessna T210M · S/N 21062669Cancelled Sep 17, 1991 · Exported to Germany · Southern Wings Aircraft SalesN4858WRockwell International 114 · S/N 14188Cancelled Jul 9, 1991 · Exported to Italy · Aeronautical Systems CorporationN2ANAntonov AN-2 · S/N 1G13758Cancelled Jun 20, 1991 · Exported to United Kingdom · T M Aviation InternationalN538Rockwell International 112B · S/N 538Cancelled May 29, 1991 · Exported to Turkey · Aeronautical Systems CorporationN1198JAero Commander 112 · S/N 198Cancelled May 17, 1991 · Exported to France · Aeronautical Systems CorpN49615Bell 206B · S/N 1777Cancelled Mar 28, 1991 · Exported to Canada · Intl Aircraft Distributors IncN4994WRockwell International 114 · S/N 14314Cancelled Dec 5, 1990 · Exported to United Kingdom · Aeronautical Systems CorpN200BXBeech C90 · S/N LJ717Cancelled Mar 31, 1988 · Exported to France · Southern Wings Aircraft Sales LtdN7116APiper PA-31 · S/N 31-7401218Cancelled Feb 14, 1986 · Exported to Canada · Executive Twin AviationN5852NGulfstream AM Corp Comm Div 690D · S/N 15006Cancelled May 7, 1985 · Exported to Venezuela · Gulfstream American CorpN4841WRockwell International 114 · S/N 14171Cancelled Jan 31, 1985 · Exported to Nicaragua · Built 1976 · Rockwell InternationalN56GAGulfstream AM Corp Comm Div 690C · S/N 11733Cancelled Jan 10, 1985 · Exported to Pakistan · Gulfstream Aerospace CorpN600GAGulfstream American PEREGRINE 600 · S/N 601Cancelled Mar 22, 1984 · Gulfstream American CorpN7476FHughes 269C · S/N 270565Cancelled Feb 2, 1984 · Exported to New Zealand · Oneal RonN7370MCessna T210 · S/N 21062013Cancelled Aug 9, 1983 · Exported to Canada · Joe Walker Aircraft Sales ServiceN5905NGulfstream AM Corp Comm Div 690D · S/N 15022Cancelled May 18, 1983 · Exported to Germany · Gulfstream AerospaceN5960KGulfstream AM Corp Comm Div 690C · S/N 11723Cancelled Dec 28, 1982 · Exported to Venezuela · Gulfstream Aerospace CorpN81515Rockwell International 500-S · S/N 3282Cancelled Nov 29, 1982 · Exported to El Salvador · Rockwell InternationalN81653Rockwell International 690B · S/N 11412Cancelled Nov 22, 1982 · Exported to Argentina · Rockwell InternationalN5964KGulfstream AM Corp Comm Div 690C · S/N 11726Cancelled Nov 8, 1982 · Exported to Venezuela · Gulfstream American CorpN5957KGulfstream AM Corp Comm Div 690C · S/N 11720Cancelled Jun 30, 1982 · Gulfstream DivisionN74SARockwell International 690C · S/N 11678Cancelled Mar 17, 1982 · Exported to Venezuela · Gulfstream American CorpN5950KGulfstream AM Corp Comm Div 690C · S/N 11698Cancelled Jan 22, 1982 · Exported to Venezuela · Gulfstream American CorpN2413VCessna 140 · S/N 14658Cancelled Dec 28, 1981 · Built 1948 · Shepherd Roger P Et AlN9818SGulfstream AM Corp Comm Div 695 · S/N 95066Cancelled Nov 13, 1981 · Exported to Colombia · Gulfstream AmericanN38SAGulfstream AM Corp Comm Div 690C · S/N 11686Cancelled Oct 17, 1981 · Built 1981 · Gulfstream AmericanN57055Aero Commander 500 S · S/N 3171Cancelled Jul 15, 1981 · Exported to Barbados · Commander Aircraft Division Rockwell InternationalN57247Rockwell International 500-S · S/N 3228Cancelled Jul 15, 1981 · Exported to Argentina · Rockwell CommanderN9002NAero Commander 500 S · S/N 1827-27Cancelled Jul 15, 1981 · Exported to Iran · Gulfstream American CorpN1107JAero Commander 112 · S/N 107Cancelled Jun 13, 1981 · Administratively canceled · Rockwell International CorporationN57032Rockwell Commander 690A · S/N 11248Cancelled Jun 2, 1981 · Exported to Argentina · Rockwell International IncN57043Rockwell Commander 690A · S/N 11253Cancelled Jun 2, 1981 · Exported to Venezuela · General Aviation Division Rockwell IntlN57183Rockwell International 690A · S/N 11281Cancelled Jun 2, 1981 · Exported to Venezuela · Rockwell International General Aviation DivisionN57196Rockwell Commander 690A · S/N 11333Cancelled Jun 2, 1981 · Exported to Iran · Rockwell International General Aviation DivisionN57232Rockwell Commander 690A · S/N 11246Cancelled Jun 2, 1981 · Exported to Argentina · Rockwell International General Aviation DivisionN57257Rockwell Commander 690A · S/N 11285Cancelled Jun 2, 1981 · Exported to Venezuela · Rockwell IntlN57257Aero Commander 500 S · S/N 3197Cancelled Jun 2, 1981 · Exported to Mozambique · Rockwell International Commander Aircraft DivisionN57287Rockwell Commander 690A · S/N 11288Cancelled Jun 2, 1981 · Exported to Venezuela · Rockwell Intl CorpN81427Rockwell International 690A · S/N 11295Cancelled Jun 2, 1981 · Exported to Iran · Rockwell Intl CorpN5919KGulfstream AM Corp Comm Div 690C · S/N 11667Cancelled Apr 30, 1981 · Exported to Pakistan · Gulfstream American Corp Commander DivisionN700ADRockwell International 700 · S/N 70001Cancelled Dec 31, 1980 · Rockwell International CorpN5902KRockwell International 690C · S/N 11650Cancelled Dec 15, 1980 · Exported to Mexico · Rockwell InternationalN800RAAero Commander 500-U · S/N 1765Cancelled Dec 3, 1980 · Exported to France · Rebel Aviaiton IncN5872KRockwell International 690C · S/N 11620Cancelled Sep 29, 1980 · Exported to United Kingdom · Rockwell InternationalN1248JRockwell International 112 · S/N 248Cancelled Jul 10, 1980 · Built 1975 · Rockwell International CorpN5072FDehavilland DHC-3 · S/N 366Cancelled Jul 9, 1980 · Exported to Canada · Waggoner Aircraft Inc
Back to Bethany, OK