Skip to content

Casa Grande, AZ

Cancelled registrations · 76

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 = 'CASA GRANDE' 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 = 'CASA GRANDE'
  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 = 'CASA GRANDE'
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.

N330AKQuest KODIAK 100 · S/N 100-0278Cancelled Nov 17, 2025 · Exported to Canada · Built 2019 · Fertilizer Co Of Arizona Inc N2953CCessna 180 · S/N 30853Cancelled May 9, 2024 · Revoked, pending cancellation · Built 1954 · Columbine Parachute Center Inc N7140PHegerhorst Dennis R KITFOX · S/N 515Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Hively Timothy J N146SJDJI INSPIRE 1 · S/N W21ACJ23010044Cancelled Jan 14, 2023 · Sale reported, canceled N498CGDJI SPARK · S/N 0ASUFAK0020081Cancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Casa Grande Fire Dept N499CGDJI SPARK · S/N 0ASUFAK0020566Cancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Casa Grande Fire Dept N504CGDJI MAVIC 2 ENTERPRISE · S/N 298DG1B001KX4SCancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Casa Grande Fire Department N220LMDJI PHANTOM 3 PROFESSION · S/N P76DCF24013002Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Martinez Luis E N83274Aeronca 7AC · S/N 7AC1938Cancelled May 16, 2019 · Revoked, pending cancellation · Built 1946 · Mcmahon Austin N43195Taylorcraft BC12-D · S/N 6854Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1946 · Bradney Wayne A N707TNAeros VENTURE · S/N 896062Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 2001 · Stueland Paul R N2357AQuad City Ultralight CHALLENGER II · S/N CH2-0803-2353Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 2003 · Baeza Ramiro N92XSAviation Technoligies FW XS · S/N 91XS01Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1992 · Geres Charles K N5477DBeech H35 · S/N D-5007Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Terrell Robert G N4419GQuicksilver MXL II SPORT · S/N 000617Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1995 · Allen C Leon N6170GAircraft Mfg & Dvlpmt CH601XLI SLSA · S/N 601-019SCancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 2006 · O'Grady Robert F Jr N2205RCessna T210H · S/N T210-0355Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1968 · Rosales Antonio Perez Vargas N98916Piper PA-12 · S/N 12-267Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Gomez George Floyd N6121ZPiper PA-25 · S/N 25-141Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1960 · Hamilton William E N9886RBeech M35 · S/N D-6457Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1960 · Nelson Roger DBA N278MLBellanca 8KCAB · S/N 30177Cancelled May 22, 2015 · Registration expired, pending cancellation · Built 1977 · Nelson Roger N9309TZander Wayne F SPORTLITE 103 · S/N 001Cancelled May 11, 2015 · Sale reported, canceled · Built 2007 N759VACessna 182Q · S/N 18266283Cancelled Jan 29, 2015 · Third renewal notice · Built 1978 · Mccarville Kirk P N9633ZIntermountain CALLAIR A-9 · S/N 1036Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1963 · Hamilton William E N421SCessna 421 · S/N 421-0063Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1968 · Hamilton W.E.N8133NFairchild Hiller FH-1100 · S/N 69Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Hamilton William E N5052ESchlitter Randy RANS S-9 · S/N 1087022Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1988 · Wise Gary N Sr N586WAColovos George C RANS 5 COYOTE · S/N 503316Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2005 N2373YThen Alojzy MITCHELL U-2 · S/N 251Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1985 · Then Alojzy N734GHCessna 172N · S/N 17268839Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1977 · Hatfield James F N23879Rucker Gary R QUICKSILVER MX II · S/N 1133Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Dean Daniel L N6589Grumman G-164A · S/N 730Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Waits Albert W DBA N6645ECessna 175 · S/N 56145Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1959 · Shaw Jesse W N5640JCessna A188A · S/N 18800590Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · Abc N53388Cessna A188B · S/N 18801804TCancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1974 · Lehman Aviation Inc N74449Bellanca 14-13-2 · S/N 1562Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1947 N4684BCessna 180 · S/N 31582Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1955 · Rasmussen Lynn W N57815Piper PA-36-285 · S/N 36-7660121Cancelled Nov 14, 2012 · Revoked, canceled · Built 1976 · Avtech Ag Plane Center Inc N2939WWeatherly 201B · S/N 606Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1972 · Waits Albert W N21578Cessna 172M · S/N 17263976Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1974 · Aero Grande Aviation N7250UBeech A36 · S/N E-2276Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1985 N2563XCessna P206 · S/N P206-0063Cancelled Aug 22, 2012 · Sale reported, canceled · Built 1965 N4407SKelley Tim FISHER FP 404 · S/N 4092Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Feezer Charles Ross N108KBeech D18S · S/N A-88Cancelled Jul 1, 2011 · Sale reported, canceled · Built 1946 N12VBBeech 95-B55 (T42A) · S/N TC-1064Cancelled Apr 27, 2009 · Triennial form not returned · Built 1968 · Mm Aviation LLC N8606MBeech 95-A55 · S/N TC-489Cancelled Oct 24, 2001 · Triennial form not returned · Built 1963 · Nelson Roger DBA N3295CBeech E35 · S/N D3962Cancelled Jun 30, 2000 · Triennial form not returned · Nelson Roger N7162ZPiper PA-25-235 · S/N 253019Cancelled Sep 11, 1998 · Exported to Mexico N7240ZPiper PA-25-235 · S/N 253164Cancelled Sep 11, 1998 · Exported to Mexico N8111VCessna A188 · S/N 1880361Cancelled Jun 16, 1998 · Exported to Mexico · Hamilton William E

Back to Casa Grande, AZ