Skip to content

Cancelled registrations · 33

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 = 'SHOW LOW' 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 = 'SHOW LOW'
  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 = 'SHOW LOW'
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.

N7305Evans SMITH MINIPLANE DSAI · S/N E74-1Cancelled Apr 4, 2026 · Sale reported, canceled · Built 1974 N43GPPeszke S C GP 10/15M · S/N GP-15-E-0002Cancelled Dec 12, 2024 · Exported to Poland · Th Soaring LLC DBA N317EXEurocopter AS 350 B2 · S/N 2818Cancelled Sep 22, 2023 · Exported to Canada · Built 1994 · Aero Products Component Services Inc N441ASStruthers Allen A AVIAT EAGLE II · S/N STRUTHERS 001Cancelled Mar 2, 2023 · Registration expired, pending cancellation · Built 2004 · Struthers Allen A Trustee N5085CBeech 35 · S/N D2347Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1950 · Struthers Allen A N808SAEurocopter AS 350 B3 · S/N 4231Cancelled Jun 6, 2019 · Exported to New Zealand · Built 2007 · Sunrise Air Transportation LLC N211LABell 206B · S/N 3956Cancelled May 6, 2019 · Sale reported, canceled · Built 1987 N911MTEurocopter AS 350 B3 · S/N 3233Cancelled Dec 31, 2018 · Built 1999 · Sunrise Air Transportation LLC N7488YPiper PA-30 · S/N 30-549Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1964 N212LABell 206B · S/N 3957Cancelled May 30, 2018 · Sale reported, canceled · Built 1987 N3202XBell 206B · S/N 3939Cancelled May 30, 2018 · Sale reported, canceled N786JDDixon David K APACHE C · S/N 786JDCancelled Apr 24, 2018 · Registration expired, pending cancellation · Ison Js N1078YBell 206B · S/N 2924Cancelled Jan 26, 2018 · First renewal notice · Built 1980 · Aero Products Component Services Inc N508AABell 206B · S/N 1727Cancelled Jan 26, 2018 · First renewal notice · Built 1975 · Aero Products Component Services Inc N445GHCessna T206H · S/N T20608840Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 2008 · Show Low Ford Inc N5MEKramer Robert CYGNET SF-2A · S/N 252Cancelled May 15, 2017 · Registration expired, pending cancellation · Kramer Robert N19MHCessna 421C · S/N 421C1008Cancelled May 18, 2015 · Registration expired, pending cancellation · Built 1981 · Critical Air Medicine Inc N8507WPiper PA-28-235 · S/N 28-10008Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1963 · Flightline LLC N9844MMaule M-4-210C · S/N 1028CCancelled May 30, 2013 · Registration expired, pending cancellation · Built 1966 · Calhoun Floyd N8468ZCessna 210-5(205) · S/N 2050468Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1963 N8556QCessna TU206F · S/N U20603412Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1976 N84MEDeer Bill TR-1C · S/N 103Cancelled Jun 24, 2010 · Triennial form not returned · Built 1998 · Deer Bill J N103HBeech C-45H · S/N AF-544Cancelled Jun 16, 2009 · Registration revoked · Built 1952 · Air Transit Inc N210EHSabre 10503A · S/N 210210Cancelled Aug 29, 2008 · Built 2001 · Ison J S N384DBBeech 200 · S/N BB-383Cancelled Aug 15, 2002 · Exported to Canada · Built 1978 · City Of Show Low N586DHHudgel Dale L TEENY TWO · S/N 152131Cancelled Jun 23, 1997 · City Of Show Low N999FAMitsubishi MU-2B-36 · S/N 676Cancelled Apr 9, 1997 · Med Arizona Inc N7505UStits SA7D · S/N P455Cancelled Mar 17, 1994 · Triennial form not returned · Shearer Andrew D N8655ZCessna TP206C · S/N P2060455Cancelled Dec 18, 1992 · Triennial form not returned · Pagani Ronald T N1104YCessna 150B · S/N 15059504Cancelled Nov 27, 1992 · Evans Richard L N9819WPiper PA-28-140 · S/N 28-23321Cancelled Mar 23, 1983 · Administratively canceled · Barton James W N5177UCessna 206 · S/N 2060177Cancelled Dec 3, 1975 · Exported to Canada · Show Low Transportation Inc N9145PPiper PA-24-260 · S/N 24-4628Cancelled Aug 24, 1971 · Hall Gene

Back to Show Low, AZ