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.
N14824Bell 206B · S/N 853N14549Semco Balloon MARK V · S/N SEM-145N15328Taylor E-2 · S/N 248N142JFBell 206B · S/N 2849N90454Aerostar International RAVEN S57-A · S/N S57A-3139N36MPBeech A36 · S/N E-1979N623CQBeech A36 · S/N E-1382N772DAMitsubishi MU-2B-60 · S/N 772 S.A.N601DLBoeing 757-232 · S/N 22808N232ASEmbraer EMB-120RT · S/N 120.036N540WDFrank James H F1 ROCKET · S/N 035N9916UGrumman American Avn. AA-5A · S/N AA5A0316N824AMRobinson Helicopter R44 II · S/N 10029N1CRRaytheon 390 · S/N RB-146N236WABoeing 737-247 · S/N 23184N237WABoeing 737-247 · S/N 23185N238WABoeing 737-247 · S/N 23186N239WABoeing 737-247 · S/N 23187N324DLBoeing 737-232 · S/N 23096N325DLBoeing 737-232 · S/N 23097N2061DSchweizer 269D · S/N 0034AN2494LBell 206L · S/N 45028N404SSDornier Luftfahrt 328-100 · S/N 3090N250SEEllsworth Scott P SKYBOLT · S/N 1N46WQHawker Siddeley HS.125 SERIES 700A · S/N NA0334N104EXExtra Flugzeugbau EA-300 · S/N 010N46491Cessna 172K · S/N 17257302N503ASEmbraer EMB-120ER · S/N 120-275N45FSCessna 501 · S/N 501-0102N26174Cessna 172R · S/N 17280556N264ASEmbraer EMB-120ER · S/N 120.165N272AMCessna 172N · S/N 17269224N3450RPiper PA-28-180 · S/N 28-5684N107MGBeech B200 · S/N BB-924N737DLockheed L-1011-385-1-15 · S/N 193C-1228N838DWCessna 177B · S/N 17701607N567SMLemon Richard AVID MARK IV · S/N 1401N1739DLockheed L-1011-385-1-15 · S/N 193C-1237N8807LPiper PA-25-235 · S/N 25-5304N755AFMitsubishi MU-2B-60 · S/N 755SAN26486Cessna 172R · S/N 17280538N741DALockheed L-1011-385-1 · S/N 193C-1245N283UEEmbraer EMB-120RT · S/N 120.139N2521DCessna 170B · S/N 20673N960VVDouglas DC-9-31 · S/N 47067N230ASEmbraer EMB-120RT · S/N 120.032N269UEEmbraer EMB-120RT · S/N 120.194N8078VEmbraer EMB-120 · S/N 120242N150EFEagle EAGLE 150B · S/N 030N151EFEagle EAGLE 150B · S/N 036
Back to Atlanta, GA