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.
N9226BCessna 175 · S/N 55026N3167WBeech F33A · S/N CE-511N1952MGrumman TBM-3 · S/N 85890N9321VMooney M20F · S/N 700001N1187Douglas DC3-G202A · S/N 4145N5834GCessna 150K · S/N 15071334N2457JCessna 150G · S/N 15065557N3207CBeech E35 · S/N D3865N143SMartin 404 · S/N 14237N401RACessna 401A · S/N 401A0117N1668WBeech F33A · S/N CE-396N12CWAero Commander 680-E · S/N 680E-886-95N40LBLearjet 25 · S/N 25-009N8191JBell 206A · S/N 569N1540WBeech F33A · S/N CE-368N10JJPiper PA-28R-180 · S/N 28R-31047N8980FHughes 269C · S/N 230185N8981FHughes 269C · S/N 1120169N9258RLockheed 382B · S/N 4170N1308Frew John M JR PIEL EMERAUDE 301 · S/N 1172N4345GMcculloch J-2 · S/N 055N9680FHughes 269C · S/N 410112N9690FHughes 269C · S/N 410113N7802WPiper PA-28-180 · S/N 28-1803N1077UPiper PA-34 · S/N 34-7250076N40262Piper PA-23-250 · S/N 27-7305075N469PNorth American P-51D · S/N 44-73240N9149RNorth American F-51D · S/N 44-74441N789KBBeech V35A · S/N D-8947N4432WAero Commander 680FL · S/N 1336-21N2568JCessna 150E · S/N 15061068N8807EConvair 22 · S/N 29N1792ZCessna 336 · S/N 336-0092N14271Piper PA-23-250 · S/N 27-4832N8979YPiper PA-39 · S/N 39-145N61254Cessna 150 · S/N 15070919N3650ZPiper PA-22-150 · S/N 22-7547N4738GSchreder HP-12 · S/N 1N3305LDouglas DC-9-14 · S/N 45700N146SMartin 404 · S/N 14223N148SMartin 404 · S/N 14160N9968RBeech D50C · S/N DH-268N8087RBeech D55 · S/N TE-723N9421FHughes 269B · S/N 15-0153N9313QBeech 58 · S/N TH-181N6118UMeadowcroft CHINOOK · S/N T-3N139KBeech E18S · S/N BA-188N74498Bellanca 14-13-2 · S/N 1511N4961DCessna 182A · S/N 51061N14019Piper PA-23-250 · S/N 27-4633
Back to Atlanta, GA