Bangor, ME
Cancelled registrations · 66
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 = 'ME' AND d.registrant_city = 'BANGOR' 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 = 'ME' AND d.registrant_city = 'BANGOR' 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.
N9456HCessna 172M · S/N 17266164N1989XCessna 182H · S/N 18256089N1556APiper PA-20 · S/N 20-758N9434Douglas DC3 · S/N 19433N8346YPiper PA-30 · S/N 30-1493N9316TCessna 180C · S/N 50816N84240Aeronca 7AC · S/N 7AC-2932N8015CPiper PA-20-135 · S/N 20-1099N1115PPiper PA-23 · S/N 23-125N4256KRyan NAVION · S/N NAV-4-1256N31173Piper J5A · S/N 327N82819Aeronca 7AC · S/N 7AC-1466N2920KLuscombe 8A · S/N 5647N52535Fairchild M-62A · S/N T42-3871N600ERoe AVRO-AVIAN · S/N 243N210Advance WACO 9 · S/N 327
Back to Bangor, ME