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.

N8265FCessna 150F · S/N 15064365Cancelled May 24, 1971 · Flight Training Center IncN1007SAero Commander 500 S · S/N 3079Cancelled Feb 26, 1971 · Exported to Portugal · Aero Commander Div North American Rockwell CorpN731RShort Bros. & Harland SC7 SERIES 2 · S/N SH1835Cancelled Feb 9, 1971 · Exported to Ireland · North American RockwellN44648Beech D18S · S/N A-137Cancelled Aug 21, 1970 · Aircraftsmen IncN9202NAero Commander 690 · S/N 11002Cancelled Jul 2, 1970 · Aero Commander DivisionN21051Aeronca KCA · S/N KCA-27Cancelled Jun 29, 1970 · Built 1938 · Emmert Raymond LN6523VAero Commander 680T · S/N 1583-35Cancelled Jun 26, 1970 · Aero Commander Division Of North American RockwellN6901ZPiper PA-25-235 · S/N 25-2640Cancelled Jun 22, 1970 · Oef John CN4669EAero Commander 680FL · S/N 1741-143Cancelled Apr 20, 1970 · Exported to France · Built 1968 · Aero Commander Divisionnorth American Rockwell CoN4565EAero Commander 680FL · S/N 1716-137Cancelled Apr 7, 1970 · Exported to France · Aero Commander DivN9035NAero Commander 681 · S/N 6030Cancelled Mar 27, 1970 · Exported to Germany · Aero Commander DivisionN9012NAero Commander 681 · S/N 6023Cancelled Mar 9, 1970 · Exported to Mexico · Aero Commander DivisionN5025EAero Commander 680FL · S/N 1853-157Cancelled Jan 29, 1970 · Exported to France · Built 1969 · Aero Commander DivisionN5044EAero Commander 1121B · S/N 136Cancelled Oct 31, 1969 · Exported to Sweden · North American Rockwell CorpN25411Porterfield LP-65 · S/N 586Cancelled Jul 25, 1969 · Vorheis L DN4665EAero Commander 680FL · S/N 1740-142Cancelled Jul 1, 1969 · Exported to Argentina · Aero Commander DivN4691EAero Commander 1121 · S/N 107Cancelled Jun 16, 1969 · Exported to Israel · North American Rockwell CorpN6042CCallair A-4 · S/N 155Cancelled Jun 6, 1969 · Burkett Jack WN7742UCessna 172E · S/N 17251742Cancelled Jun 3, 1969 · Exported to Canada · Tulakes Aviation IncN5038ACessna 172 · S/N 28038Cancelled Jun 2, 1969 · Exported to Canada · Aircraftsmen IncN5920CAero Commander 680T · S/N 1552-12Cancelled Jun 2, 1969 · Built 1965 · Aero Commander Division OfN615JCAero Commander 1121 · S/N 29Cancelled Mar 7, 1969 · Exported to Israel · Aero Commander DivisionN4930EAero Commander 500 S · S/N 1810-20Cancelled Jan 21, 1969 · Exported to Australia · North American Rockwell CorpN6300Aero Commander 680T · S/N 1540-6Cancelled Jan 21, 1969 · Exported to United Kingdom · North American Rockwell Corp Aero Commander DivN78386Aero Commander 680FL · S/N 1261-1Cancelled Dec 16, 1968 · Aero CommanderN4638EAero Commander 680T · S/N 1699-76Cancelled Nov 6, 1968 · Exported to Canada · Built 1967 · Aero CommanderN2882PPiper PA-18-150 · S/N 18-4479Cancelled Sep 11, 1968 · Exported to Canada · Kerr Aviation Services IncN4614EAero Commander 500-U · S/N 1682-21Cancelled Sep 6, 1968 · Exported to Venezuela · Aero CommanderN6625VAero Commander 680FL · S/N 1657-127Cancelled Jul 31, 1968 · Exported to Republic of the Congo · Aero CommanderN4530EAero Commander 680FL · S/N 1665-130Cancelled Mar 18, 1968 · Exported to Argentina · Built 1967 · North American Rockwell CorpN3408WPiper PA-32-260 · S/N 32-269Cancelled Feb 12, 1968 · Tulakes Aviation IncN6502VAero Commander 500-B · S/N 1631-217Cancelled Dec 13, 1967 · Exported to Iran · Rockwell Standard Corp AeroN4595EAero Commander 500-U · S/N 1728-31Cancelled Nov 27, 1967 · Exported to Brazil · Built 1967 · Aero CommanderN4950EAero Commander 500-U · S/N 1726-29Cancelled Nov 27, 1967 · Exported to Brazil · Built 1967 · Aero Commander DivisionN4549EAero Commander 680V · S/N 1683-64Cancelled Oct 12, 1967 · Exported to Venezuela · Aero CommanderN9361RAero Commander 680-F · S/N 680F-871-1Cancelled Aug 14, 1967 · Rockwell-Standard CorpN4619EAero Commander 500-U · S/N 1700-23Cancelled Aug 3, 1967 · Exported to Guatemala · Built 1967 · Aero CommanderN6529VAero Commander 500-U · S/N 1673-19Cancelled Feb 21, 1967 · Exported to Argentina · Aero CommanderN1195ZAero Commander 680T · S/N 1575-29Cancelled Dec 22, 1966 · Exported to Canada · Built 1966 · Aero Commander Bethany Div Rockwell Standard CorpN5330EBeech K35 · S/N D-5800Cancelled Feb 11, 1966 · Morris Aviation Enterprises IncN6349UAero Commander 680FP · S/N 1426-149Cancelled Oct 1, 1965 · Exported to South Africa · Rockwell Standard Corpaero Commander DivisionN6374UAero Commander 680FL · S/N 1410-61Cancelled Sep 17, 1965 · Exported to Sweden · Aero Commander DivisionN2630BAero Commander 520 · S/N 142Cancelled Jun 8, 1965 · Exported to Yemen · Aero Design & Engng CoN4185BAero Commander 520 · S/N 88Cancelled May 25, 1965 · Aero Design Engineering CoN8444CAero Design & Engineering 500 · S/N 360-1Cancelled May 25, 1965 · Aero Design & Engineering CoN6304UAero Commander 680-F · S/N 680F-1385-145Cancelled Apr 20, 1965 · Exported to France · Aero CommanderN1160ZAero Commander 680-F · S/N 1467-90Cancelled Mar 19, 1965 · Exported to Argentina · Aero Commander Div Rockwell Standard CorpN78367Aero Commander 500-B · S/N 500B-1229-104Cancelled Aug 28, 1964 · Exported to France · Aero CommanderN6328UAero Commander 680FL · S/N 1366-40Cancelled Apr 28, 1964 · Exported to Germany · Aero Commander DivisionN78388Aero Commander 680-F · S/N 680F-1234-120Cancelled Nov 21, 1963 · Exported to Colombia · Aero Commander
Back to Bethany, OK