Skip to content

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 = 'SUN 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 = 'SUN 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 = 'SUN 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.

N3132QCessna 182K · S/N 18258132Cancelled Oct 11, 2025 · Registration pending, canceled · Built 1967 N6907UMooney M20E · S/N 419Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Lawrence Jeffrey Allen N6787ECessna 175A · S/N 56287Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1959 · Sorter James A N9564DPiper PA-22-160 · S/N 22-6481Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1958 · Opperman Harley J N2947TAero Commander 100 · S/N 071Cancelled Dec 20, 2019 · Sale reported, canceled · Built 1967 N7619SBellanca 7GCBC · S/N 924-76Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1976 · Opperman Harley J N7720UCessna 172E · S/N 17251720Cancelled Feb 21, 2018 · Exported to South Korea · Built 1964 · Brubaker Joseph W N1030LLake LA-4 · S/N 273Cancelled Aug 5, 2016 · Third renewal notice · Built 1963 · Bartsch Harvey L II N1606BLuscombe 11A · S/N 11-112Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1948 · Drexler Joseph S N1776FAlexander Lyle E USA-FLAG · S/N 1350Cancelled May 8, 2015 · Registration expired, pending cancellation · Alexander Lyle E N100PKStokes JS56C · S/N CG1Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1974 · Davis Loyd R N9278ZHiller UH-12E · S/N 1819Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1965 · Valley Sprayer Duster Service Inc N85TLAdams Thomas H DRAGONFLY · S/N 1Cancelled Aug 12, 2014 · Built 1985 · Taigen Robert T N4786RCessna A188B · S/N 18802321Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1975 · Valley Sprayer & Duster Svc N8538SAir Tractor AT-301 · S/N 301-0138Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1978 · Valley Sprayer & Duster Service Inc N3608CBalloon Works FIREFLY 8-24 · S/N F8-004Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1982 · Davies Pete C N15WCCook William Lee BARRACUDA · S/N 117Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Banhagel John G N9436DPiper PA-22-160 · S/N 22-6410Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1959 · Opperman Harley J N8961QAero Commander S2R · S/N 1631RCancelled May 17, 2013 · Registration expired, pending cancellation · Built 1972 · Valley Sprayer & Duster Svc Inc N4524APiper PA-22-150 · S/N 22-3832Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1956 · Opperman Harley J N199TFKovash BOWERS FLY BABY · S/N 2040-1ACancelled Feb 7, 2013 · First renewal notice · Built 1994 · Kovash Neil G N765MHSabre TRIKE · S/N 002Cancelled Nov 14, 2012 · First renewal notice · Built 1997 · Haag Monte L N6613VBellanca 17-30A · S/N 30264Cancelled Oct 11, 2012 · Sale reported, pending cancellation · Built 1970 N1161CPiper PA-22-135 · S/N 22-987Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Built 1953 · Opperman Harley J N4332BBeckley Chet R RANS S-6ES COYOTE II · S/N 01981197Cancelled Jul 5, 2006 · Exported to China · Built 1998 · Snyder Edward A N6338PPiper PA-24-180 · S/N 24-1448Cancelled Apr 28, 2006 · Triennial form not returned · Built 1959 · Skeers Keith E N320VMuller Robert F LANCAIR 320 · S/N 001Cancelled Apr 22, 2002 · Triennial form not returned · Built 1993 · Muller Robert F Trustee N3869ABeech A36 · S/N E1853Cancelled Jun 25, 1997 · Osgood Sewall M N3634PPiper PA-22-150 · S/N 223368Cancelled Aug 21, 1996 · Triennial form not returned · Peterson Daniel L N60099Robertson George H THORP T-18 · S/N 1364Cancelled May 16, 1996 · Robertson George H N5206TPiper PA-28-140 · S/N 287225351Cancelled Feb 10, 1992 · Triennial form not returned · Bell Frederick F N113HAHiller UH-12E · S/N HA3013Cancelled Jan 25, 1984 · Administratively canceled · Valley Sprayer & Duster Svs Inc N62903Hiller UH-12E · S/N 1097Cancelled Jan 18, 1984 · Valley Sprayer And Duster Service Inc N70143Cessna A188B · S/N 18801848TCancelled Jan 4, 1982 · Valley Sprayers & Dusting Service Inc N994XGrumman G-164A · S/N 519Cancelled Oct 20, 1981 · Mcneley Aviation Corp

Back to Sun City, AZ