Augusta, GA
Cancelled registrations · 146
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 = 'AUGUSTA' 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 = 'AUGUSTA' 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.
N62001North American T-2B · S/N 152383N6202YNorth American T-2B · S/N 155207N188DAero Commander 680-F · S/N 680F-934-7N81RESanders Richard Dee VARIEZE · S/N RAF 1821N26518Taylorcraft BC-65 · S/N 1859N100SWMitsubishi MU-2B-30 · S/N 539N5353LCessna 152 · S/N 15284299N20715Cameron Balloons US N-90 · S/N 5430N2100QCameron Balloons US A-105 · S/N 5533N6146ZBell 206A-1 · S/N 44006N6150ZBell 206A-1 · S/N 44018N6210VBell 206A-1 · S/N 44045N6340XBell 206A-1 · S/N 44028N6342XBell 206A-1 · S/N 44034N6346EBell 206A-1 · S/N 44070N6347QBell 206A-1 · S/N 44064N6349EBell 206A-1 · S/N 44055N6350LBell 206A-1 · S/N 44031N6350VBell 206A-1 · S/N 44027N6351VBell 206A-1 · S/N 44024N2258ZPatton-Al AEROSPORT SCAMP WTBL · S/N 172N32877Balloon Works FIREFLY 8 · S/N F8-421N2322KHildebrant Earl L BOBCAT/SUPERCAT · S/N 025N7232KBell UH-1H · S/N 66-16150N7232ZBell UH-1H · S/N 65-09604N1214BBell UH-1H · S/N 6616255N7232DBell UH-1H · S/N 6510010N7417MBalloon Works FIREFLY 7 · S/N F7301N1206PBell UH-1H · S/N 6616659N1217ABell UH-1H · S/N 6600983N1189ALockheed 1329-23E · S/N 5139N64LBPiper PA-31-350 · S/N 317852127N5517ZBell UH-1H · S/N 6600913N6738BBell UH-1H · S/N 6601148N8154LBell UH-1H · S/N 66904N8154SBell UH-1H · S/N 6617068N6222ZBell OH-58C · S/N 6916237N6743XBell UH-1H · S/N 6510075N8154GBell UH-1H · S/N 6510102N119BFMitsubishi MU-2B-30 · S/N 517N513NAMitsubishi MU-2B-30 · S/N 513N4284VMitsubishi MU-2B-25 · S/N 270N80398Mitsubishi MU-2B-36A · S/N 712SAN271MAMitsubishi MU-2B-60 · S/N 797SAN733FBCessna 172N · S/N 17268252N4202KMitsubishi MU-2B-35 · S/N 603N125ABMitsubishi MU-2B-60 · S/N 1531SAN5NQMitsubishi MU-2B-26A · S/N 356SAN638MAMitsubishi MU-2B-35 · S/N 638N850MAMitsubishi MU-2B-36 · S/N 690
Back to Augusta, GA