OpenAirDocs.org
Bay Aviation Services Inc

Earlier aircraft under this name · 19

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 = 'BAY AVIATION SERVICES INC' OR list_contains(d.other_registrant_names, 'BAY AVIATION SERVICES 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.

N68912Cessna 152 · S/N 15282398Cancelled Aug 23, 1982 · Oakland, CAN4914MFairchild F-27J · S/N 120Cancelled Jan 22, 1980 · Exported to Philippines · Oakland, CAN1988JCessna A188B · S/N 18803323Cancelled May 9, 1979 · Exported to Australia · Oakland, CAN8669KCessna 340A · S/N 340A0610Cancelled Apr 19, 1979 · Exported to Philippines · Oakland, CAN731ZGCessna A188B · S/N 18803281Cancelled Nov 16, 1978 · Exported to Australia · Oakland, CAN19968Douglas DC3A · S/N 3252Cancelled Oct 30, 1978 · Built 1940 · Oakland, CAN68222Cessna 152 · S/N 152-82196Cancelled Oct 24, 1978 · Exported to Philippines · Oakland, CAN68708Avions Holste Max 1521 C1 · S/N 15282325Cancelled Oct 20, 1978 · Exported to Philippines · Oakland, CAN68734Cessna 152 · S/N 15282344Cancelled Oct 19, 1978 · Exported to Philippines · Oakland, CAN761LWCessna 210M · S/N 21062350Cancelled Mar 29, 1978 · Exported to Australia · Oakland, CAN37162Cessna 404 · S/N 404-0125Cancelled Nov 8, 1977 · Exported to Australia · Oakland, CAN8774GCessna 404 · S/N 404-0086Cancelled Oct 12, 1977 · Exported to Australia · Oakland, CAN736HECessna R172K · S/N R1722533Cancelled Aug 1, 1977 · Exported to Australia · Oakland, CAN5454GCessna 404 · S/N 4040071Cancelled May 24, 1977 · Exported to Australia · Oakland, CAN5946GCessna 421C · S/N 421C0256Cancelled May 17, 1977 · Exported to Australia · Oakland, CAN7839KCessna 180K · S/N 18052773Cancelled Feb 9, 1977 · Exported to Papua New Guinea · Oakland, CAN8793QCessna U206G · S/N U20603545Cancelled Feb 8, 1977 · Exported to Papua New Guinea · Oakland, CAN64229Cessna 172M · S/N 172-65106Cancelled Apr 2, 1976 · Exported to Philippines · Oakland, CAN11671Bellanca 7ECA · S/N 847-72Cancelled Jun 5, 1973 · Oakland, CA
Back to Bay Aviation Services Inc