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.

N87930Piper J3C-65 · S/N 15548Cancelled Jun 14, 1949 · Lakewood Airport CenterN18426Consolidated Vultee PBY-5A · S/N 71Cancelled May 26, 1949 · Exported to Netherlands · Aero CorpN41364Consolidated PBY-5A · S/N 86Cancelled May 26, 1949 · Exported to Netherlands · Built 1942 · Aero CorporationN54819Consolidated Vultee BT-13A · S/N 1221Cancelled May 26, 1949 · Clay H W JrN95403Consolidated Vultee PBY-5A · S/N 121Cancelled May 16, 1949 · Exported to Colombia · Aero CorpN96455Taylorcraft BC12-D · S/N 8755Cancelled May 12, 1949 · Southern AirwaysN74693Consolidated Vultee PBY-5A · S/N 482Cancelled Apr 29, 1949 · Exported to Netherlands · Aero CorpN88755Cessna T-50 · S/N 5470Cancelled Apr 22, 1949 · Gate City Aero ServiceN91657North American NAVION · S/N NAV-4-407Cancelled Apr 13, 1949 · Exported to Colombia · Aero-CorpN55780Cessna T-50 · S/N 6323Cancelled Mar 3, 1949 · Young H S JrN79046Cessna AT-17 · S/N 3473Cancelled Mar 2, 1949 · Stokes Charles AN50625Fairchild M-62A · S/N T43-7011Cancelled Feb 2, 1949 · Aero CorpN36743Stinson 10A · S/N 8143Cancelled Jan 6, 1949 · Built 1941 · Medlen FrankN4690MPiper PA-11 · S/N 11-199Cancelled Jan 6, 1949 · Exported to Cuba · Aero CorpN46742Ryan Aeronautical ST3KR · S/N 1550Cancelled Dec 31, 1948 · Southeastern Air Service IncN55145Cessna T-50 · S/N 5079Cancelled Dec 31, 1948 · Southeastern Air Service IncN51761Cessna T-50 · S/N 5702Cancelled Dec 3, 1948 · Southern AirwaysN46754Ryan Aeronautical ST3KR · S/N 1958Cancelled Oct 18, 1948 · Southern AirwaysN38805Piper J3L-65 · S/N 7282Cancelled Sep 21, 1948 · Built 1941 · Southeastern Air Service IncN41101Piper J3L-65 · S/N 7748Cancelled Sep 17, 1948 · Southeastern Air Service IncN22663Taylorcraft BL · S/N 1310Cancelled Sep 1, 1948 · Bland George AN36706Stinson 10A · S/N 8106Cancelled Aug 30, 1948 · Built 1941 · Aero CorpN36708Stinson 10A · S/N 8108Cancelled Aug 30, 1948 · Built 1941 · Aero CorpN32406Porterfield LP-65 · S/N 836Cancelled Aug 19, 1948 · Built 1940 · Southeastern Air Service IncN21564Piper J3C-50 · S/N 2412Cancelled Jun 18, 1948 · Built 1938 · General Discount CorpN21089Aeronca KCA · S/N KCA-61Cancelled May 19, 1948 · Clay Horace WN19368Waco AVN-8 · S/N 5106Cancelled May 14, 1948 · Built 1938 · Southeastern Air Service IncN16230Waco YKS-6 · S/N 4455Cancelled May 12, 1948 · Built 1936 · Aero CorporationN15868Porterfield 35-70 · S/N 168Cancelled Apr 15, 1948 · Built 1935 · General Discount CorpN16125Stinson SR-7B · S/N 9687Cancelled Apr 13, 1948 · Southern Airways IncN10843Stinson SM-6000-B · S/N 5042Cancelled Apr 5, 1948 · Exported to Mexico · Built 1931 · Blevins Aircraft CorpN10017Bellanca CH300 PACEMAKER · S/N 112Cancelled Mar 30, 1948 · Built 1928 · Smith Wray BN400NTravel Air E-4000 · S/N 1330Cancelled Feb 24, 1948 · Built 1929 · General Discount CorpN2574MPiper PA-12 · S/N 12-943Cancelled Feb 19, 1948 · Exported to Honduras · Blevins Aircraft CorpN49822Cessna T-50 · S/N 5998Cancelled Jan 14, 1948 · Southern Chartes IncN53552Ryan Aeronautical ST3KR · S/N 2081Cancelled Nov 17, 1947 · Southeastern Air Service IncN2848VBeech 35 · S/N D-253Cancelled Nov 12, 1947 · Southern Airways CoN3285NPiper J3C-65 · S/N 22481Cancelled Sep 2, 1947 · Built 1946 · Clay H WN39274Taylorcraft BC12-D · S/N 6258Cancelled Aug 28, 1947 · Built 1945 · Wylie R J & Greene George WN49657Douglas DC3C-S1C3G · S/N 9066Cancelled May 20, 1947 · Delta Air Lines IncN19362Waco ZVN-8 · S/N 5103Cancelled Jun 3, 1946 · Built 1938 · Clay Horace WN34860Culver LFA · S/N 270Cancelled Jun 26, 1945 · Southeastern Air Service IncN14594Stinson SR-5A · S/N 9346ACancelled May 23, 1944 · Built 1935 · Aero CorpN39458Stinson 10A · S/N 8258Cancelled Nov 3, 1943 · Built 1942 · Aero CorporationN39493Stinson 10A · S/N 8193Cancelled Nov 3, 1943 · Built 1942 · Aero CorporationN2577Waco 9 · S/N A-879Cancelled Aug 29, 1942 · Smith B WrayN16253Aeronautical AERONCA LA · S/N 2013Cancelled Jun 1, 1941 · Built 1936 · White Jack CN29289Culver LCA · S/N 158Cancelled Mar 27, 1941 · Bullock Robert BruceN17224Taylor J-2 · S/N 890Cancelled Dec 1, 1939 · Built 1936 · Clay Horace WeldonN9353Southern AIR BOSS · S/N 3Cancelled Mar 15, 1939 · Amos Dale C
Back to Atlanta, GA