Sierra Vista, AZ

Cancelled registrations · 37

Query with SQL
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 = 'SIERRA VISTA'
  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.

N9338TMartin Uav V-BAT · S/N VBP-100043Cancelled Mar 8, 2025 · Sale reported, canceledN952SQMartin Uav V-BAT · S/N VB-100061Cancelled Mar 8, 2025 · Sale reported, canceledN7386QCessna 182P · S/N 18261026Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1972 · Curfman Kenneth JN24939Cessna 152 · S/N 15280460Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Armstrong Brandon MN4788SUnmanned Systems SANDSTORM · S/N 11-004ECancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2011 · Northrop Grumman Technical Services IncN4789SUnmanned Systems SANDSTORM · S/N 11-005ECancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2011 · Northrop Grumman Technical Services IncN94736Air Creation TANARG · S/N T06074Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2006 · Anderson Ben L JrN822WWilbers Richard A ZODIAC 601 HDS · S/N 63357Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2006 · Anderson Ben L JrN88541Unmanned Systems SANDSTORM E-SERIES · S/N 12-012ECancelled Apr 4, 2018 · Registration expired, pending cancellation · Northrup Grumman Technical Services IncN9067NAerostar International RAVEN S57-A · S/N RX8-3162Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1993 · Hickman GrantN719QLUnmanned Systems SANDSTORM E-SERIES · S/N 12-015ECancelled Mar 29, 2018 · Registration expired, pending cancellation · Northrop Grumman Technical Services IncN6162YMccluskey Bob CHALLENGER II · S/N CH2 1093 P1035Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1996 · Outenreath James C JrN88542Unmanned Systems SANDSTORM E-SERIES · S/N 12-013ECancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Technical Services IncN738JQUnmanned Systems SANDSTORM E-SERIES · S/N 12-014ECancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Technical Services IncN110LHHamilton Larry A 600 TALON · S/N 7078Cancelled Jan 10, 2018 · Exported to Peru · Built 2009 · Hamilton Victor SN2812SRaven S-60A · S/N S60A-418Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1985 · Perzee Raymond MN4097WRaven Industries RALLY RX7 · S/N RX7-325Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1983 · Perzee Raymond MN4MGAerotek PITTS SPECIAL S-1S · S/N 1-0016Cancelled Nov 10, 2016 · First renewal notice · Built 1974 · Gutman Meyer MN12041Doyle ROG · S/N 1Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1963 · Atlas Philip SN5580NCessna T-50 · S/N 4770Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1943 · Wardle James JN6236XCessna TU206G · S/N U20605843Cancelled Nov 29, 2013 · Exported to Bolivia · Built 1980 · Kenan LtdN81120Mcclish FUNK B · S/N 250Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1946N63018Aerostar International RAVEN S57-A · S/N S57A-3104Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1990N5574FPiper PA-28-140 · S/N 28-25010Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1968 · Belt Michael EN88889Chapman SCORPION TOO · S/N 4728Cancelled May 17, 2013 · Registration expired, pending cancellation · Wardle James JN33KGGoddard Kent ROTORWAY EXECUTIVE · S/N 3131Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1984 · Goddard KentN59380Nolen-Dennis SCORPION 133 · S/N 526-46Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1978 · Wardle James JN113EWBeech 95-B55 (T42A) · S/N TC-1099Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1968 · Correll Coy BN8036FArbet Douglas E QUICKSILVER SPORT II · S/N 000591Cancelled Mar 19, 2013 · Sale reported, canceled · Built 1994N480EKBraze Edward VARIEZE · S/N 213Cancelled Jun 14, 2005 · Built 1980 · Land Verlon JN210NFCessna T210L · S/N 21060043Cancelled Oct 17, 2003 · Sale reported · Built 1973N59028Cessna T210L · S/N 21060034Cancelled May 10, 1977 · Doser Thomas LN8751NPiper PA-28-140 · S/N 2825770Cancelled May 27, 1976 · Built 1969 · Nelson Aero ServiceN9475LAmerican AA-1A · S/N AA1A-275Cancelled Jun 28, 1973 · Stachel Robert DN4746ZPiper PA-22-108 · S/N 22-8302Cancelled Jan 2, 1972 · Harry T Pierson JrN1747VCessna 120 · S/N 13932Cancelled Jul 8, 1970 · Pierson Harry TN1567APiper PA-20 · S/N 20-775Cancelled Jun 1, 1967 · Exported to Canada · Nick Marvin E
Back to Sierra Vista, AZ