Skip to content

Cancelled registrations · 217

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

N716LYEurocopter EC 130 B4 · S/N 7289Cancelled May 28, 2024 · Built 2011 · Gsh Crow'S Nest LLC N782SBBombardier BD-700-1A11 · S/N 9392Cancelled Feb 22, 2024 · Exported to Argentina · Built 2010 · Sc Aviation Partners LLC N208FFCessna 208B · S/N 208B1125Cancelled Jun 1, 2023 · Exported to New Zealand · Built 2005 · Merlin Labs Inc N808ASPulse Aerospace VAPOR 55 · S/N 800032-0922-03Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Avitas Systems Inc N932LMDJI PHANTOM 3 PROFESSION · S/N P76DCF03017051Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Liberty Mutual Insurance N935LMDJI PHANTOM 3 PROFESSION · S/N P76DCF04013008Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Liberty Mutual Insurance N931LMDJI PHANTOM 3 PROFESSION · S/N P76DCF28017127Cancelled Mar 14, 2022 · Liberty Mutual Insurance N933LMDJI PHANTOM 3 PROFESSION · S/N P76DCF04013002Cancelled Mar 14, 2022 · Liberty Mutual Insurance N934LMDJI PHANTOM 3 PROFESSION · S/N P76DCH25A26383Cancelled Mar 14, 2022 · Liberty Mutual Insurance N936LMDJI PHANTOM 3 PROFESSION · S/N P76DCH24A20771Cancelled Mar 14, 2022 · Liberty Mutual Insurance N937LMDJI PHANTOM 3 PROFESSION · S/N P76DCK03A26971Cancelled Mar 14, 2022 · Liberty Mutual Insurance N938LMDJI PHANTOM 3 PROFESSION · S/N P76DCK03A26968Cancelled Mar 14, 2022 · Liberty Mutual Insurance N939LMDJI PHANTOM 3 PROFESSION · S/N P76DCH25A21126Cancelled Mar 14, 2022 · Liberty Mutual Insurance N940LMDJI PHANTOM 3 PROFESSION · S/N P76DCH25A26137Cancelled Mar 14, 2022 · Liberty Mutual Insurance N941LMDJI PHANTOM 3 PROFESSION · S/N P76DCK11A26786Cancelled Mar 14, 2022 · Liberty Mutual Insurance N344RRobinson Helicopter R44 II · S/N 10288Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2004 · Jrvc Transportation Inc N888EUCessna 207 · S/N 20700352Cancelled Jul 30, 2021 · Exported to Haiti · Built 1976 · Fourcand Fadiah N57BKBKF BACKCOUNTRY SUPERCUB · S/N BC21115R007Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Bkf Aviation Ltd N59BKBKF BACKCOUNTRY SUPERCUB · S/N BC21115R006Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2018 · Bkf Aviation Ltd N796KDDJI INSPIRE 1 PRO · S/N W21ADF13020476Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Desisto Jonathan M N798DDDJI INSPIRE 1 · S/N W13DCC17020481Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Desisto Johnathan M N446PUDJI PHANTOM 3 ADVANCED · S/N P77DCG07010193Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Raycroft James G N754EAParrot AR DRONE 2.0 ELITE · S/N 520410018060Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Arrowstreet Inc N592DDDJI PHANTOM 3 PROFESSION · S/N CE061539232681Cancelled Jun 28, 2019 · Registration expired, pending cancellation · Shawmut Design And Construction N24943Piper J4A · S/N 4769Cancelled Dec 4, 2018 · Revoked, canceled · Built 1939 · Schifano Charles A N175UABoeing 747-422 · S/N 24382Cancelled Jul 30, 2018 · Built 1990 · U S Bank Trust Na Trustee N873ZSikorsky S-55B · S/N 55372Cancelled May 21, 2018 · Revoked, canceled · Built 1953 · Carson Hel New England Inc N178UABoeing 747-422 · S/N 24385Cancelled Apr 9, 2018 · Built 1990 · N178ua Trust N509SWBoeing 737-5H4 · S/N 24186Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1990 · U S Bank Na Trustee N840ASBombardier CL-600-2B19 · S/N 7290Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1999 · U S Bank Na Trustee N7522AMcdonnell Douglas DC-9-82(MD-82) · S/N 49899Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1990 · U S Bank Na Trustee N380SWBoeing 737-3H4 · S/N 26587Cancelled Feb 9, 2018 · Built 1994 · U S Bank Na Trustee N390SWBoeing 737-3H4 · S/N 26593Cancelled Feb 9, 2018 · Built 1994 · U S Bank Na Trustee N94BRRosman William J KR-2 · S/N 2195Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1984 · Cahill Ryan A N19324Aeronca K · S/N K190Cancelled Oct 28, 2017 · Revoked, canceled · Built 1937 · Green Joseph N533UABoeing 757-222 · S/N 25073Cancelled Aug 18, 2017 · Built 1991 · U S Bank Trust Na Trustee N179UABoeing 747-422 · S/N 25158Cancelled Aug 17, 2017 · Built 1991 · US Bank Trust Na Trustee N846ASBombardier CL-600-2B19 · S/N 7328Cancelled Jun 1, 2017 · U S Bank Na Trustee N5280BMooney M20 · S/N 1143Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Putnam John P N425KJSocata TBM 700 · S/N 518Cancelled Aug 17, 2016 · Third renewal notice · Built 2009 · Trustey Management Corp N365SWBoeing 737-3H4 · S/N 26576Cancelled May 11, 2016 · Built 1993 · U S Bank Na Trustee N364SWBoeing 737-3H4 · S/N 26575Cancelled Apr 26, 2016 · Built 1993 · U S Bank Na Trustee N832ASCanadair CL-600-2B19 · S/N 7243Cancelled Jan 7, 2016 · Built 1998 · U S Bank Na Trustee N835ASBombardier CL-600-2B19 · S/N 7258Cancelled Aug 14, 2015 · Built 1998 · US Bank Na Trustee N405FJDornier 328-300 · S/N 3155Cancelled Aug 6, 2015 · Registration pending, pending cancellation N834ASBombardier CL-600-2B19 · S/N 7254Cancelled Jul 7, 2015 · Built 1998 · U S Bank Na Trustee N411JMCessna 411A · S/N 411-0279Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1967 · Ferretti James L N3038VBede BD-5J · S/N BDA-01Cancelled May 4, 2015 · Registration expired, pending cancellation · Jimenez Juan E N730CCShort Bros SHORTS SD3-60 · S/N SH3730Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Bankboston Na Owner Trustee N317HBFairchild Dornier DORNIER 328-300 · S/N 3179Cancelled Apr 14, 2015 · Registration pending, pending cancellation

Back to Boston, MA