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.
N481DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53315N459BCMcdonnell Douglas MD-90-30 · S/N 53570N483DNMcdonnell Douglas DC-9-82 · S/N 49382N484DNMcdonnell Douglas DC-9-82 · S/N 49999N485DNMcdonnell Douglas DC-9-82(MD-82) · S/N 49380N486DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53001N487DNMcdonnell Douglas DC-9-82 · S/N 53002N488DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53000N496DNMcdonnell Douglas DC-9-82 · S/N 49603N368PDHughes OH-6A · S/N 1180900N764NCMcdonnell Douglas DC-9-51 · S/N 47717N766NCMcdonnell Douglas DC-9-51 · S/N 47739N770NCMcdonnell Douglas DC-9-51 · S/N 47758N773NCMcdonnell Douglas DC-9-51 · S/N 47775N775NCMcdonnell Douglas DC-9-51 · S/N 47785N780NCMcdonnell Douglas DC-9-51 · S/N 48102N784NCMcdonnell Douglas DC-9-51 · S/N 48109N786NCMcdonnell Douglas DC-9-51 · S/N 48148N787NCMcdonnell Douglas DC-9-51 · S/N 48149N936CACanadair CL-600-2B19 · S/N 7043N877LXArbc Inc DBA Lindstrand 60X · S/N 5417N1608DMcdonnell Douglas Helicopter 369E · S/N 0434EN303RBeech D35 · S/N D-3530N1309TDouglas DC-9-31 · S/N 47316N3324LDouglas DC-9-32 · S/N 47103N8920EDouglas DC-9-31 · S/N 45835N8921EDouglas DC-9-31 · S/N 45836N8929EDouglas DC-9-31 · S/N 45866N8938EDouglas DC-9-31 · S/N 47161N89SDouglas DC-9-31 · S/N 47042N915RWDouglas DC-9-31 · S/N 47139N921RWDouglas DC-9-31 · S/N 47164N923RWDouglas DC-9-31 · S/N 47183N9332Douglas DC-9-31 · S/N 47264N9341Douglas DC-9-31 · S/N 47390N9343Douglas DC-9-31 · S/N 47439N9344Douglas DC-9-31 · S/N 47440N9347Mcdonnell Douglas DC-9-32 · S/N 45827N9348Douglas DC9-15 · S/N 45787N943NMcdonnell Douglas DC-9-32 · S/N 47647N2286DGates Learjet 35A · S/N 482N377TWScott O V JR WITTMAN TAILWIND W-8 · S/N 103N2012TCessna 172N · S/N 17273550N9046HAerostar International RAVEN S57-A · S/N S57A-3140N22398Aeronca 65-LA · S/N L-3979N9071MBalloon Works FIREFLY 7 · S/N F7-638N9416MCessna 210M · S/N 21062074N973NAAerospatiale/Aeritalia ATR 42-300 · S/N 065N420ZAZenair CH 2000 · S/N 200042N67544Cessna 152 · S/N 15281903
Back to Atlanta, GA