Atlanta, GA

Cancelled registrations · 1,436

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 = 'GA' AND d.registrant_city = 'ATLANTA'
  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.

N183KMonocoupe 90 · S/N 517Cancelled Mar 7, 1939 · Burden Lee RN255MWaco 9 · S/N 356Cancelled Sep 15, 1938 · Built 1927 · Blevins Aircraft CorpN12668Taylor E-2 · S/N 40Cancelled Jul 1, 1937 · Haygood Guy BN859NBellanca CH300 PACEMAKER · S/N 182Cancelled Jan 29, 1937 · Exported to Mexico · Irwin W HN4218Waco GXE · S/N 963Cancelled Sep 7, 1936 · Built 1928 · Nesmith CulverN645MFleet 2 · S/N 220Cancelled Apr 24, 1936 · Air Service IncN15270Aeronca C-3 · S/N A-592Cancelled Nov 15, 1935 · Air Service IncN6083Travel Air Mfg 2000 · S/N 587Cancelled Sep 12, 1935 · Mccord Herschell/Sutherland O L(Deceased) Cox T BN1574Waco 9 · S/N 331Cancelled May 15, 1935 · Built 1928 · Trammell Mark LafeyetteN12376Curtiss Wright T-32 · S/N 37Cancelled Feb 12, 1935 · Built 1933 · Eastern Air TransportN10750Pitcairn PA8 · S/N 161Cancelled Nov 28, 1934 · Built 1931 · Eastern Air Transport IncN10752Pitcairn PA8 · S/N 163Cancelled Nov 16, 1934 · Built 1931 · Eastern Air Transport IncN1942Curtiss JN4D · S/N 34004Cancelled Sep 8, 1934 · Davis Douglas HN629VCurtiss Wright KINGBIRD D-2 · S/N 2015Cancelled Apr 1, 1934 · Eastern Air Transport IncN12373Curtiss Wright T-32 · S/N 34Cancelled Sep 28, 1933 · Built 1933 · Eastern Air Transport IncN11438Waco QDC · S/N 3504Cancelled May 22, 1933 · Built 1931 · Candler John HN995Pitcairn PA-3 OROWING · S/N 31Cancelled Feb 11, 1933 · Built 1927 · Maughon S TN10754Pitcairn PA8 · S/N 165Cancelled Nov 29, 1932 · Built 1931 · Eastern Air Transport IncN8670Curtiss Wright FALCON MAILPLANE · S/N 16Cancelled May 17, 1932 · Atlanta Technological High SchoolN9411Southern AIR BOSS · S/N 5Cancelled Oct 13, 1930 · Harper E AN8408Ford 4-AT-E · S/N 70Cancelled Oct 4, 1930 · Built 1929 · Eastern Air Transport IncN280VAtlanta Aircaft ATLANTA PW-2 · S/N 1Cancelled Aug 1, 1930 · Atlanta Aircraft CorpN5465Waco 9 · S/N 325Cancelled Jul 8, 1930 · Built 1926 · W E Dobbins JrN1835Advance WACO 9 · S/N 92Cancelled Apr 30, 1930 · Built 1926 · Fincher Henry HobsonN127EPitcairn PA-6 · S/N 14Cancelled Apr 4, 1930 · Built 1928 · Eastern Air Transport IncN4201Waco 10 · S/N 1159Cancelled Mar 20, 1930 · Built 1928 · Johnson T F JrN536MLockheed VEGA 5B · S/N 105Cancelled Mar 20, 1930 · Built 1929 · Candler Asa G JrN1750Alexander COMBINATION EAGLEROC · S/N 190Cancelled Mar 19, 1930 · Built 1927 · Blevins BeelerN1962Ryan B1 · S/N 44Cancelled Mar 19, 1930 · Blevins BellerN4194Kreider-Reisner C-2 · S/N 135Cancelled Mar 19, 1930 · Blevins BeelerN692Curtiss JN4D · S/N 353Cancelled Feb 28, 1930 · Built 1917 · Allen Kenneth FN3781Waco 9 · S/N 186Cancelled Feb 20, 1930 · Built 1926 · Mason George HN7116Curtiss Wright JN4D · S/N 3571Cancelled Feb 20, 1930 · Standard Auto Service CoN1913MCurtiss Wright C-46F · S/N 22468 (44-78645)Cancellation date not recorded · US AirlinesN55848Cessna T-50 · S/N 3779Cancellation date not recorded · Built 1943 · H L Young JrN599NCurtiss Wright KINGBIRD D-2 · S/N 2005Cancellation date not recorded · Built 1930 · Eastern Air Transport Inc
Back to Atlanta, GA