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.

N4879CDouglas DC-7 · S/N 44683Cancelled May 19, 1967 · Delta Air Lines IncN802EDouglas DC-8-51 · S/N 45409Cancelled Apr 25, 1967 · Delta Air Lines IncN7196UMooney M20E · S/N 414Cancelled Mar 17, 1966 · Epps Aircraft IncN7960ECessna 150 · S/N 17760Cancelled Feb 14, 1966 · Georgia Tech Flying Club IncN4819UCessna 210-5A(205A) · S/N 205-0519Cancelled Dec 21, 1965 · Rybert Printing CoN586SMartin 404 · S/N 14245Cancelled Oct 8, 1965 · Southern Airways IncN8379PPiper PA-24-250 · S/N 24-3638Cancelled Jul 16, 1965 · Executive Aviation Co IncN557BBeech A35 · S/N D-1577Cancelled May 25, 1965 · Paul MaxwellN74239Bellanca 14-13-2 · S/N 1352Cancelled May 25, 1965 · Charles W Mills JrN8202HBeech C-45H · S/N AF-442Cancelled May 25, 1965 · State Of Georgia Department Of DefenseN6477PPiper PA-24-250 · S/N 24-1593Cancelled May 22, 1965 · Gremmel W WN1556SBeech 35-B33 · S/N CD-526Cancelled May 21, 1965 · Southern Airways CompanyN46553Fairchild M-62A · S/N T41-769Cancelled May 21, 1965 · Flightways IncN5977XBrantly B-2A · S/N 159Cancelled May 14, 1965 · Rebel Rotors Of Georgia IncN5854PPiper PA-24 · S/N 24-936Cancelled Sep 29, 1964 · Walker Rexford DN6264UMooney M20C · S/N 2103Cancelled Apr 23, 1964 · Exported to Canada · Freiwald Paul RN3476APiper PA-22 · S/N 22-1746Cancelled Dec 6, 1963 · Maico Carl NicholasN4891CDouglas DC-7B · S/N 45355Cancelled Nov 12, 1963 · Delta Air Lines IncN6767DBell 47G-2 · S/N 2260Cancelled Apr 9, 1963 · Exported to Peru · Atlanta Helicopter Airways IncN5891PPiper PA-24-180 · S/N 24-976Cancelled Apr 27, 1961 · Olsson Eric OlofN2564DCessna 170B · S/N 20716Cancelled Dec 5, 1960 · Aero CorpN8804EConvair 22 · S/N 16Cancelled Sep 21, 1960 · Delta Air Lines IncN7203DPiper PA-22-150 · S/N 22-5027Cancelled Sep 7, 1960 · Home Mission BoardN6778JCessna 310D · S/N 39078Cancelled Aug 2, 1960 · De Kalb Aviation CorporationN55331Cessna T-50 · S/N 4866Cancelled Jan 29, 1960 · Flightways IncN90171Cessna 140 · S/N 9236Cancelled Nov 24, 1959 · V M C Products IncN9122EAeronca 11AC · S/N 11AC-755Cancelled Sep 24, 1959 · Aero CorpN3912PPiper PA-22-150 · S/N 22-3582Cancelled Sep 4, 1959 · Built 1956 · Weaver IncN69572Fairchild PT-26 · S/N T42-4122Cancelled Jul 8, 1959 · Barrett M LN8050BCessna 172 · S/N 29850Cancelled Jun 30, 1959 · Exported to Canada · Columbia Sewing Machine CoN4082Mooney M-18C · S/N 269Cancelled Mar 6, 1959 · Built 1952 · Lines W BN70327Piper J3C-65 · S/N 17307Cancelled Jan 5, 1959 · Fulton Air Service IncN7126BPiper PA-22-150 · S/N 22-4344Cancelled Nov 26, 1958 · Automatic Car Wash Equipment CoN2742NCessna 140 · S/N 13000Cancelled May 2, 1958 · Schneider J FN3409HEngineering & Research 415-C · S/N 4034Cancelled Mar 28, 1957 · Built 1946 · Wright Thomas L EtalN61991Beech C18S · S/N 6549Cancelled Jan 22, 1957 · Southern Airways CoN5827ACessna 172 · S/N 28427Cancelled Aug 28, 1956 · Fulton Air Service IncN3784CConsolidated Vultee PBY-5A · S/N 1636Cancelled Jul 25, 1956 · Exported to Colombia · Aero CorpN58336Fairchild PT-19A · S/N T41-692Cancelled Apr 30, 1956 · Daniel Jr Thomas HN98960Piper PA-12 · S/N 12-314Cancelled Apr 30, 1956 · Franklin Calvin CN87797Piper J3C-65 · S/N 15455Cancelled Mar 20, 1956 · Built 1946 · Hightower N HN58393Boeing A75N1 · S/N 75-2887Cancelled Mar 7, 1956 · Cox Thomas B & John S Wooton JrN43128Taylorcraft BC12-D · S/N 6787Cancelled Feb 29, 1956 · Flightways IncN18006Porterfield 35-70 · S/N 248Cancelled Feb 28, 1956 · Built 1937 · Dodd A PN99480Ercoupe 415-C · S/N 2103Cancelled Feb 28, 1956 · Built 1946 · Darden MiltonN6038KRepublic RC-3 · S/N 213Cancelled Feb 14, 1956 · Southern Airways CoN3108VBeech 35 · S/N D-530Cancelled Nov 30, 1955 · Guy T Gunter JrN51389Cessna T-50 · S/N 5074Cancelled Nov 28, 1955 · Aero CorpN71876Luscombe 8A · S/N 3303Cancelled Nov 14, 1955 · Gaston Robert NN49905Piper J-3C · S/N 9952Cancelled Oct 24, 1955 · Lakewood Airport Center
Back to Atlanta, GA