Skip to content

East Hartford, CT

Cancelled registrations · 45

Query with SQL

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 = 'EAST HARTFORD' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'EAST 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 = 'EAST 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.

N891RCAirbus A320-232 · S/N 2513Cancelled Aug 3, 2021 · Caw Finance Corp N10676Howe TAYLOR MONOPLANE · S/N HHM1Cancelled Mar 23, 2018 · Revoked, canceled · Howe Richard N54353Boeing 727-231 · S/N 21985Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1980 · Art 21985 LLC N136SWBoeing 747SP-J6 · S/N 21933Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Ut Finance Corp N135SWBoeing 747SP-J6 · S/N 21932Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Ut Finance Corp N973PGBoeing 727-232 · S/N 20640Cancelled May 19, 2015 · Registration expired, pending cancellation · Art 20640 LLC N509DABoeing 727-232 · S/N 21311Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1977 N6030Aerostats-Balloons AEROSTAT 45 · S/N 45-4Cancelled Mar 26, 2013 · Revoked, canceled · Built 1972 · Company Of Montgolfier Balloonists N537DABoeing 727-232 · S/N 22073Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1980 N53FADouglas DC-8-43 · S/N 45666Cancelled Feb 21, 2012 · Revoked, pending cancellation · Built 1964 · Itl Inc N353UABoeing 737-322 · S/N 24321Cancelled Jan 27, 2010 · Triennial form not returned · Built 1988 · Ut Finance Corp N747UTBoeing 747SP-J6 · S/N 21934Cancelled Jun 11, 2009 · Exported to Canada · Built 1980 · Ut Finance Corp N289SWBoeing 767-260 · S/N 23106Cancelled Mar 6, 2009 · Ut Finance Corp N71026Sikorsky S-76C · S/N 760598Cancelled Sep 14, 2005 · Exported to Mexico · Ut Finance Corp N71154Sikorsky S-76C · S/N 760596Cancelled Jul 21, 2005 · Exported to Mexico · Built 2005 · Ut Finance Corp N494TWLockheed 749A-79 · S/N 2601Cancelled Apr 25, 2005 · Exported to South Korea · Built 1948 · United Technologies Corp N7110USikorsky S-76C · S/N 760582Cancelled Feb 24, 2005 · Exported to Mexico · Ut Finance Corp N7113JSikorsky S-76C · S/N 760581Cancelled Feb 11, 2005 · Exported to Mexico · Ut Finance Corp N681SWBoeing 747-312 · S/N 23245Cancelled May 12, 2004 · Exported to Thailand · Ut Finance Corp N504DABoeing 727-232 · S/N 21306Cancelled Oct 30, 2003 · Exported to Indonesia · Built 1977 N285SWBoeing 747-2B5B · S/N 22485Cancelled Jun 27, 2003 · Exported to Israel · Built 1981 · U T Finance Corp N142SWBoeing 747SP-27 · S/N 22302Cancelled Mar 21, 2000 · Exported to Australia · Ut Finance Corp N62RADehavilland DHC-7-102 · S/N 89Cancelled Mar 27, 1996 · Exported to Philippines · Federal Deposit Insurance Corp N550SWBoeing 747 212B · S/N 20924Cancelled Mar 14, 1996 · Exported to Iceland · Ut Finance Corporation N5253CBeech B35 · S/N D2645Cancelled Jun 28, 1984 · Mullen Wayne E N153FAMcdonnell Douglas DC-8-43 · S/N 45755Cancelled Aug 10, 1979 · Exported to Philippines · Built 1964 · Itl Inc N1027YDouglas DC-8-43 · S/N 45660Cancelled May 7, 1979 · Exported to Philippines · Itl Inc N819EDouglas DC-8-51 · S/N 45806Cancelled Jul 24, 1978 · Exported to Philippines · Itl Inc N816EDouglas DC-8-51 · S/N 45690Cancelled Mar 2, 1978 · Exported to Philippines · Built 1965 N813EDouglas DC-8-51 · S/N 45688Cancelled Nov 28, 1977 · Exported to Philippines · Itl Inc N406ASikorsky S-55 · S/N 55292Cancelled Sep 26, 1960 · Exported to Argentina · United Aircraft Corporation N1334HAeronca 15AC · S/N 15AC-374Cancelled May 17, 1957 · Exported to Canada · Saczawa Joseph/Goldberg Louis H N60358Northrop YP-61 · S/N 716Cancelled Oct 12, 1956 · United Aircraft Corp Hamilton Standard Division N50620Fairchild M-62A · S/N T43-5764Cancelled Nov 28, 1955 · Philbrick James B N30447Chance Vought SB2U-1 · S/N 0770Cancelled May 18, 1951 · United Aircraft Corp N18985Vultee AB-2 · S/N 131Cancelled Oct 5, 1950 · United Aircraft Corp N5110NBoeing B-17G · S/N 4485741Cancelled Mar 17, 1950 · United Aircraft Corp N14980Airplane Development VULTEE V-11 · S/N 29Cancelled Mar 22, 1948 · United Aircraft Corp N28990Curtiss Aeroplane HAWK 81A · S/N 17816Cancelled Dec 29, 1947 · Pratt & Whitney Aircraft N13308Boeing 247-A SPECIAL · S/N 1711Cancelled Mar 20, 1947 · United Aircraft Corporation N15949Chance Vought Div United Acft VOUGHT V-135 · S/N 1050Cancelled Dec 1, 1939 · United Aircraft Corp N283Boeing 40B · S/N 894Cancelled Oct 13, 1938 · United Aircraft Corp N781NChance Vought CORSAIR FG-1D · S/N 989Cancelled Apr 30, 1935 · Chance Vought Corp N10696Boeing 100F · S/N 1687Cancelled Apr 18, 1933 · Built 1932 · Pratt & Whitney Aircraft Co Inc N13301Sikorsky S-51 · S/N 5115Cancellation date not recorded · Built 1946 · Pratt & Whitney Aircraft

Back to East Hartford, CT