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.
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
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.
N2809WBoeing 727-247 · S/N 20581N485DABoeing 727-232 · S/N 20865N2810WBoeing 727-247 · S/N 20648N2811WBoeing 727-247 · S/N 20649N481DABoeing 727-232 · S/N 20861N484DABoeing 727-232 · S/N 20864N483DABoeing 727-232 · S/N 20863N455UEEmbraer EMB-120RT · S/N 120.163N1999LBoeing 737-205 · S/N 21184N210NEBoeing 727-31 · S/N 18903N751DALockheed L-1011-385-3 · S/N 193W-1166N920VVMcdonnell Douglas DC-9-32 · S/N 47262N14493Reims CESSNA FR172J · S/N 0444N2853KLuscombe 8A · S/N 5580N8MQGates Lear Jet 25B · S/N 085N715DALockheed L-1011-385-1 · S/N 193C1092N72710National Ballooning 858 · S/N 122N908VJDouglas DC-9-32 · S/N 47321N8054UBeech F33A · S/N CE1662N904VJDouglas DC-9-32 · S/N 47377N785DLLockheed L-1011-385-1 · S/N 193A1121N713DALockheed L-1011-385-1 · S/N 193C1089N3086TBeech A36 · S/N E2309N1865DBeech B200 · S/N BB1119N31SECessna 208B · S/N 208B0303N781DLLockheed L-1011-385-1 · S/N 193A1003N256ASEmbraer EMB-120 · S/N 120122N59869Piper PA-31-325 · S/N 317612070N530DABoeing 727-232 · S/N 21813N65DAEmbraer EMB-110P1 · S/N 110389N36LCBeech 58P · S/N TJ28N8994FHughes 269C · S/N 830228N551TJPdps Pzl-Bielsko SZD-55-1 · S/N 551192029N7557NCessna TU206G · S/N U20603670N9340DCessna 172RG · S/N 172RG1127N301DEBoeing 737-332 · S/N 25994N302DEBoeing 737-332 · S/N 25995N86CEBell 206L-3 · S/N 51400N200ELBeech 200 · S/N BB870N23577Beech A36 · S/N E1091N304DEBoeing 737-332 · S/N 25997N305DEBoeing 737-332 · S/N 25998N250MCBeech D18S · S/N A94N8855VBellanca 17-31A · S/N 3249N3010CMcdonnell Douglas DC-9-82(MD-82) · S/N 49903N145PDDietrick Paul A ROTORWAY EXEC · S/N 2943N5545BBeech B200 · S/N BB1334N7138KDehavilland DHC-6-300 · S/N 477N4589VBeech 35 · S/N D1060N49449Cessna 152 · S/N 15281276
Back to Atlanta, GA