Africair Inc

Earlier aircraft under this name · 323

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

N35958Cessna U206F · S/N U20602830Cancelled Jul 8, 1975 · Exported to Zambia · Miami, FLN5216JCessna 402B · S/N 402B0903Cancelled Jun 9, 1975 · Exported to Kenya · Miami, FLN61609Cessna 172M · S/N 17264674Cancelled Jun 4, 1975 · Exported to Republic of the Congo · Miami, FLN4658KCessna 182P · S/N 18263660Cancelled Apr 22, 1975 · Exported to Kenya · Miami, FLN5032JCessna T310R · S/N 310R0152Cancelled Apr 22, 1975 · Exported to Kenya · Built 1974 · Miami, FLN1680XCessna 210L · S/N 21060715Cancelled Apr 8, 1975 · Exported to Kenya · Miami, FLN5898JCessna 182P · S/N 18263571Cancelled Apr 2, 1975 · Exported to Kenya · Miami, FLN59305Cessna U206F · S/N U20602646Cancelled Mar 21, 1975 · Exported to Kenya · Miami, FLN4940JCessna 310R · S/N 310R0121Cancelled Mar 11, 1975 · Exported to Kenya · Miami, FLN1396GCessna 310R · S/N 310R0031Cancelled Mar 4, 1975 · Exported to Kenya · Miami, FLN33191Cessna U206F · S/N U20602661Cancelled Feb 14, 1975 · Exported to Kenya · Miami, FLN5764JCessna 182P · S/N 18263524Cancelled Feb 14, 1975 · Exported to Kenya · Miami, FLN5749JCessna 182P · S/N 18263516Cancelled Feb 13, 1975 · Exported to Kenya · Miami, FLN1378VCessna TU206F · S/N U20602593Cancelled Jan 29, 1975 · Exported to South Africa · Miami, FLN1375VCessna U206 · S/N U20602591Cancelled Dec 12, 1974 · Exported to Kenya · Miami, FLN5711GCessna 182P · S/N 18263306Cancelled Dec 12, 1974 · Exported to Kenya · Miami, FLN9221GCessna 182P · S/N 18263394Cancelled Dec 12, 1974 · Exported to Kenya · Miami, FLN1335GCessna 310R · S/N 310R0019Cancelled Dec 5, 1974 · Exported to Kenya · Miami, FLN1244VCessna U206F · S/N U20602531Cancelled Nov 5, 1974 · Exported to Kenya · Miami, FLN52070Cessna 180J · S/N 18052478Cancelled Oct 31, 1974 · Exported to Kenya · Miami, FLN5886GCessna 182P · S/N 18263309Cancelled Oct 30, 1974 · Exported to Kenya · Miami, FLN57948Beech C-45H · S/N AF-478Cancelled Sep 23, 1974 · Exported to Central African Republic · Miami, FLN5137QCessna 210L · S/N 210-59637Cancelled Aug 8, 1972 · Exported to Zambia · Miami, FL
Back to Africair Inc