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.

N477SBCameron Balloons TR-70 · S/N 11015Cancelled May 29, 2013 · Exported to Japan · Built 2007 · Balloonpong Enterprises LLCN477XBUltramagic M-56C · S/N 56/33Cancelled May 29, 2013 · Exported to Japan · Built 2006 · Balloonpong Enterprises LLCN92933Cessna 172M · S/N 17261649Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1973 · Pollinger DarrylN91033Cessna 207 · S/N 20700023Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1969 · Trans Southern Airways IncN445CABeech B-60 · S/N P-411Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1977 · Zubowicz Aviation IncN8042NAero Commander 680V · S/N 1720/91Cancelled May 13, 2013 · Registration expired, pending cancellation · Business Aircraft CorpN80860Globe GC-1B · S/N 263Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1946 · Blue Lynn IN599LGBeech V35A · S/N D-8920Cancelled May 10, 2013 · Sale reported, canceled · Built 1969N8507FEagle Balloons C-7 · S/N E887112Cancelled May 10, 2013 · Sale reported, canceled · Built 1988N8511GCessna 172H · S/N 17255501Cancelled May 10, 2013 · Sale reported, canceled · Built 1966N995RSPiper PA-32R-301T · S/N 32R-8129036Cancelled May 10, 2013 · Sale reported, canceled · Built 1981N7748QCessna 310Q · S/N 310Q0248Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1971 · Brokers Auto WholesaleN78EBPiper PA-23-250 · S/N 27-7854116Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1978 · Blanchco LLCN93PPBeech B36TC · S/N EA-531Cancelled May 1, 2013 · Sale reported, pending cancellationN52495Cessna 177RG · S/N 177RG1200Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1977N9432TCessna 210 · S/N 57232Cancelled Apr 26, 2013 · Sale reported, pending cancellation · Built 1960N5541KBellanca 8KCAB · S/N 395-78Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1978 · Grane Aviation IncN5586NRidley Clay K SCORPION TOO · S/N RW6900Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1980 · Hammer Glen HN10PABeech A60 · S/N P-204Cancelled Apr 18, 2013 · Sale reported, pending cancellation · Built 1972N515UFBeech F50 · S/N FH-85Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1958 · Associated Auto Leasing IncN2008XCessna 182H · S/N 18256108Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1965N5315JAerostar International S-57A · S/N S57A-3234Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 2002 · Hooters Of America IncN9803NAdams Balloon A55 · S/N 168Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1986N99060Bell TH-13T · S/N 3512Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1965N9930LGrumman American Avn. AA-1B · S/N AA1B-0230Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1973N9316SBeech B19 · S/N MB-767Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1975N7112NBeech D55 · S/N TE-490Cancelled Mar 11, 2013 · Sale reported, pending cancellation · Built 1967N899CBCessna 150M · S/N 15076699Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1975N30273Lindstrand Balloons 90A · S/N 5116Cancelled Mar 7, 2013 · Sale reported, canceledN8038LCessna 172H · S/N 17256238Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1967N777MZAero Commander 680-E · S/N 723-29Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1959N57733Piper PA-36-285 · S/N 36-7660051Cancelled Feb 25, 2013 · Sale reported, pending cancellation · Built 1975N711BFBeech C-45H · S/N AF-300Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1953N6700ACessna 172 · S/N 28800Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1956N6742UMooney M20D · S/N 168Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1963N6813XCessna 172A · S/N 47713Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960N6862YPiper PA-23-250 · S/N 27-4207Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1969N60826Cessna 150J · S/N 15070604Cancelled Feb 12, 2013 · Exported to Argentina · Built 1969 · Betina EnterprisesN611CWBeech E18S · S/N BA-140Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1956N6285GCessna 150K · S/N 15071785Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1970N63ELCessna 310L · S/N 310L-0088Cancelled Feb 6, 2013 · Registration expired, pending cancellation · Built 1967 · N63el LLCN136BSBeech A36 · S/N E-1725Cancelled Jan 31, 2013 · Sale reported, pending cancellation · Built 1980N282SBBeech C24R · S/N MC-632Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1979N11ELDouglas DC3 · S/N 2105Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1939 · Buckland Jerry AN5493UBeech 95-C55 · S/N TE-424Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1967N5191WPiper PA-28 · S/N 28-226Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1961N4975WBen T. Epps BEN T. EPPS 1930 · S/N B.T.E.-3Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1964N126DKKohser Douglas A KR-2 · S/N DKKR001ACancelled Dec 7, 2012 · Sale reported, pending cancellation · Built 1983N49100Cessna 152 · S/N 15283418Cancelled Dec 7, 2012 · Sale reported, canceled · Built 1979N4735GCessna 172N · S/N 17273334Cancelled Nov 27, 2012 · Sale reported, canceled
Back to Atlanta, GA