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.

N78349Aero Commander 680FL · S/N 12912Cancelled Oct 21, 1963 · Aero CommanderN78340Aero Commander 500-B · S/N 500B-1134-76Cancelled Jun 27, 1963 · Exported to Sweden · Aero Commander IncN78381Aero Commander 680-F · S/N 680F-1241-123Cancelled May 2, 1963 · Exported to Mexico · Aero Commander IncN78338Aero Commander 500-B · S/N 500B-1190-96Cancelled Mar 28, 1963 · Exported to South Africa · Aero Commander IncN78385Aero Commander 560-F · S/N 560F-1246-54Cancelled Mar 28, 1963 · Exported to Venezuela · Aero Commander IncN6293XAero Commander 680-F · S/N 680F-1209-110Cancelled Dec 19, 1962 · Exported to Brazil · Aero Commander IncN6245XAero Commander 680-F · S/N 680F-1087-65Cancelled Mar 9, 1962 · Exported to Germany · Aero Commander IncN181EBeech D18S · S/N A-252Cancelled May 26, 1961 · Richards AircraftN6241BAero Commander 500 · S/N 654Cancelled Nov 17, 1960 · Exported to South Africa · Aero Design & Engineering CoN2749BAero Commander 560-A · S/N 249Cancelled Sep 30, 1960 · Aero Design & Engineering CoN9352RAero Commander 560-E · S/N 864Cancelled Aug 9, 1960 · Exported to Brazil · Aero Design & Engineering CoN9355RAero Commander 560-E · S/N 869Cancelled Jun 30, 1960 · Exported to Brazil · Aero Design & Engineering CoN8499CAero Commander 560-E · S/N 861Cancelled Jun 29, 1960 · Exported to Brazil · Aero Design & Engineering CoN8464CAero Commander 500 · S/N 803Cancelled May 9, 1960 · Exported to Finland · Aero Design & Engineering CoN8484CAero Commander 500 · S/N 829Cancelled May 9, 1960 · Exported to Iran · Aero Design & Engineering CoN9350RAero Design & Engineering 500 · S/N 852Cancelled May 6, 1960 · Exported to Brazil · Aero Design & Engineering CoN6211BAero Commander 680 · S/N 680-547-215Cancelled May 7, 1958 · Exported to Argentina · Aero Design & Engineering CoN6210DAero Commander 680 · S/N 680-483-153Cancelled Jan 7, 1958 · Aero Design & Engineering CoN6252DAero Commander 680 · S/N 680-520-190Cancelled Dec 30, 1957 · Exported to Argentina · Aero Design & Engineering CoN6201DAero Commander 680 · S/N 680-469-139Cancelled Dec 6, 1957 · Exported to Argentina · Aero Design & Engineeriing CoN6211DAero Commander 680 · S/N 680-479-149Cancelled Nov 27, 1957 · Aero Design & Engineering CoN6215DAero Commander 680 · S/N 680-478-148Cancelled Nov 27, 1957 · Aero Design & Engineering CoN6206DAero Commander 680 · S/N 680-474-144Cancelled Jul 5, 1957 · Aero Design & Engineering CoN77692Fairchild 24R-46 · S/N R46392Cancelled Mar 16, 1956 · Tulakes IncN26634Taylorcraft BC-65 · S/N 1976Cancelled Feb 21, 1956 · Paul S DunnN2615BAero Commander 520 · S/N 128Cancelled Apr 23, 1954 · Exported to South Korea · Aero Design & Engineering CoN2616BAero Commander 520 · S/N 129Cancelled Apr 23, 1954 · Exported to South Korea · Aero Design & Engineering CoN2617BAero Commander 520 · S/N 130Cancelled Apr 23, 1954 · Exported to South Korea · Aero Design & Engineering CoN4677NConsolidated Vultee BT-13 · S/N 11310Cancelled Mar 27, 1951 · Wesley Don ShireyN95474Cessna T-50 · S/N 4598Cancelled Jul 29, 1949 · Fritts Alton LN4625NBeech GB-2 · S/N D17S6739Cancelled Sep 23, 1948 · Modern Aircraft CoN4627NBeech GB-2 · S/N D17S6877Cancelled Sep 23, 1948 · Modern Aircraft CoN24WFriedrich H / Kohl A LAND MONOPLANE · S/N 2Cancelled Feb 9, 1933 · Stockett HenryN83SARockwell International 690C · S/N 11700Cancellation date not recorded · Gulfstream American CorpN9115NAero Commander 680FL · S/N 1852-156Cancellation date not recorded · North American Rockwell Corp
Back to Bethany, OK