OpenAirDocs.org
New Bedford, MA

Cancelled registrations · 100

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

N25DCChishlom Daniel VARIEZE · S/N 144Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1992 · Chisholm Daniel CN1782JPiper PA-28-140 · S/N 28-24205Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1968 · Whalley Jonathan DN4794RCessna 172RG · S/N 172RG0033Cancelled Feb 20, 2020 · Exported to Russia · Built 1979 · Colonial Air IncN9143GYuneec TYPHOON Q500 4K · S/N YU15212015B04B01Cancelled Oct 21, 2019 · Sale reported, canceledN286BOmega BS-12D1 · S/N 1003Cancelled Sep 14, 2019 · Revoked, canceled · Built 1963 · Omega Aircraft CorporationN242JJJezisek Jonathan J J-2 · S/N 001Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Simmons Adam RN17153Stinson SR-9D · S/N 5114Cancelled Oct 28, 2017 · Revoked, canceled · Built 1937 · Jeffries Edward RN9207HGrumman G-44 · S/N 1353Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1944 · Brandt Jordan CorpN9233SBeech B24R · S/N MC-382Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1975 · Brown CarlN214SPCessna 172S · S/N 172S8195Cancelled Jun 5, 2012 · Exported to Germany · Built 1999 · Jeti Knights LLCN6850CRyan NAVION A · S/N NAV-4-1768Cancelled Jul 20, 2011 · Expired dealer · Air Service Caravan Co IncN6919FCessna 150F · S/N 15063519Cancelled Jul 20, 2011 · Expired dealer · Built 1966 · Air Service CaravanN8235LCessna 172H · S/N 17256435Cancelled Mar 24, 2011 · Expired dealer · Built 1967 · Air Service Caravan Co IncN15805Piper PA-32-300 · S/N 32-7340065Cancelled Oct 29, 2010 · Second triennial mailing, no response · Built 1972 · Roy ArmandN6005RCessna 172G · S/N 17253674Cancelled Oct 26, 1999 · Triennial form not returned · Borges DennisN53074Cessna A185F · S/N 18502359Cancelled Oct 14, 1997 · Second triennial mailing, no response · Faria Walter PN6514YPiper PA-23-250 · S/N 273805Cancelled Apr 14, 1993N76160Cessna 140 · S/N 10557Cancelled Aug 13, 1992 · Air Service Caravan Co IncN1125LLake LA-4 · S/N 287Cancelled Nov 8, 1991 · Administratively canceled · Hiller Ira R IIN11439Cessna 150L · S/N 15075422Cancelled Nov 23, 1983 · Administratively canceled · Air Service Caravan Co IncN23338Piper PA-38-112 · S/N 38-81A0128Cancelled May 19, 1983 · Air Service Caravan Co IncN7674RBeech B23 · S/N M-1271Cancelled Feb 16, 1983 · Air Service Caravan Co IncN73176Cessna 172M · S/N 17267303Cancelled Feb 6, 1982 · Air Service Caravan Co IncN757ZWCessna 152 · S/N 15280143Cancelled Dec 17, 1981 · Baker Benjamin BN2927BPiper PA-28-160 · S/N 28-8016002Cancelled Aug 13, 1981 · Built 1979 · Air Service Caravan Co IncN1510PPiper PA-22-135 · S/N 22-2375Cancelled Dec 1, 1980 · Built 1954 · Air Service Caravan Co IncN47568Piper PA-28-201T · S/N 28R7703399Cancelled Jan 17, 1979 · Air Service Caravan Co IncN5785VBeech A23-24 · S/N MA-44Cancelled Nov 6, 1978 · Air Service Caravan Co IncN8650UCessna 150M · S/N 150-77968Cancelled Jul 28, 1978 · Air Service Caravan Co IncN66228Cessna 150M · S/N 15075935Cancelled Jul 27, 1977 · Exported to Canada · Vosburgh Steven LN20539Cessna 172M · S/N 17261376Cancelled May 20, 1977 · Exported to Canada · Vosburgh Steven LN7247QCessna 172L · S/N 172-60547Cancelled Apr 1, 1977 · Exported to Canada · Vosburgh Steven LN3844TPiper PA-28R-180 · S/N 28R30164Cancelled Sep 27, 1976 · Air Service Caravan Co IncN66150Cessna 150M · S/N 150-75873Cancelled Jul 2, 1976 · Exported to Canada · Vosburgh Steven LN7RWPiper PA-23-250 · S/N 27-3381Cancelled Jun 9, 1976 · Air Service Caravan Co IncN72366Cessna 140 · S/N 9552Cancelled Apr 16, 1976 · Air Service Caravan Co IncN693CAPiper PA-28-140 · S/N 28-21649Cancelled Mar 22, 1976 · Air Service Caravan Co IncN6769TCessna 310D · S/N 39069Cancelled Feb 2, 1976 · Air Service Caravan Co IncN98267Piper PA-28-140 · S/N 28-26136Cancelled Oct 3, 1975 · Built 1969 · Air Service Caravan Co IncN8361RPiper PA-28-140 · S/N 28-22237Cancelled Sep 9, 1975 · Built 1966 · Air Service Caravan Co IncN2503QCessna 182K · S/N 182-57703Cancelled May 14, 1975 · Air Service Caravan Co IncN5681TCessna 172E · S/N 172-51581Cancelled Nov 21, 1974 · Air Service Caravan Co IncN60352Cessna 150J · S/N 15070245Cancelled Oct 2, 1974 · Air Service Caravan Co IncN60992Cessna 150J · S/N 15070720Cancelled Oct 1, 1974 · Air Service Caravan Co IncN8383EMooney M20A · S/N 1561Cancelled Sep 25, 1974N97154Stinson 108-1 · S/N 108-154Cancelled Jul 2, 1974 · Air Service Caravan Co IncN9766JPiper PA-28-180 · S/N 28-3961Cancelled May 9, 1974 · Built 1967N2278YCessna 177 · S/N 17700078Cancelled Apr 4, 1974 · Air Service Caravan Co IncN5157TChampion 7GCAA · S/N 151Cancelled Mar 19, 1974 · Air Service Caravan Co IncN8437NBeech B-55 · S/N TC1096Cancelled Nov 20, 1973 · Built 1968 · Air Service Caravan Co Inc
Back to New Bedford, MA