Skip to content

Cancelled registrations · 27

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 = 'AZ' AND d.registrant_city = 'SURPRISE' 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 = 'AZ' AND d.registrant_city = 'SURPRISE'
  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 = 'AZ' AND d.registrant_city = 'SURPRISE'
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.

N941CCAerospatiale AS350BA · S/N 2471Cancelled Mar 23, 2026 · Exported to Canada · Built 1991 · Howe Aviation LLC N712SHAmerican Eurocopter AS350B2 · S/N 7102Cancelled Jun 7, 2023 · Exported to Canada · Built 2011 · Howe Aviation LLC N311ATEurocopter AS 350 BA · S/N 2277Cancelled Mar 31, 2022 · Exported to Canada · O307 LLC N3386XMooney M20F · S/N 670030Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1966 · Mccrum James M N16390Piper PA-28-140 · S/N 28-7325262Cancelled Nov 17, 2018 · Sale reported, canceled · Built 1970 N4454DBeech G35 · S/N D-4598Cancelled May 30, 2018 · Sale reported, canceled N40ELLantos Ervin CHALLENGER II · S/N C112-0786-B0204Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Demisse Hilina A N4463RCameron Balloons US A-180 · S/N 6213Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1999 · Kbi Leasing LLC N4500DCameron Balloons N-77 · S/N 6335Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2003 · Kbi Leasing LLC N217TPPritchard Thomas S CHALLENGER II · S/N CH2-0903-2376Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Pritchard Thomas S N747TCCassity VARIEZE · S/N 839Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1978 · Mountain Peter W N9393LAmerican AA-1A · S/N AA1A-0093Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1971 · Opgenorth Stephen R N61661Zenith Aircrft CH-701 · S/N 7-3344Cancelled Jul 6, 2017 · Registration expired, pending cancellation · O'Dell Michael C N5301JCameron Balloons US N-105 · S/N 6142Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1998 · Kbi Leasing LLC N6001NLindstrand Balloons 90A · S/N 5125Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1999 · Kbi Leasing LLC N4503WCameron Balloons Z-90 · S/N 6360Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 2003 · Kbi Leasing LLC N5309XCameron Balloons US N-77 · S/N 6177Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1998 · Kbi Leasing LLC N6069WMoulder James H TRIKEZILLA · S/N TUK21M447Cancelled May 15, 2015 · Registration expired, pending cancellation · Moulder James H N770MRuggles Robert M THATCHER CX4 · S/N 192Cancelled May 15, 2015 · Registration expired, pending cancellation · Ruggles Robert M N5PRRennerfeldt ROBERTS GF2 · S/N GF-002RCancelled Dec 18, 2014 · Sale reported, canceled · Built 1977 N6163JJung John Richard JR FIRESTAR II · S/N FS-590Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1998 · Jung John R Jr N6071GArbc Inc DBA Lindstrand 90A · S/N 5139Cancelled May 10, 2013 · Sale reported, canceled · Built 2000 N2303FAeroworks AEROLITE 103 · S/N A-AWI-033001-90-2SICancelled Feb 5, 2009 · Ford Ashely N573BPiper PA-31P · S/N 31P-7530008Cancelled Aug 9, 2006 · Built 1974 · Patton Ronald L N576PDCessna 172S · S/N 172S8576Cancelled Apr 28, 2006 · Exported to Denmark · Built 2000 · System Aero Inc N391DSSorrels Donald W VANS RV-6 · S/N 20206Cancelled Dec 20, 2005 · Exported to United Kingdom · Built 1991 · Wetherell Richard J N61DEBeech N35 · S/N D6765Cancelled Jan 4, 1999 · Triennial form not returned · Diamond Eagle Inc

Back to Surprise, AZ