Skip to content

Cancelled registrations · 46

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 = 'MA' AND d.registrant_city = 'WORCESTER' 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 = 'MA' AND d.registrant_city = 'WORCESTER'
  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 = 'MA' AND d.registrant_city = 'WORCESTER'
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.

N214BDRVB Baloes Inflaveis Ltda Me SS-30-BJ · S/N MAB2011125Cancelled Jun 20, 2026 · Sale reported, canceled · Built 2011 N52240Fairchild M-62A · S/N T40279Cancelled Jul 5, 2018 · Revoked, pending cancellation · Built 1940 · Morrilly Bernard W N76660Cessna 140 · S/N 11100Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Loughlin John J N90909Aerostar International RX-9 · S/N RX9-3012Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1998 · Bella Via Balloon Company N4988AStokes JS77C · S/N JS56CCancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1978 · Dipilato Jack R N4944GBurkhart Grob G 103 TWIN II · S/N 3850-K-96Cancelled Oct 28, 2013 · Registration expired, pending cancellation · New England Soaring Association Icn N2767ACorben BABY ACE · S/N 6291953Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1982 · Al Abbadi A Abdullah N99595Ercoupe 415-C · S/N 2218Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1946 · Dulmaine Edward L N90136Cessna 140 · S/N 9197Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1946 N44897Piper PA-28-161 · S/N 28-7816039Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Budzyna John P N5561RRaven S-60A · S/N S60A-140Cancelled Jun 14, 2012 · Registration pending, canceled · Built 1979 N241KMDiamond Aircraft Ind DA 40 · S/N 40.718Cancelled Sep 12, 2011 · Exported to Canada · Built 2006 · Commerce Bank & Trust Co N37758Malkasian Scott GYRACAR BG5 · S/N 1Cancelled Feb 8, 2010 · Triennial form not returned · Malkasian Scott N73704Cessna 172N · S/N 17267617Cancelled Sep 20, 2006 · Triennial form not returned · Built 1976 · Capuano LLC N4669LCessna 152 · S/N 15284211Cancelled Sep 19, 2006 · Triennial form not returned · Built 1980 · Capuano LLC N3665RPiper PA-28-140 · S/N 28-7125352Cancelled Mar 10, 2005 · Triennial form not returned · Built 1971 · Kazan Stephen N1460DCessna 170A · S/N 20043Cancelled May 20, 1999 · Triennial form not returned · Gill Vincent C N3582MAerostar International S-60A · S/N S60A3152Cancelled May 15, 1997 · Exported to Canada · Johnson Harold W N8252WPiper PA-28-180 · S/N 282402Cancelled Apr 30, 1997 · Triennial form not returned · Cotter Peter J N5431QCessna 152 · S/N 15285110Cancelled Nov 6, 1996 · Triennial form not returned · Capuano John P N2878JAerostar International RAVEN S-55A · S/N S55A3006Cancelled Aug 16, 1995 · Triennial form not returned · Distefano A Mario DBA N49269Cessna 152 · S/N 15281214Cancelled May 10, 1995 · Triennial form not returned · Giordano Deborah A N41942Raven S55A · S/N S55A921Cancelled Jul 21, 1994 · Johnson Harold W N3685VCessna 140 · S/N 14961Cancelled May 12, 1983 · Built 1947 · Gill Vincent C & Gill Louise F N5567UPiper PA-28-140 · S/N 2826294Cancelled Feb 19, 1981 · Tinsicas Inc N77DFPiper PA-23-250 · S/N 27-4650Cancelled Jul 26, 1978 · Exported to Iceland · Marine Associates Inc N7310KCessna R172K · S/N R1722051Cancelled May 25, 1977 · Exported to Canada · Vitek Aviation Inc N10974Cessna 150L · S/N 15075178Cancelled May 6, 1975 · Exported to Canada · Built 1973 · Vitek Aviation Inc N5527QMooney M20C · S/N 2952Cancelled Jan 30, 1974 · Exported to Canada · Marine Associates Inc N19057Cessna 150 · S/N 74131Cancelled Jun 26, 1973 · Built 1973 · Vitek Aviation Inc N3927MPiper PA-12 · S/N 12-2820Cancelled Jan 28, 1969 · Zonia Carl N7117HPiper J3C-65 · S/N 20369Cancelled Jun 12, 1965 · Universal Aviation Corp N2232NCessna 140 · S/N 12468Cancelled May 24, 1963 · Druvins Arvid A N14743Cessna 140 · S/N 8171Cancelled Apr 6, 1959 · Exported to Canada · Built 1946 · Jennings Bros Air Service Inc N3311VBeech 35 · S/N D770Cancelled Aug 4, 1958 · Hjelm Harvey C N3635DCessna 310 · S/N 35335Cancelled Apr 17, 1958 · Exported to Ireland · Jennings Bros Air Service Inc N93759Ercoupe 415-C · S/N 1082Cancelled Apr 30, 1956 · Built 1946 · Richard M. Dube N53583Fairchild M-62A · S/N T42-3449Cancelled Oct 13, 1955 · Built 1942 · Airports In N24616Piper J3F-50 · S/N 3302Cancelled Mar 23, 1955 · Airports Inc N1832NCessna 120 · S/N 12076Cancelled Sep 16, 1952 · Eastwood Thomas W N89102Cessna 140 · S/N 8106Cancelled Sep 28, 1950 · Universal Aviation Corp N9578KStinson 108-2 · S/N 108-2578Cancelled Feb 15, 1950 · Built 1947 · Electrical Appliance Sales Corp N36233Taylorcraft BL12-65 · S/N 3190Cancelled Sep 7, 1948 · Airports Inc N9050Stearman C3-B · S/N 198Cancelled Apr 13, 1948 · Desjardin Auto Service Corp N23634Taylorcraft BC-65 · S/N 1364Cancelled Aug 4, 1944 · Built 1939 · The Clipper Club N1313Standard J-1 · S/N 208Cancellation date not recorded · Built 1927 · Boucher Sam

Back to Worcester, MA