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.
N8260PPiper PA-24-250 · S/N 24-3513N73517Cessna 172M · S/N 17267525N8743QCessna U206 · S/N U20603496N1720WBeech A60 · S/N P-206N29RXCessna 421B · S/N 421B0556N62490Piper PA-23-250 · S/N 27-7654015N7403FHughes 269C · S/N 650413N6036YPiper PA-23-250 (6PCLM) · S/N 27-3221N5065RCessna A185F · S/N 18502994N5398JCessna 421B · S/N 421B0948N6146RCessna T210F · S/N T210-0046N3316LDouglas DC-9-32 · S/N 47025N11FLPiper PA-31 · S/N 31-232N363QBeech 65 · S/N LC-92N8470JCessna 150G · S/N 15066370N7029Carter-Adams BALLOON · S/N 001N582SMartin 404 · S/N 14239N53SPBell 47G-3B-1 · S/N 668094N3659UCessna 182G · S/N 18255059N4006LCessna 421A · S/N 421A0106N9328SBeech B24R · S/N MC344N837QBeech 65 · S/N LC-75N48VABeech 65-B80 · S/N LD-373N4508SBeech V35B · S/N D-9796N65039Bell TH-13T · S/N 3595N65157Bell TH-13T · S/N 3610N181ZAero Commander 500-B · S/N 1310-122N68598Bellanca 8KCAB · S/N 46-72N8991FHughes 269C · S/N 730225N9564FHughes 269B · S/N 110 0456N96GCNorth American B-25H · S/N 98-21337N18631Cessna 150L · S/N 150-74001N1011BC Piel Emeraude CP-301-A · S/N W-1N8444GCessna 150F · S/N 15062544N2592QCessna 150G · S/N 15066902N5849Hagaman B-8MG · S/N 1N3964ABeech C-45 · S/N 44-87110AN2090CBeech 95 · S/N TD-274N7297RBeech V35B · S/N D-9733N4057SBeech V35B · S/N D-9704N8575RBeech A36 · S/N E-604N9380YBeech N35 · S/N D-6571N25743Beech V35B · S/N D-9545N251WPBeech V35B · S/N D9639N4873CDouglas DC-7 · S/N 44263N6137ZPiper PA-25 · S/N 25-161N38JBDouglas DC3C · S/N 4760N234GBeech C18S · S/N 44-47606N1901MDouglas DC-6 · S/N 43139N1903MDouglas DC-6 · S/N 42897
Back to Atlanta, GA