Bridgeport, CT
Cancelled registrations · 61
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 = 'CT' AND d.registrant_city = 'BRIDGEPORT' 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 = 'CT' AND d.registrant_city = 'BRIDGEPORT' 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.
N2919Swallow Mfg SUPER SWALLOW · S/N 225N26VSikorsky S-38-C · S/N 414-17N552KWhittelsey Manufacturing AVIAN IV-M · S/N 276N963MSikorsky S-39-B · S/N 1N25VSikorsky S-38-B · S/N 414-16N67922Curtiss Wright C-46 · S/N 26995 (42-107308)N67923Curtiss Wright C-46 · S/N 26948 (42-61073)N67924Curtiss Wright C-46 · S/N 26812 (42-3679)N67925Curtiss Wright C-46 · S/N 26792 (42-3659)N67926Curtiss Wright C-46 · S/N 30575 (42-101120)N746ASikorsky S-55 · S/N 55897
Back to Bridgeport, CT