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.
N9432XCessna 210A · S/N 21057732N46045Cessna 172I · S/N 172-57008N1261North American NAVION · S/N NAV-4-728N400CPAero Commander 1121 · S/N 30N1671Bensen Gyrocopter B-8MJ · S/N R-167N51700Douglas DC-7B · S/N 44700N52363Aeronca 0-58B · S/N 058B-12013N9009Briegleb BG-12BD · S/N 143N74875Mcavoy James C JR MPA-1 · S/N 1N4228NCessna 140 · S/N 13699N42686Piper J3C-65 · S/N 14982N7982MBeech 95-C55 · S/N TE-230N49679Cessna T-50 · S/N 5945N7166CBeech C18S · S/N 7896N8300JCessna 150G · S/N 15066200N28343Douglas DC3 · S/N 2267N1200MDouglas DC3 · S/N 4962N357GDehavilland DH-104 · S/N 04309N4157UCessna 150D · S/N 15060157N4270CDehavilland DH104 DOVE 6A · S/N 04317N49833Fairchild M-62A · S/N 9224AEN50802Fairchild 24W-41A · S/N W41A-508N54GYellow Jacket 1 · S/N 1N741JConvair 240 · S/N 146N6841TCessna 310D · S/N 39141N1609Beech D17S · S/N 4865N1223PPiper PA-23 · S/N 23-243N5000SBeech D18S · S/N A-194N997MDouglas C54B-DC · S/N 27244N24477Taylorcraft BC-65 · S/N 1817N7553YPiper PA-30 · S/N PA 30-616N9586YBeech 95-A55 · S/N TC-361N7743ECessna 150 · S/N 17543N885CStinson 108-3 · S/N 108-3885N3972UCessna 150E · S/N 15061372N5696ECessna 150 · S/N 17196N6137TCessna 150E · S/N 15060837N2219UBrantly 305 · S/N 1027N29394Cessna 177 · S/N 17700860N6551TCessna 150 · S/N 17951N6666CConvair 440 · S/N 450N51359Douglas DC3 · S/N 13759N99692Engineering & Research 415-C · S/N 2315N3484Beech UC-45J · S/N 039208N1902MDouglas DC-6 · S/N 43140N4820CConvair 340-38 · S/N 152N4124TCessna 320D · S/N 320D0024N2677BAero Commander 560 · S/N 560177N8821SCessna 150F · S/N 15062121N7007FCessna 150F · S/N 15063607
Back to Atlanta, GA