Skip to content

Bullhead City, AZ

Cancelled registrations · 35

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 = 'BULLHEAD CITY' 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 = 'BULLHEAD CITY'
  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 = 'BULLHEAD CITY'
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.

N496PPerron Paul TEAM EROS · S/N 001Cancelled May 30, 2026 · Registration pending, canceled · Built 2000 N4694DBeech H35 · S/N D-4871Cancelled Dec 28, 2018 · Revoked, canceled · Built 1956 · Smith J E N3164CBalloon Works FIREFLY 8 · S/N F8-415Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Guenther Jerome H N6206KCessna 150M · S/N 15077586Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1975 · Atkins Violet L N32LBLake LA-4-200 · S/N 631Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1974 · Sheble Joseph F III N403CFAgusta A119 · S/N 14009Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2000 · Tri-State Care Flight LLC N5298LHenderson William R HOLLYWOOD · S/N 1969Cancelled May 16, 2017 · Registration expired, pending cancellation · Built 1994 · Henderson William R N8118APiper PA-28-236 · S/N 28-8011028Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1979 · Mackel Nealan N1147TMooney M20K · S/N 25-0599Cancelled Sep 6, 2016 · Third renewal notice · Built 1981 · Greco Edward C N507CFAgusta A109E · S/N 11067Cancelled May 29, 2015 · First renewal notice · Built 2000 · Tristate Careflight LLC N3339NPiper J3C-65 · S/N 22537Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1946 · Zaritshy David N19058Cessna 150L · S/N 15074132Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1972 · Wills John T N6443LAerostar International RX-7 · S/N RX7-3074Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1986 · Martin Paul L N71DDBakeng DOUBLE DUCE · S/N BDD-01Cancelled Dec 2, 2014 · Revoked, canceled · Built 1971 · Benedict Frank K N6448BCessna 172 · S/N 29648Cancelled Sep 9, 2013 · Registration expired, pending cancellation · Built 1957 · Sanders Earl R N50315Cessna 150H · S/N 15069221Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1968 · Aeromed Inc N797TJJohnson Thomas L P-40 · S/N 001Cancelled Mar 19, 2013 · Sale reported, canceled · Built 1997 N177NTL Ultralight Sro STINGSPORT · S/N TLUSA 153Cancelled Nov 20, 2012 · Built 2007 · Bell Harry A Trustee N333PEPiper PA-23-160 · S/N 23-2007Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1962 N15366Balloon Works FIREFLY 7 · S/N 10237Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1981 · Owens Ronald L N7088ELet BLANIK L-13 · S/N 173406Cancelled Mar 28, 2012 · Tamayo George M N151JVVan Deluyster James William SCALE P51 · S/N JVD72001Cancelled May 24, 2010 · Triennial form not returned · Van Deluyster James W N84722Cessna 172K · S/N 17258592Cancelled May 3, 2010 · Triennial form not returned · Built 1969 · Bruehl Rudy N119AHAgusta A119 · S/N 14022Cancelled Jan 8, 2010 · Triennial form not returned · Built 2001 · Tristate Careflight LLC N3156BBowman Charles TITAN TORNADO II · S/N D95XXXC0HK0176Cancelled Jan 23, 2009 · Built 2003 · Sheets Gene A N1016TBeech 95 · S/N TD-108Cancelled May 29, 2002 · Built 1958 · Sheble Aviation & Flight School Inc N2192FCessna U206 · S/N U206-0392Cancelled Jun 14, 1999 · Exported to Mexico · Lambert James R N904LDDossey Lucien L KOLB MARK III · S/N M3218Cancelled Apr 28, 1997 · Dossey Lucien L N732CGCessna P210N · S/N P21000574Cancelled Dec 9, 1991 · Second triennial mailing, no response · Little Aircraft Co Inc N22779Sutherland RUTAN VERI-EZE · S/N 1214Cancelled Aug 7, 1982 · Built 1978 · Sutherland Ralph E N3857WPiper PA-32-260 · S/N 32-799Cancelled May 6, 1981 · Built 1966 · Sturdy William A N4908DCessna 182A · S/N 51008Cancelled Aug 14, 1975 · Exported to Canada · Hollinshead D B N9329WPiper PA-28-235 · S/N 28-11013Cancelled Apr 20, 1972 · Exported to Canada · Hill Wayne M N2714MPiper PA-12 · S/N 12-1129Cancelled Jul 14, 1971 · Zurcher Donald E N5816WPiper PA-28-160 · S/N 28-1961Cancelled Jan 4, 1971 · R E Sutherland

Back to Bullhead City, AZ