OpenAirDocs.org
Bledsoe Aviation Inc

Earlier aircraft under this name · 25

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'BLEDSOE AVIATION INC' OR list_contains(d.other_registrant_names, 'BLEDSOE AVIATION INC')
  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.

N739XNCessna 172N · S/N 17270890Cancelled Nov 25, 1981 · Exported to Mexico · Corpus Christi, TXN8513QCessna U206F · S/N U20603370Cancelled Apr 25, 1980 · Exported to Mexico · Three Rivers, TXN4744UCessna U206G · S/N U20605077Cancelled Jun 29, 1979 · Exported to Mexico · Corpus Christi, TXN735TACessna U206 · S/N U20604962Cancelled Jun 22, 1979 · Exported to Mexico · Corpus Christi, TXN732CNCessna U206G · S/N U20604659Cancelled Jun 19, 1979 · Exported to Mexico · Corpus Christi, TXN756HMCessna U206G · S/N U20604104Cancelled Nov 28, 1978 · Exported to Mexico · Corpus Christi, TXN756BVCessna U206G · S/N U20603968Cancelled Oct 19, 1978 · Exported to Mexico · Corpus Christie, TXN756QCCessna TU206G · S/N U20604263Cancelled Jul 7, 1978 · Exported to Mexico · Corpus Christie, TXN756BTCessna U206G · S/N U20603966Cancelled Jul 5, 1978 · Exported to Mexico · Corpus Christie, TXN8782QCessna U206G · S/N U20603534Cancelled Jul 5, 1978 · Exported to Mexico · Corpus Christi, TXN53417Cessna 337 · S/N 33701610Cancelled Sep 7, 1976 · Corpus Christi, TXN5795JCessna 182P · S/N 18263542Cancelled Nov 12, 1975 · Exported to Mexico · Corpus Christi, TXN59195Cessna U206F · S/N U20602631Cancelled Sep 8, 1975 · Exported to Mexico · Corpus Christi, TXN52407Cessna 182P · S/N 18262585Cancelled Jul 18, 1975 · Exported to Mexico · Corpus Christi, TXN2107UCessna U206F · S/N U20602345Cancelled Mar 28, 1975 · Exported to Mexico · Corpus Christi, TXN60099Cessna U206F · S/N U20602005Cancelled Nov 6, 1974 · Exported to Mexico · Corpus Christi, TXN58698Cessna 182P · S/N 182-62244Cancelled Mar 19, 1974 · Exported to Mexico · Corpus Christi, TXN51176Cessna 150J · S/N 15069817Cancelled Nov 1, 1973 · Exported to Mexico · Corpus Christi, TXN21527Cessna 182P · S/N 18261691Cancelled Oct 25, 1973 · Exported to Mexico · Corpus Christi, TXN9663GCessna U206F · S/N U206-01863Cancelled Jun 7, 1973 · Exported to Mexico · Corpus Christi, TXN8788ZCessna P206D · S/N P206-0588Cancelled Sep 21, 1970 · Exported to Mexico · Corpus Christi, TXN3839GCessna TU206B · S/N TU206-0839Cancelled Oct 2, 1969 · Exported to Mexico · Corpus Christi, TXN3391LCessna A185E · S/N 185-1343Cancelled Sep 24, 1969 · Exported to Mexico · Built 1968 · Corpus Christi, TXN2638RCessna 182K · S/N 182-58338Cancelled Apr 9, 1968 · Exported to Mexico · Corpus Christi, TXN5484SCessna 337B · S/N 337-0584Cancelled Nov 9, 1967
Back to Bledsoe Aviation Inc