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.

N827ASCanadair CL-600-2B19 · S/N 7212Cancelled Apr 6, 2015 · Built 1997 · U S Bank Na Trustee N320AABoeing 767-223 · S/N 22321Cancelled Mar 25, 2015 · Built 1985 · US Bank Na Trustee N829ASCanadair CL-600-2B19 · S/N 7232Cancelled Feb 20, 2015 · Built 1998 · U S Bank Na Trustee N328AABoeing 767-223 · S/N 22328Cancelled Jan 7, 2015 · Built 1986 · US Bank Na Trustee N329AABoeing 767-223 · S/N 22329Cancelled Jan 7, 2015 · Built 1987 · US Bank Na Trustee N9543TCessna 210 · S/N 57343Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1960 · Tobins Jordan S N510SWBoeing 737-5H4 · S/N 24187Cancelled Sep 15, 2014 · Built 1990 · U S Bank Na Trustee N518USBoeing 757-251 · S/N 23206Cancelled Apr 28, 2014 · Third renewal notice · Built 1986 · U S Bank Na Trustee N507SWBoeing 737-5H4 · S/N 24184Cancelled Jan 29, 2014 · First renewal notice · Built 1990 · U S Bank Na Trustee N506SWBoeing 737-5H4 · S/N 24183Cancelled Nov 8, 2013 · Built 1990 · U S Bank Na Trustee N7947FCessna 150F · S/N 15064047Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1966 · Sankor Inc N6466KRepublic RC-3 · S/N 717Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1947 N617BYYoung Brinton O C BRINTON EXEC · S/N BOCY 1Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1989 · Young Brinton O C N5287TPiper PA-28-140 · S/N 28-7225389Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1972 · Vanguard Enterprizes Inc N1173ZSpatz Mark KR-1 · S/N 1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1983 · Spatz Mark C N8537CPiper PA-22-135 · S/N 22-1250Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1953 · Ostermann Carl H N81797Douglas A-26C · S/N 44-35752Cancelled Apr 9, 2013 · Sale reported, canceled N450RCCarroll Roger MINI 500 · S/N 253Cancelled Mar 19, 2013 · Sale reported, pending cancellation N4523BGulfstream American AA-5B · S/N AA5B1090Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1979 · Marple Gary A N29242Piper PA-28RT-201 · S/N 28R-7918138Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1979 · Harcourt Color Corporation N16421Piper PA-28-140 · S/N 28-7325269Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1973 · Smith Wayne T N15752Piper PA-28-140 · S/N 28-7325151Cancelled Jul 9, 2012 · Sale reported, canceled · Built 1972 N318SWBoeing 737-3H4 · S/N 23339Cancelled Jun 27, 2012 · Built 1986 · U S Bank Na Trustee N558AXBoeing 757-23N · S/N 27971Cancelled Nov 17, 2011 · Exported to Aruba · Built 1995 · U S Bank Na Trustee N916UWBoeing 757-225 · S/N 22192Cancelled Aug 22, 2011 · Triennial form not returned · Built 1982 · U S Bank Na Trustee N917UWBoeing 757-225 · S/N 22193Cancelled Aug 22, 2011 · Triennial form not returned · Built 1982 · U S Bank Na Trustee N918UWBoeing 757-225 · S/N 22196Cancelled Aug 22, 2011 · Triennial form not returned · Built 1982 · U S Bank Na Trustee N919UWBoeing 757-225 · S/N 22198Cancelled Aug 22, 2011 · Triennial form not returned · Built 1982 · U S Bank Na Trustee N920UWBoeing 757-225 · S/N 22199Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · US Bank Na Trustee N921UWBoeing 757-225 · S/N 22201Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · U S Bank Na Trustee N922UWBoeing 757-225 · S/N 22202Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · U S Bank Na Trustee N923UWBoeing 757-225 · S/N 22203Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · U S Bank Na Trustee N924UWBoeing 757-225 · S/N 22204Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · U S Bank Na Trustee N925UWBoeing 757-225 · S/N 22205Cancelled Aug 22, 2011 · Triennial form not returned · Built 1983 · U S Bank Na Trustee N7289ACessna 172 · S/N 29389Cancelled Apr 4, 2011 · Expired dealer · Built 1956 · Younkin Aviation Corp N504AUBoeing 737-3B7 · S/N 23379Cancelled Oct 6, 2010 · Triennial form not returned · Built 1987 · Aircraft Statutory Trust N504au N505AUBoeing 737-3B7 · S/N 23380Cancelled Oct 6, 2010 · Triennial form not returned · Built 1987 · Aircraft Statutory Trust N505au N506AUBoeing 737-3B7 · S/N 23381Cancelled Sep 29, 2010 · Triennial form not returned · Built 1987 · Aircraft Statutory Trust N506au N324SWBoeing 737-3H4 · S/N 23414Cancelled Dec 31, 2009 · Triennial form not returned · Built 1987 · U S Bank Na Trustee N249TACessna U206G · S/N U20605865Cancelled Oct 14, 2008 · Exported to Canada · Built 1980 · One Wrh LLC N900CEGrumman G-1159 · S/N 010Cancelled Sep 15, 2008 · Cashman Equipment Corp N959UMcdonnell Douglas DC-9-82(MD-82) · S/N 49704Cancelled Aug 19, 2008 · Exported to Afghanistan · Built 1988 · U S Bank Na-Owner Trustee N777AVBeech 76 · S/N ME-20Cancelled Jul 9, 2008 · Exported to Australia · Built 1978 · Malledant Gerard R N1148XPiper PA-32-300 · S/N 32-7540148Cancelled Jan 29, 2008 · Exported to South Africa · Built 1975 · Lsa Inc N305WABoeing 737-347 · S/N 23346Cancelled May 4, 2007 · Triennial form not returned · Built 1985 · US Bank Na Trustee N306WABoeing 737-347 · S/N 23347Cancelled May 4, 2007 · Triennial form not returned · Built 1985 · US Bank Na Trustee N6535JPiper PA-28-180 · S/N 28-4976Cancelled Mar 7, 2007 · Triennial form not returned · Built 1968 · Orr Keith M N2310Boeing 737-347 · S/N 23596Cancelled Mar 17, 2006 · Built 1986 · U S Bank Na Trustee N59788Piper PA-31-325 · S/N 31-7612031Cancelled May 10, 2005 · Exported to Canada · Built 1975 · L S O Ventures Inc DBA N325PXSaab-Fairchild 340A · S/N 340A-051Cancelled May 2, 2005 · Exported to South Africa · US Bank Na Trustee

Back to Boston, MA