Hartford, CT
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 = 'CT' AND d.registrant_city = 'HARTFORD' 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 = 'HARTFORD' 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.
N340BESaab-Fairchild 340A · S/N 340A-062N341BESaab-Scania SF340A · S/N 340A-063N957RMcdonnell Douglas DC-8-63F · S/N 46137N959RMcdonnell Douglas DC-8-63F · S/N 46143N220USBoeing 737-2H5 · S/N 20453N221USBoeing 737-2H5 · S/N 20454N605DCBombardier CL-600-2B16 · S/N 5422N604DCBombardier CL-600-2B16 · S/N 5403N605PABombardier CL-600-2B16 · S/N 5397N604JEBombardier CL-600-2B16 · S/N 5389N604CACanadair CL-600-2B16 · S/N 5379N604DEBombardier CL-600-2B16 · S/N 5380N682GEBoeing 737-400 · S/N 24682N601FSBombardier CL-600-2B16 · S/N 5172N604JPCanadair CL-600-2B16 · S/N 5346N178USBritish Aerospace BAE 146 SERIES 200A · S/N E2040N52AWBoeing 757-23A · S/N 25489N165USBritish Aerospace BAE 146 SERIES 200 · S/N E2023N177USBritish Aerospace BAE 146 SERIES 200A · S/N E2039N166USBritish Aerospace BAE 146 SERIES 200A · S/N E2024N174USBritish Aerospace BAE 146 SERIES 200A · S/N E2034N171USBritish Aerospace BAE 146 SERIES 200A · S/N E2028N172USBritish Aerospace BAE 146 SERIES 200A · S/N E2030N102ANBoeing 737-33A · S/N 27285N243MAFokker F.27MK 500 · S/N 10679N244MAFokker F.27MK 500 · S/N 10680N220KCSwearingen SA226TC · S/N TC231N350PSBritish Aerospace BAE 146 SERIES 200 · S/N E2027N221GFBoeing 747-300 SERIES · S/N 22996N408MXBritish Aerospace BAE JETSTREAM 3101 · S/N 638N410MXBritish Aerospace BAE JETSTREAM 3101 · S/N 640N114HMBoeing 707-324C · S/N 19871N80225Beech D18S · S/N A205N49085Cessna 152 · S/N 15283414N714UPCessna 152 · S/N 152-79446N9283UCessna 150M · S/N 15078233N2504WBeech B24R · S/N MC-161N9518BCessna 172RG · S/N 172RG0849N9532BCessna 172RG · S/N 172RG0860N3686VCessna 150 · S/N 150-76589N401CAPiper PA-31 · S/N 31-625N406CAPiper PA-31 · S/N 31-637N7025KPiper PA-20 · S/N 20-130N333TSDouglas DC3C · S/N 45-1072N14353Piper PA-23-250 · S/N 27-7304937N3874VCessna 150M · S/N 150-76642N2063TSchweizer TSC-1A2 · S/N 24N71618Cessna 182M · S/N 18259690N78638Cessna 172H · S/N 17257696N7732DPiper PA-22-150 · S/N 22-5408
Back to Hartford, CT