Mobile Aircraft Inc

Earlier aircraft under this name · 16

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

N629GSPiper PA-23-250 · S/N 27-2023Cancelled May 15, 2019 · Revoked, pending cancellation · Mobile, ALN4285PPiper PA-23-160 · S/N 23-1785Cancelled May 18, 2018 · Revoked, canceled · Built 1959 · Mobile, ALN631RCessna 310 · S/N 35178Cancelled Aug 5, 2013 · Revoked, canceled · Built 1955 · Mobile, ALN122RRoberts CHASE YC-122C · S/N 49-2882Cancelled Sep 18, 2009 · Registration revoked · Built 1953 · Mobile, ALN9005YPiper PA-31 · S/N 31-9Cancelled Oct 30, 1974 · Mobile, ALN1667JPiper PA-28-140 · S/N 28-24066Cancelled May 2, 1969 · Exported to Canada · Mobile, ALN6077YPiper PA-23-250 · S/N 27-3278Cancelled Jan 3, 1969 · Exported to CanadaN9498YBeech 95-55 · S/N TC-62Cancelled Sep 12, 1968 · Exported to Morocco · Built 1961 · Mobile, ALN6305UAero Commander 680FL · S/N 1389-49Cancelled Jul 25, 1968 · Exported to Canada · Mobile, ALN408EEAero Commander 680-E · S/N 680E-665-8Cancelled Jun 13, 1968 · Built 1958 · Mobile, ALN7924VCessna 180H · S/N 18051824Cancelled Oct 30, 1967 · Exported to Canada · Mobile, ALN13110Piper PA-30 · S/N 30-628Cancelled Oct 17, 1967 · Exported to Canada · Mobile, ALN316ADouglas C-54E · S/N 27373Cancelled Sep 18, 1967 · Exported to Norway · Mobile, ALN6392YPiper PA-23-250 · S/N 27-3679Cancelled May 22, 1967 · Exported to Canada · Mobile, ALN5630YPiper PA-23-250 · S/N 27-2742Cancelled Mar 23, 1967 · Exported to Canada · Mobile, ALN8291YPiper PA-30 · S/N 30-1429Cancelled Mar 15, 1967 · Exported to Venezuela · Built 1967 · Mobile, AL
Back to Mobile Aircraft Inc