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.
N1797BDJI AGRAS T30 · S/N 527BK8C00100DJN916DEMcdonnell Douglas MD-88 · S/N 53421N911DLMcdonnell Douglas MD-88 · S/N 49542N962DLMcdonnell Douglas MD-88 · S/N 49981N965DLMcdonnell Douglas MD-88 · S/N 49984N973DLMcdonnell Douglas MD-88 · S/N 53241N987DLMcdonnell Douglas MD-88 · S/N 53338N910DNMcdonnell Douglas MD-90-30 · S/N 53390N964DLMcdonnell Douglas MD-88 · S/N 49983N309USAirbus Industrie A320-211 · S/N 118N671DNBoeing 757-232 · S/N 25332N10XNHonda HA-420 · S/N 42000038N103ZZBombardier BD-700-1A11 · S/N 9308N8775ABombardier CL-600-2B19 · S/N 7775N9128XCessna 182D · S/N 18253528N143RLHawker Beechcraft 4000 · S/N RC-25N66LFSportavia-Putzer FOURNIER R.F.4.D · S/N 4103N504SPTextron 525 · S/N 525-1032N8543FBombardier CL-600-2B19 · S/N 7543N794RWDJI PHANTOM 3 PROFESSION · S/N 1 P76DCF29016739N900DEMcdonnell Douglas MD-88 · S/N 53372N322USAirbus Industrie A320-211 · S/N 263N8721BBombardier CL-600-2B19 · S/N 7721N8907ABombardier CL-600-2B19 · S/N 7907N950DNMcdonnell Douglas MD-90-30 · S/N 53360N3072KPiper PA-28RT-201 · S/N 28R-7918010N395GTUnmanned Aerial Research OSPREY · S/N 99230000009N936DNMcdonnell Douglas MD-90-30 · S/N 53461N311EVMcdonnell Douglas MD-90-30 · S/N 53569N530USBoeing 757-251 · S/N 23845N909DAMcdonnell Douglas MD-90-30 · S/N 53389N992DLMcdonnell Douglas MD-88 · S/N 53344N928DNBoeing MD-90-30 · S/N 53590N931DNMcdonnell Douglas MD-90-30 · S/N 53544N949DNMcdonnell Douglas MD-90-30 · S/N 53358N980DLMcdonnell Douglas MD-88 · S/N 53267N985DLMcdonnell Douglas MD-88 · S/N 53312N3477PPiper PA-23 · S/N 23-1451N918DHMcdonnell Douglas MD-90-30 · S/N 53553N927DNBoeing MD-90-30 · S/N 53589N944DNMcdonnell Douglas MD-90-30 · S/N 53558N981DLMcdonnell Douglas MD-88 · S/N 53268N901DEMcdonnell Douglas MD-88 · S/N 53378N902DEMcdonnell Douglas MD-88 · S/N 53379N904DEMcdonnell Douglas MD-88 · S/N 53409N905DEMcdonnell Douglas MD-88 · S/N 53410N905DLMcdonnell Douglas MD-88 · S/N 49536N906DEMcdonnell Douglas MD-88 · S/N 53415N907DEMcdonnell Douglas MD-88 · S/N 53416N907DLMcdonnell Douglas MD-88 · S/N 49538
Back to Atlanta, GA