Athens, GA
Cancelled registrations · 52
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 = 'ATHENS' 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.
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 = 'ATHENS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N170LGBeech H-18 · S/N BA-666N2493TDJI SPARK · S/N 0ASUE89001019KN60CVBeard Charles W LONG-EZ · S/N 346N9398GCessna 182P · S/N 18260938N712MCDJI PHANTOM 3 PROFESSION · S/N P77DCF27010351N726NMDJI PHANTOM 2 VISION + · S/N PH645396361N706GBAero SP Z O O AT-4 LSA · S/N AT4-006N47CZCraig Westwood COZY MK IV · S/N 1147N30827Piper PA-28-161 · S/N 28-7816549N2699QCessna 182K · S/N 18257899N451LMLockheed Martin Procerus Tech INDAGO · S/N SN3551N55789Consolidated Vultee SNV-1 · S/N 791064N3408FCessna 182J · S/N 18257408N53PSAviat PITTS S-2B · S/N 5256N117DKMcelhannon David Fayette AVID MK IV SPEEDWING · S/N 1383DN130DGGarber DG-1 · S/N DG-1N6752TCessna 310D · S/N 39052N50072Boeing A75N1(PT17) · S/N 75-924N4398PPiper PA-23-160 · S/N 23-1910N24792Moody Michael T GOLDWING · S/N 45N2121JFuji LM I · S/N 21020N9256YPiper PA-31-310 · S/N 31-335N8319XCessna 172C · S/N 17248819N99332Ercoupe 415-C · S/N 1955N358DBRaytheon A36 · S/N E3518N5018SAir Tractor AT-301 · S/N 301-0107N9037RStaton Rocker T III STATON LMA LM-1011 · S/N 008N8054RBeech A24R · S/N MC-50N62986Piper PA-31 · S/N 31-7712005N704HUCessna 150M · S/N 15078631N3629LCessna 172G · S/N 17253798N139NSchleicher KA 6 E · S/N 4038N8075LCessna 172H · S/N 17256275N1119MCessna T337F · S/N 33701319N72355Cessna 140 · S/N 9539N3192Dixon PITTS SPECIAL S-1C · S/N JD-1N6894TCessna 310D · S/N 39194N4135DHelio H-391B · S/N 085N96597Taylorcraft BC12-D · S/N 8897N6885HPiper J3C-65 · S/N 20102N7199HPiper J3C-65 · S/N 20463N50590Piper J3C-65 · S/N 10741N88433Piper J-3C · S/N 16051N55327Boeing A75N1 · S/N 75-2399N16464Rearwin 7000 · S/N 489N70758Piper J3C65 · S/N 17776N685NWaco RNF · S/N 3237N14126Waco YKC · S/N 3998N11219Waco RNF · S/N 3395N74WEpps Ben T 1 · S/N 1
Back to Athens, GA