Skip to content

Windsor Locks, CT

Cancelled registrations · 38

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 = 'WINDSOR LOCKS' 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 = 'WINDSOR LOCKS'
  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 = 'WINDSOR LOCKS'
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.

N277JHBombardier BD-100-1A10 · S/N 20593Cancelled Oct 5, 2020 · Exported to Mexico · Built 2015 · Lughnasa Management LLC N6GVRockwell International NA-265 · S/N 465-9Cancelled Mar 26, 2020 · Sale reported · Built 1979 N441JMcdonnell Douglas DC-8-63 · S/N 45988Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Miami Leasing Inc N74844Douglas DC3C · S/N 26458Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · New England Propeller Service Incorp N165LGDouglas DC3-G202A · S/N 6314Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1942 · Ct Aeronautical Hist Assoc Inc DBA N5805ECessna 172N · S/N 17271939Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1978 · Airkaman Inc N4694MBeech 76 · S/N ME-53Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1978 · Airkaman Incorporated N34645Stinson 10A · S/N 8045Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · New England Air Museum N383LJLearjet 60 · S/N 383Cancelled Sep 22, 2014 · Exported to United Arab Emirates · Built 2010 · Global Flight Inc N791ALDouglas DC-8-62F · S/N 46150Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Miami Leasing Inc N51707Ryan Aeronautical ST3KR · S/N 1788Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1942 N21DRConvair 440 · S/N 325Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Emmissary Airways Inc N8968UDouglas DC-8-62 · S/N 46069Cancelled May 6, 2013 · First renewal notice · Built 1969 · Miami Leasing Inc N8969UDouglas DC-8-62 · S/N 46070Cancelled May 6, 2013 · First renewal notice · Built 1969 · Miami Leasing Inc N13250Viking Flying Boat KITTY HAWK B-8 · S/N 30Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1933 · New England Air Museum N5190MBeech C24R · S/N MC-561Cancelled Apr 8, 2013 · Sale reported, pending cancellation · Built 1978 N60176Beech C23 · S/N M-2144Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1979 · Airkaman Incorporated N57573Lockheed ELECTRA 10-A · S/N 1052Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1936 N2079FBalloon Works FIREFLY 7 · S/N 736Cancelled Aug 9, 2012 · Sale reported, canceled · Built 1976 N421BLThomas Wilbur D KR-200 · S/N 1Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1989 N3538MMartin Robert E RM2-2X REVOLUTION · S/N X2000Cancelled Sep 30, 2010 · Triennial form not returned · Martin Robert E N601JECanadair CL-600-2B16 · S/N 5086Cancelled Mar 20, 2008 · Exported to Canada · Built 1990 · Private Jet Charters LLC N3112Champa B-8M · S/N JC-1Cancelled Nov 15, 2007 · Built 1967 · New England Air Museum N5921ACessna 172 · S/N 28521Cancelled Sep 24, 2007 · Triennial form not returned · Built 1956 · Kanonas Thomas S N1665YCessna 172C · S/N 17249365Cancelled Nov 19, 1998 · Triennial form not returned · Civil Air Patrol Flying Assoc Inc N3FDDaglio WITTMAN W-8 · S/N 358Cancelled Feb 1, 1994 · Triennial form not returned · Daglio Francis C N477CMMehling VARI EZE · S/N 0003Cancelled Jan 6, 1993 N32WSSchiller Walter C MONNETT MONERAI · S/N 22Cancelled Aug 17, 1989 N89893Cessna 152 · S/N 15282906Cancelled Sep 14, 1983 · Administratively canceled · Airkaman Inc N11109Cessna 150L · S/N 15075205Cancelled Jul 10, 1980 · Built 1973 · Langlais Robert P Langlais Dorothy A N73AKBeech B19 · S/N MB-588Cancelled Jul 16, 1975 · Airkaman Inc N4000YBeech C-45H · S/N AF820Cancelled Oct 28, 1970 · New England Propeller Service Inc N401AKaman K-190A · S/N 5Cancelled May 21, 1965 · Built 1949 · Kaman Aircraft Corporation N74148Kaman K-190-B · S/N 3Cancelled Oct 17, 1955 · Built 1949 · Kaman Aircraft Corporation N400AKaman K225 · S/N 4Cancelled Nov 1, 1951 · The Kaman Aircraft Corp N402AKaman K225 · S/N 6Cancelled Nov 2, 1950 · The Kaman Aircraft Corp N74105Kaman K-190A · S/N 2Cancelled Oct 2, 1950 · The Kaman Aircraft Corp N403AKaman K-190A · S/N 7Cancelled Feb 21, 1950 · The Kaman Aircraft Corp

Back to Windsor Locks, CT