Southern Airways Inc

Earlier aircraft under this name · 26

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

N5965ZPiper PA-22-108 · S/N 22-9837Cancelled Feb 10, 2020 · Revoked, canceled · Built 1964 · Youngstown, OHN1211EAeronca 7AC · S/N 7AC4769Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Youngstown, OHN81998Aeronca 7AC · S/N 7AC623Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Youngstown, OHN85273Aeronca 7AC · S/N 7AC4008Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Youngstown, OHN583SMartin 404 · S/N 14111Cancelled May 8, 1981 · Atlanta, GAN1335UMcdonnell Douglas DC-9-31 · S/N 47393Cancelled Aug 25, 1977 · Built 1970 · Atlanta, GAN582SMartin 404 · S/N 14239Cancelled May 25, 1976 · Atlanta, GAN143SMartin 404 · S/N 14237Cancelled Apr 10, 1974 · Exported to Colombia · Built 1952 · Atlanta, GAN146SMartin 404 · S/N 14223Cancelled May 3, 1972 · Atlanta, GAN148SMartin 404 · S/N 14160Cancelled May 3, 1972 · Atlanta, GAN97SDouglas DC-9-31 · S/N 47245Cancelled May 3, 1971N49679Cessna T-50 · S/N 5945Cancelled Oct 14, 1970 · Atlanta, GAN586SMartin 404 · S/N 14245Cancelled Oct 8, 1965 · Atlanta, GAN2127EAeronca 7AC · S/N 7AC-5698Cancelled Aug 14, 1961 · Exported to Canada · Built 1946 · Youngstown, OHN43886Taylorcraft BC12-D · S/N 7545Cancelled Jan 14, 1960 · Youngstown, OHN1423EAeronca 7AC · S/N 7AC-4986Cancelled Sep 20, 1951 · Built 1946 · Youngstown, OHN41269Piper J3C-65 · S/N 7920Cancelled Sep 23, 1948 · Built 1941 · Decatur, ALN16125Stinson SR-7B · S/N 9687Cancelled Apr 13, 1948 · Atlanta, GAN16178Stinson SR-8B · S/N 9760Cancelled Jul 13, 1944N14121Aeronca C-3 · S/N A-421Cancelled Mar 15, 1940 · Birmingham, ALN11327Great Lakes 2T-1A · S/N 244Cancelled Sep 19, 1936 · Built 1931 · Augusta, GAN986Curtiss JN-4 (CANADIAN) · S/N 2718Cancelled May 17, 1930 · Built 1918 · Dallas, TXN333Curtiss JN4D · S/N I-333Cancelled May 5, 1930 · Built 1918 · Dallas, TXN5097Curtiss Wright JN4D · S/N 5227Cancelled Jun 28, 1929N5451Curtiss Aeroplane & Motor JN4C · S/N VC-51Cancelled Jun 17, 1929 · Built 1918 · Dallas, TXN2555Curtiss JN4D · S/N 16826Cancelled Apr 2, 1928 · San Antonio, TX
Back to Southern Airways Inc