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.

N8260PPiper PA-24-250 · S/N 24-3513Cancelled Apr 26, 1977 · Exported to Australia · Airmart CorpN73517Cessna 172M · S/N 17267525Cancelled Apr 14, 1977 · Exported to Canada · Fulton Ait Service IncN8743QCessna U206 · S/N U20603496Cancelled Apr 8, 1977 · Exported to Japan · Aviation Sales CorporationN1720WBeech A60 · S/N P-206Cancelled Feb 3, 1977 · Exported to Venezuela · Built 1972 · Hangar One IncN29RXCessna 421B · S/N 421B0556Cancelled Jan 25, 1977 · J H Owen IncN62490Piper PA-23-250 · S/N 27-7654015Cancelled Jan 14, 1977 · Exported to United Kingdom · Epps Air ServiceN7403FHughes 269C · S/N 650413Cancelled Dec 14, 1976 · Exported to Sweden · Hughes Helicopters IncN6036YPiper PA-23-250 (6PCLM) · S/N 27-3221Cancelled Dec 3, 1976 · Three Six Yankee IncN5065RCessna A185F · S/N 18502994Cancelled Aug 5, 1976 · Exported to Sweden · Fulton Air Service IncN5398JCessna 421B · S/N 421B0948Cancelled Jul 24, 1976 · Southeastern Avn Underwriters IncN6146RCessna T210F · S/N T210-0046Cancelled Jun 28, 1976 · Brumby RichardN3316LDouglas DC-9-32 · S/N 47025Cancelled Jun 24, 1976 · Exported to Venezuela · Built 1967 · Delta Air AirportN11FLPiper PA-31 · S/N 31-232Cancelled Jun 22, 1976 · Built 1968 · Taylor Robert CN363QBeech 65 · S/N LC-92Cancelled Jun 11, 1976 · Exported to Honduras · Hanger 1 IncN8470JCessna 150G · S/N 15066370Cancelled May 27, 1976 · Built 1967 · Mobley School Of Aviation IncN7029Carter-Adams BALLOON · S/N 001Cancelled May 26, 1976 · Adams Michael DN582SMartin 404 · S/N 14239Cancelled May 25, 1976 · Southern Airways IncN53SPBell 47G-3B-1 · S/N 668094Cancelled May 24, 1976 · Department Of Public Safety Georgia State PatrolN3659UCessna 182G · S/N 18255059Cancelled May 11, 1976 · Sale reported · Built 1963N4006LCessna 421A · S/N 421A0106Cancelled Apr 1, 1976 · Sale reported · Built 1969N9328SBeech B24R · S/N MC344Cancelled Feb 20, 1976 · Exported to Paraguay · Hangar One IncN837QBeech 65 · S/N LC-75Cancelled Jan 30, 1976 · Exported to Honduras · Hangar One IncN48VABeech 65-B80 · S/N LD-373Cancelled Jan 13, 1976 · Exported to Venezuela · Built 1968 · Hangar One IncN4508SBeech V35B · S/N D-9796Cancelled Jan 6, 1976 · Exported to Paraguay · Built 1975 · Hangar One IncN65039Bell TH-13T · S/N 3595Cancelled Nov 24, 1975 · Sale reportedN65157Bell TH-13T · S/N 3610Cancelled Nov 24, 1975 · Sale reportedN181ZAero Commander 500-B · S/N 1310-122Cancelled Nov 18, 1975 · U S Dept Of Agriculture Forest ServiceN68598Bellanca 8KCAB · S/N 46-72Cancelled Nov 13, 1975 · Exported to Canada · Aerobatic AtlantaN8991FHughes 269C · S/N 730225Cancelled Oct 21, 1975 · Built 1973 · City Of AtlantaN9564FHughes 269B · S/N 110 0456Cancelled Oct 3, 1975 · Atlanta Police Department Cty Of AtlantaN96GCNorth American B-25H · S/N 98-21337Cancelled Sep 30, 1975 · Sale reported · Built 1943N18631Cessna 150L · S/N 150-74001Cancelled Sep 26, 1975 · Built 1972 · Fulton Air Service IncN1011BC Piel Emeraude CP-301-A · S/N W-1Cancelled Jul 21, 1975 · Wicker Roy CN8444GCessna 150F · S/N 15062544Cancelled Jun 30, 1975 · Bagley H TN2592QCessna 150G · S/N 15066902Cancelled Jun 11, 1975 · Dockery John LN5849Hagaman B-8MG · S/N 1Cancelled Jun 9, 1975 · Hagaman Len D JrN3964ABeech C-45 · S/N 44-87110ACancelled Jun 3, 1975 · Grogan NashN2090CBeech 95 · S/N TD-274Cancelled May 20, 1975 · Southern Airways CompanyN7297RBeech V35B · S/N D-9733Cancelled Apr 14, 1975 · Exported to Brazil · Hangar One IncN4057SBeech V35B · S/N D-9704Cancelled Jan 23, 1975 · Exported to Argentina · Hangar One IncN8575RBeech A36 · S/N E-604Cancelled Dec 11, 1974 · Exported to Paraguay · Built 1974 · Hangar One IncN9380YBeech N35 · S/N D-6571Cancelled Oct 25, 1974 · Baker JerryN25743Beech V35B · S/N D-9545Cancelled Sep 13, 1974 · Exported to Brazil · Hanger One IncN251WPBeech V35B · S/N D9639Cancelled Aug 23, 1974 · Exported to Brazil · Hanger One IncN4873CDouglas DC-7 · S/N 44263Cancelled Aug 2, 1974 · Delta Air Lines IncN6137ZPiper PA-25 · S/N 25-161Cancelled Jul 26, 1974 · State Of GeorgiaN38JBDouglas DC3C · S/N 4760Cancelled Jul 24, 1974 · Exported to Canada · Built 1947 · Georgia Institutional Funding IncN234GBeech C18S · S/N 44-47606Cancelled Jul 18, 1974 · Atlanta Area Technical SchoolN1901MDouglas DC-6 · S/N 43139Cancelled Jul 11, 1974 · Delta Air Lines IncN1903MDouglas DC-6 · S/N 42897Cancelled Jul 11, 1974 · Delta Air Lines Inc
Back to Atlanta, GA