OpenAirDocs.org
Zed-Air Inc

Earlier aircraft under this name · 21

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 = 'ZED-AIR INC' OR list_contains(d.other_registrant_names, 'ZED-AIR 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.

N38006Beech V35B · S/N D-10356Cancelled Oct 29, 1981 · Exported to Australia · Built 1980 · Hollister, CAN1953FCessna 172N · S/N 17273043Cancelled Jul 31, 1981 · Exported to Australia · Built 1979 · Hollister, CAN6443FCessna 172N · S/N 172-73225Cancelled Jul 31, 1981 · Exported to Australia · Hollister, CAN89604Cessna 152 · S/N 152-82803Cancelled Jul 31, 1981 · Exported to Australia · Hollister, CAN5418XCessna TU206G · S/N U206-05734Cancelled May 27, 1981 · Exported to Papua New Guinea · Hollister, CAN5129KCessna 172N · S/N 17273977Cancelled Feb 17, 1981 · Exported to Papua New Guinea · Hollister, CAN1038WCessna 182Q · S/N 18266195Cancelled Jun 23, 1980 · Exported to Australia · Built 1978 · Hollister, CAN2815ECessna 172N · S/N 17271333Cancelled Oct 29, 1979 · Exported to Australia · Hollister, CAN63039Cessna 180K · S/N 18052821Cancelled Oct 26, 1979 · Exported to Australia · Hollister, CAN6069APiper AEROSTAR 601 · S/N 61-0667-7962141Cancelled Oct 11, 1979 · Exported to Australia · Hollister, CAN25442Cessna 152 · S/N 15280662Cancelled Sep 28, 1979 · Exported to Australia · Built 1977 · Hollister, CAN735VNCessna 182Q · S/N 18265720Cancelled Aug 1, 1979 · Exported to Australia · Hollister, CAN49160Cessna 152 · S/N 15281173Cancelled Jul 23, 1979 · Exported to Australia · Hollister, CAN7233CPiper PA-28R-200 · S/N 28R-7635097Cancelled Jul 9, 1979 · Exported to Australia · Hollister, CAN56794Piper PA-32-300 · S/N 32-7440026Cancelled Jul 2, 1979 · Exported to Australia · Holliser, CAN33741Piper PA-28R-200 · S/N 28R-7535197Cancelled Jun 21, 1979 · Exported to Australia · Hollister, CAN2815GPiper PA-28-161 · S/N 28-7916439Cancelled Jun 7, 1979 · Exported to Vanuatu · Hollister, CAN29757Gulfstream American GA-7 · S/N GA7-0088Cancelled Apr 18, 1979 · Exported to Singapore · Hollister, CAN14337Piper PA-23-250 · S/N 27-7304920Cancelled Jan 24, 1979 · Exported to Australia · Built 1973 · Hollister, CAN3126QPiper PA-32R-300 · S/N 32R-7780294Cancelled Jan 8, 1979 · Exported to Australia · Built 1977 · Hollister, CAN6004CPiper PA-28-181 · S/N 28-7890348Cancelled Dec 8, 1978 · Exported to Australia · Hollister, CA
Back to Zed-Air Inc