Skip to content

Cancelled registrations · 91

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 = 'NH' AND d.registrant_city = 'NASHUA' 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 = 'NH' AND d.registrant_city = 'NASHUA'
  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 = 'NH' AND d.registrant_city = 'NASHUA'
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.

N168RKRobinson Helicopter R44 II · S/N 13770Cancelled Dec 12, 2025 · Built 2015 · Rotor Technologies Inc N5EQPiper PA 46-350P · S/N 4636051Cancelled Jul 8, 2023 · Built 1996 · Brown Steven A N603VEDJI MAVIC PRO · S/N 08QDDAFA1200U6Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Eve Telesports LLC N327JDJames A Debruycker MAGNI M-24 PLUS · S/N 24192176Cancelled Mar 2, 2021 · Built 2019 · Debruycker James A Trustee N4352JPiper PA-28-140 · S/N 28-22730Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1967 · Harvey Paul E N333EV3D Robotics SOLO · S/N S111A5001097Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Eve Telesports LLC N2298APiper PA-22-135 · S/N 22-686Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1952 · Willey Ronald C N360EV3D Robotics SOLO · S/N S111A5607613Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Eve Telesports LLC N6748ECessna 175A · S/N 56248Cancelled Jan 14, 2019 · Built 1959 · Rush Michael J N6015KCirrus Design SR22 · S/N 0604Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2003 · Dondorf Wolfgang N531PABritish Aerospace BAE JETSTREAM 3101 · S/N 748Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1987 · Pan Am Railways Inc N158ZBeech 58P · S/N TJ-180Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1978 · New Hampshire Community Technical College-Nashua N6863HCessna 172M · S/N 17265617Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1975 · Air Direct Airway Charter Trust Co N8208FCessna 150F · S/N 15064308Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1966 · Lison Denis Gregory N7318PPiper PA-24-250 · S/N 24-2495Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Terry Charles N220RGGrenier Raymond VANS AIRCRAFT RV-8 · S/N 004Cancelled Sep 27, 2016 · First renewal notice · Built 2007 · Grenier Raymond N4GNBeech E-90 · S/N LW-38Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1973 · Gallagher Joseph L N2344RPiper PA-23-250 · S/N 27-8154017Cancelled Jun 27, 2014 · Exported to Bahamas · Built 1981 · Finair LLC N68YPiper PA-30 · S/N 30-953Cancelled Oct 23, 2013 · Revoked, canceled · Built 1965 · Flynn George H N8889PPophal Brad Lee ACRO SPORT II · S/N 526Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Pophal Brad L N288CAPiper PA-28-181 · S/N 2843132Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1998 · Cohen Eric A N9553HCessna 172M · S/N 17266224Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1975 · Morgeist Corp N530PABritish Aerospace BAE JETSTREAM 3101 · S/N 732Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Pan Am Railways Inc N313MEEdwards Mark L KR-2M · S/N 888Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Edwards Mark L N4542YYetter Edward W JR TIERRA II · S/N 5157Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Yetter Edward W N1377XPandora Edward G B-8M · S/N 1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Pandora Edward N8390EMooney M20A · S/N 1568Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1960 · Evans Jeffrey A N3674UBalloon Works FIREFLY 7 · S/N F7-089Cancelled May 9, 2013 · Sale reported, canceled N6909YPiper PA-23-250 · S/N 27-4264Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1969 · White G Gregory DBA N65313Cessna T-50 · S/N 6587Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1944 · Edwards Mark L DBA N10KHHergenrother Karl VARIEZE · S/N 1084Cancelled Apr 22, 2013 · Third renewal notice · Built 1982 · Twining William L N191DVVogel David L WINDWAGON · S/N 367Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Vogel David L N708GAGrumman American Avn. GA-7 · S/N GA7-0008Cancelled Feb 20, 2013 · Sale reported, canceled N919QBeech B95A · S/N TD-494Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1962 · East Coast Flightcraft Services Inc N201KJMooney M20J · S/N 24-0293Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1977 · Washburn Allan K N26108Piper J3F-50 · S/N 4064Cancelled Aug 22, 2012 · Sale reported, canceled · Built 1941 N181DCessna 310D · S/N 39170Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1960 · Blackburn Gerald E N47574Piper PA-32R-300 · S/N 32R-7880014Cancelled Aug 6, 2012 · Revoked, canceled · Ames Charles E N1092RRaven S55A · S/N S55A-281Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1976 · Mason Matthew E N3146CSwannee Special SWANNEE SPECIAL · S/N 125Cancelled May 24, 2012 · Registration pending, canceled · Built 1961 N8041JRobinson Helicopter R22 BETA · S/N 1061Cancelled Sep 12, 2011 · Second renewal notice · Built 1989 · C-R Helicopters Inc N37901Beech A24R · S/N MC-145Cancelled Mar 16, 2011 · Exported to Paraguay · Built 1973 · Gfw Aeroservices Inc N8757QCessna U206F · S/N U20603510Cancelled Oct 5, 2010 · Exported to Guyana · Built 1976 · Persaud Munidat N711BTPitts Aerobatics S-2B · S/N 5063Cancelled Mar 3, 2010 · Exported to Japan · Cooper Andrew N71933Cessna U206C · S/N U206-1227Cancelled Feb 9, 2010 · Exported to Guyana · Built 1968 · Persaud Munidat N536PABritish Aerospace BAE JETSTREAM 3101 · S/N 681Cancelled Dec 31, 2008 · Exported to Haiti · Pan Am Railways Inc N296TCFerguson Donald A VELOCITY XL-RG-5 · S/N 3RX131Cancelled Oct 28, 2008 · Exported to Poland · Piekarz Jerzy N3708BBeech F33A · S/N CE-928Cancelled Sep 18, 2007 · Triennial form not returned · Built 1980 · Brown Wilfred L N200RGGrenier Raymond H ROTORWAY EXEC 162F · S/N 6731Cancelled Jan 29, 2007 · Built 2004 · Grenier Raymond H N1381JRockwell International 112A · S/N 381Cancelled Aug 22, 2006 · Triennial form not returned · Built 1975 · 114 Interactive Group LLC

Back to Nashua, NH