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.

N57163Rockwell International 500-S · S/N 3269Cancelled Jun 25, 1976 · Exported to Australia · Rockwell International Arcft CorpN1281JRockwell International 112A · S/N 281Cancelled Jun 15, 1976 · Exported to Denmark · Rockwell InternationalN4994XRockwell International S-2R-800 · S/N 5039RCancelled May 25, 1976 · Exported to Cyprus · Rockwell InternationalN407HRockwell International 500-S · S/N 3256Cancelled Apr 29, 1976 · Exported to Venezuela · Built 1975 · Rockwell International CorpN1279JRockwell International 112A · S/N 279Cancelled Apr 2, 1976 · Exported to Germany · Rockwell International CorpN57035Rockwell Commander 690A · S/N 11267Cancelled Mar 23, 1976 · Exported to Mexico · Rockwell International IncN9195NAero Commander 685 · S/N 12029Cancelled Mar 19, 1976 · Exported to United Kingdom · Rockwell International CorpN1314JRockwell International 112A · S/N 314Cancelled Mar 18, 1976 · Exported to Germany · Rockwell International CorpN1329JRockwell International 112 · S/N 329Cancelled Feb 12, 1976 · Exported to Canada · Rockwell InternationalN44NRRockwell International NA-265-40 · S/N 282-130Cancelled Feb 6, 1976 · Exported to Mexico · Built 1973 · Rockwell International CorpN1277JRockwell International 112A · S/N 106Cancelled Oct 31, 1975 · Exported to United Kingdom · Rockwell International CorpN1343JRockwell International 112A · S/N 343Cancelled Oct 14, 1975 · Exported to Canada · Rockwell IntlN1351JRockwell International 112A · S/N 351Cancelled Sep 30, 1975 · Exported to Canada · Rockwell IntlN57265Aero Commander 500 S · S/N 3236Cancelled Sep 25, 1975 · Exported to Iran · Rockwell International CorporationN1321JRockwell International 112A · S/N 321Cancelled Sep 3, 1975 · Exported to El Salvador · Rockwell InternationalN1267JRockwell International 112 · S/N 267Cancelled Aug 7, 1975 · Exported to El Salvador · Rockwell International CorpN4991XRockwell International S-2R · S/N 5036RCancelled Jul 24, 1975 · Exported to Greece · Rockwell InternationalN6261LAmerican AA-1B · S/N AA1B-0061Cancelled May 9, 1975 · Rebel Aviation IncN57086Rockwell Commander 690A · S/N 11157Cancelled May 2, 1975 · Exported to Lebanon · Rockwell InternationalN1227JRockwell International 112A · S/N 227Cancelled Apr 24, 1975 · Exported to Germany · Rockwell InternationalN57231Rockwell Commander 690A · S/N 11245Cancelled Apr 14, 1975 · Exported to Argentina · General Aviation Division Rockwell InternationalN6525VAero Commander 685 · S/N 12036Cancelled Apr 10, 1975 · Exported to France · Rockwell Intl CorpN57116Rockwell Commander 690A · S/N 11230Cancelled Mar 18, 1975 · Exported to Argentina · Built 1975 · General Aviation DivisionN9193NAero Commander 690A · S/N 11238Cancelled Mar 18, 1975 · Exported to Argentina · Rockwell InternationalN1245JRockwell International 112A · S/N 245Cancelled Mar 12, 1975 · Exported to South Africa · Rockwell IntlN57216Aero Commander 690A · S/N 11216Cancelled Jan 31, 1975 · Exported to Colombia · Rockwell International General Aviation DivisionN9227NAero Commander 690A · S/N 11217Cancelled Jan 31, 1975 · Exported to Colombia · Rockwell International General Aviation DivisionN1005JRockwell International 112 · S/N 121Cancelled Dec 17, 1974 · Exported to Germany · Built 1973 · Commander Aircraft Division Rockwell InternationalN57192Rockwell Commander 690A · S/N 11192Cancelled Dec 2, 1974 · Exported to Canada · Commander Aircraft Division Rockwell InternationalN22124Cessna 150H · S/N 15068075Cancelled Nov 21, 1974 · Flight Training Center IncN57073Rockwell International 685 · S/N 12060Cancelled Aug 19, 1974 · Exported to Venezuela · Rockwell IntlN1176JAero Commander 112 · S/N 129Cancelled Jul 15, 1974 · Exported to Germany · Rockwell InternationalN7147WPiper PA-28-180 · S/N 28-955Cancelled Jun 5, 1974 · Exported to Australia · Tulakes Aviation CoN1946Aero Commander L3805 · S/N 1Cancelled May 7, 1974 · Built 1948 · Rockwell Standard CorpN6071ZPiper PA-25 · S/N 25-83Cancelled Apr 24, 1974 · Orf John CN57054Rockwell Commander 690A · S/N 11132Cancelled Feb 1, 1974 · Exported to Angola · Rockwell International General Aviation DivisionN9184NAero Commander 500 S · S/N 3132Cancelled Jan 2, 1974 · Exported to South Africa · Rockwell InternationalN8877PPiper PA-24-260 · S/N 24-4336Cancelled Sep 14, 1973 · Merritt Cleo Bill DBAN85MPiper PA-28-180 · S/N 28-2088Cancelled Aug 2, 1973 · Exported to Canada · Rebel Aviation IncN9224NAero Commander 500 S · S/N 3153Cancelled Jul 11, 1973 · Exported to Portugal · Rockwell Intl Corp General Aviation DivisionN9001NAero Commander 690 · S/N 11000Cancelled Jun 7, 1973 · North American Rockwell CorpN357XAero Commander 500 · S/N 500-776Cancelled Apr 27, 1973 · Exported to Canada · Built 1959 · Rebel Aviation IncN9103NAero Commander 500 S · S/N 3135Cancelled Apr 17, 1973 · Exported to Mozambique · North American Rockwell CorpN9105NAero Commander 500 S · S/N 3136Cancelled Apr 17, 1973 · Exported to Mozambique · Rockwell InternationalN5669YPiper PA-23-250 · S/N 27-2783Cancelled Apr 11, 1973 · Exported to United Kingdom · Rebel Aviation IncN9219NAero Commander 690 · S/N 11019Cancelled Mar 20, 1973 · Exported to Argentina · Aero Commander DivisionN201FEAero Commander 500 S · S/N 3101Cancelled Jan 26, 1973 · Exported to Jamaica · Built 1970 · North American Rockwell CorpN5026CBeech B35 · S/N D2288Cancelled Aug 14, 1972 · Built 1950 · Tulakes Aviation CoN9062NAero Commander 500 S · S/N 3061Cancelled Oct 27, 1971 · Exported to Colombia · Aero Commander DivisionN9086NAero Commander 681 · S/N 6033Cancelled Jun 3, 1971 · Exported to Sweden · Aero Commander Division
Back to Bethany, OK