Skip to content

Cancelled registrations · 72

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 = 'WA' AND d.registrant_city = 'RICHLAND' 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 = 'WA' AND d.registrant_city = 'RICHLAND'
  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 = 'WA' AND d.registrant_city = 'RICHLAND'
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.

N5770Fracher SP · S/N 002Cancelled Jan 14, 2026 · Sale reported, pending cancellation · Built 1971 N1374Cherokee II SAILPLANE · S/N FEP-10Cancelled May 31, 2024 · Built 1970 · Collins Dennis L N123FBShallbetter Michael FLY BABY 1A · S/N 2209Cancelled Nov 12, 2023 · Built 2002 · Collins Dennis L N29166Aeronca 65-TC · S/N 2280TCancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1940 · Urban Scott J N26YZGrignon Yves GLASAIR · S/N 150Cancelled May 29, 2020 · Registration expired, pending cancellation · Badgett Mark E N370BADJI Innovations S1000 PREMIUM · S/N BNL-DJIS1000PCancelled Jan 6, 2020 · Registration expired, pending cancellation · Bnl Technical Services LLC N7865BDJI Innovations PHANTOM 2 · S/N BNL-DJIPH2-1Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Bnl Technical Services LLC N560WPCessna 560 · S/N 560-0422Cancelled Nov 7, 2019 · Built 1997 · Watts Flying Service LLC N130BPUniversity Of Colorado Boulder DATAHAWK · S/N CU-DH2-12Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Pacific Northwest National Laboratory N230BPUniversity Of Colorado Boulder DATAHAWK · S/N CU-DH2-13Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Pacific Northwest National Laboratory N330BPUniversity Of Colorado Boulder DATAHAWK · S/N CU-DH-14Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Pacific Northwest National Laboratory N430BPUniversity Of Colorado Boulder DATAHAWK · S/N CU-DH-15Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Battelle Pacific Northwest National Laboratory N219ALYuneec TYPHOON Q500 4K · S/N YU15200361B04A01Cancelled May 30, 2018 · Sale reported, canceled N5192WPiper PA-28 · S/N 28-227Cancelled May 30, 2018 · Sale reported, canceled · Built 1961 N29MMMeyer Milon Jay MEYER-LEGACY · S/N L2K-197Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2009 · Meyer Milon Jay N255BZPaul R Seipt SONEX · S/N 0255Cancelled Aug 14, 2017 · Built 2016 · Seipt Paul R N155MLLong Michael R CHALLENGER II · S/N CHII 1052Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Long Michael R N8170WPiper PA-28-180 · S/N 28-2289Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1965 · Johanning Kenneth L N143EZHusa Emett Ivar VARI EZE · S/N 992Cancelled Dec 23, 2015 · Built 1983 · Husa Emmett Ivar N81560Cessna 208B · S/N 208B5077Cancelled May 19, 2015 · Built 2013 · Battelle Memorial Institute N81562Cessna 208B · S/N 208B5079Cancelled May 19, 2015 · Built 2013 · Battelle Memorial Institute N99989Pilatus B-4 · S/N 106Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1974 · Davis Karl C N5001SBeechcraft B300 · S/N FL-901Cancelled Apr 28, 2015 · Built 2013 · Battelle Memorial Institute N5004PBeechcraft B300 · S/N FL-904Cancelled Apr 28, 2015 · Built 2014 · Battelle Memorial Institute N510ZPBell Helicopter Textron Canada 412EP · S/N 36670Cancelled Mar 12, 2015 · Sale reported · Built 2014 N22LTSmith AEROSTAR 601 · S/N 61-0231-098Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1975 · Ma West Rockies Corp N36CMMiller Charles E MA-5 CHARGER · S/N CM1Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1980 · Grow James M N510XBBell Helicopter Textron Canada 412EP · S/N 36667Cancelled Oct 7, 2014 · Sale reported · Built 2014 N3002HEngineering & Research ERCOUPE 415-C · S/N 3627Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1946 · Rising John D N321VGlaser-Dirks DG-400 · S/N 4-149Cancelled Sep 29, 2014 · Exported to Brazil · Seim Thomas A N511BEBell Helicopter Textron Canada 412EP · S/N 36664Cancelled Sep 29, 2014 · Sale reported · Built 2014 N234RVVersteeg Robert H JR HELICYCLE · S/N 2-22Cancelled Mar 10, 2014 · First renewal notice · Built 2012 · Versteeg Robert H Jr N71513Diera Lewis G JR HP-18 · S/N 18-134Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Diera Jr Lewis G N64TMMason William Brent DRAGONFLY · S/N 958Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1991 N234ASSampson Allan BAKENG DUCE · S/N 154Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Sampson Allan G N582ACAero Commander 500 S · S/N 1861-40Cancelled Apr 4, 2013 · Exported to Brazil · Built 1969 · Euro Wings Inc N18EXHome Built SINGLE PLACE AIRPLAN · S/N 2Cancelled Jan 25, 2013 · Built 1997 · Bigelow Charles E N2126KMead Jeromie O CHALLENGER II · S/N CH2 0488 B 0302Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Mead Jeromie O N7215CCalvi Lawrence B SEAREY · S/N 1DK080Cancelled Oct 30, 2012 · Sale reported, pending cancellation · Built 1997 N81623Hanchette Scott B HANCHETTE SAETA · S/N HS9861Cancelled Sep 18, 2012 · Sale reported, pending cancellation N1770QCessna 150L · S/N 15073070Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1971 N318PBBell Helicopter Textron Canada 412EP · S/N 36478Cancelled Aug 1, 2011 · Exported to Pakistan · Built 2008 · US Dept Of Energy Pacific Nw Site Office N366MBBell Helicopter Textron Canada 412EP · S/N 36497Cancelled Aug 1, 2011 · Exported to Pakistan · Built 2008 · U S Department Of Energy N10299Bell Helicopter Textron Canada 412EP · S/N 36519Cancelled Jul 29, 2011 · Exported to Pakistan · Built 2009 · U S Department Of Energy N111SZBeech B300 · S/N FL-45Cancelled Jul 29, 2011 · Exported to Pakistan · Built 1991 · US Department Of Energy N319DABell Helicopter Textron Canada 412EP · S/N 36476Cancelled Jul 29, 2011 · Exported to Pakistan · Built 2008 · U S Department Of Energy N373FBBell Helicopter Textron Canada 412EP · S/N 36508Cancelled Jul 29, 2011 · Exported to Pakistan · Built 2008 · US Department Of Energy N1883VCessna 172M · S/N 17263780Cancelled Mar 2, 2010 · Built 1975 · Kennewick Aircraft Services Inc N199EABeech 99 · S/N U-37Cancelled May 12, 2009 · Registration revoked · Built 1968 · Columbia Pacific Leasing Inc N6463SSchmitt Andrew L EXEC 162 F · S/N 6463Cancelled May 12, 2008 · Triennial form not returned · Built 2000 · Schmitt Andrew L

Back to Richland, WA