OpenAirDocs.org
Mobile, AL

Cancelled registrations · 206

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_state = 'AL' AND d.registrant_city = 'MOBILE'
  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.

N71223Cessna U206F · S/N U20602129Cancelled Sep 11, 1980 · Bob-Air IncN77DCBeech D55 · S/N TE-651Cancelled Sep 11, 1980 · Mobile Air Center IncN7927CBeech C-45G · S/N 51-11785Cancelled Apr 10, 1980 · Teledyne Industries IncN4935KRyan NAVION A · S/N NAV-4-1935Cancelled Jul 12, 1979 · Herndon William DN6611SCessna 150H · S/N 15067411Cancelled Mar 15, 1979 · Tydings William HN80651Cessna A185F · S/N 18503133Cancelled Nov 3, 1978 · Exported to New Zealand · Robert MuddN563MADehavilland DHC-6 TWIN OTTER · S/N 196Cancelled Mar 3, 1978 · Kaymar Associates IncN59401Fairchild M-62A · S/N T42-3243Cancelled Jul 12, 1977 · Draper George EN7506VCessna 177RG · S/N 177RG0805Cancelled May 31, 1977 · Englund Leonard WN2720UCessna 172D · S/N 17250320Cancelled Sep 23, 1976 · Exported to Canada · Built 1963 · Chisolm Paul FN9422VMooney M20F · S/N 700028Cancelled May 19, 1976 · Exported to Canada · Native Towing Co IncN9005YPiper PA-31 · S/N 31-9Cancelled Oct 30, 1974 · Mobile Aircraft IncN4918UCessna 210E · S/N 21058618Cancelled Aug 9, 1974 · Commercial BuildersN4297MPiper PA-12 · S/N 12-3229Cancelled Aug 2, 1974 · Built 1947 · Stinson J LeslieN109MBeech C35 · S/N D-3169Cancelled Apr 2, 1974 · Built 1952 · Equipment Associates IncN8477TCessna 182C · S/N 52377Cancelled Sep 24, 1973 · Gordon Hugh BN3585BBeech B50 · S/N CH-54Cancelled Apr 5, 1973 · Exported to Honduras · Barbareta Beach Club IncN9114BCessna 172 · S/N 36614Cancelled Nov 28, 1972 · Alford John WN46059Aeronca 0-58B · S/N 058B2662Cancelled Nov 24, 1972 · Built 1945 · Smith Donald Allen JrN4041WPiper PA-32-300 · S/N 32-40040Cancelled Nov 15, 1972 · Mobile Aircraft CorpN1906KLuscombe 8E · S/N 4633Cancelled Aug 4, 1971 · Black Howard P & Alton PardenN8434PPiper PA-24-250 · S/N 24-3679Cancelled Mar 9, 1971 · Exported to Costa Rica · Taylor Jack RN46790Fairchild M-62 · S/N 8593AECancelled Nov 25, 1970 · F J FinkleaN7975ECessna 150 · S/N 17775Cancelled Jun 10, 1970 · Englund'S Flying ServiceN7171MCessna 175 · S/N 55471Cancelled Jun 9, 1970 · Englunds Flying ServiceN75201Consolidated Vultee BT-13A · S/N 6538Cancelled Jun 9, 1970 · Englulnd Leonard WN3465JCessna 150G · S/N 15066165Cancelled Jun 4, 1970 · Glund Leonard W DBA Glund Flying ServiceN1667JPiper PA-28-140 · S/N 28-24066Cancelled May 2, 1969 · Exported to Canada · Mobile Aircraft IncN9498YBeech 95-55 · S/N TC-62Cancelled Sep 12, 1968 · Exported to Morocco · Built 1961 · Mobile Aircraft IncN6305UAero Commander 680FL · S/N 1389-49Cancelled Jul 25, 1968 · Exported to Canada · Mobile Aircraft IncN408EEAero Commander 680-E · S/N 680E-665-8Cancelled Jun 13, 1968 · Built 1958 · Mobile Aircraft IncN6139VBeech 95-B55 · S/N TC-879Cancelled Feb 12, 1968 · Raines Leon LN7924VCessna 180H · S/N 18051824Cancelled Oct 30, 1967 · Exported to Canada · Mobile Aircraft IncN13110Piper PA-30 · S/N 30-628Cancelled Oct 17, 1967 · Exported to Canada · Mobile Aircraft IncN316ADouglas C-54E · S/N 27373Cancelled Sep 18, 1967 · Exported to Norway · Mobile Aircraft IncN6392YPiper PA-23-250 · S/N 27-3679Cancelled May 22, 1967 · Exported to Canada · Mobile Aircraft IncN5630YPiper PA-23-250 · S/N 27-2742Cancelled Mar 23, 1967 · Exported to Canada · Mobile Aircraft IncN8291YPiper PA-30 · S/N 30-1429Cancelled Mar 15, 1967 · Exported to Venezuela · Built 1967 · Mobile Aircraft IncN10574Beech A45 · S/N G-41Cancelled May 25, 1965 · U S Air ForceN5327YPiper PA-23-250 · S/N 27-2403Cancelled May 24, 1965 · Lapeyrouse R LudgerN4864DCessna 182A · S/N 34964Cancelled Nov 6, 1963 · Security Life & Accident Insurance CoN66479Boeing E75 · S/N 75-8467Cancelled Apr 18, 1955 · Exported to Guatemala · Meacham David EarlN5217MTaylorcraft BC12-D · S/N 10517Cancelled Apr 17, 1951 · Built 1947 · Englund E WN80899Globe GC-1A · S/N 302Cancelled Apr 5, 1951 · Charles J Cargile JrN5239MTaylorcraft BC12-D · S/N 10539Cancelled Mar 14, 1951 · Exported to Canada · Built 1947 · Englund L WN54692North American AT-6A · S/N 78-6337Cancelled Feb 13, 1951 · Albert M Vine JrN3049VBeech 35 · S/N D-462Cancelled Jun 8, 1950 · Boddie S KN94301Engineering & Research 415-C · S/N 1524Cancelled Jul 28, 1949 · Built 1946 · Springer K JN3470NPiper J3C-65 · S/N 22690Cancelled Jun 2, 1949 · Aeromarine Corporation Of MobileN52539Boeing A75N1 · S/N 75-3134Cancelled Nov 18, 1948 · Brown Joseph E
Back to Mobile, AL