# Cancelled registrations: Green Valley, AZ

A list on [Green Valley, AZ](https://openairdocs.org/faa-place/AZ/Green%20Valley.md).

Cancelled aircraft registrations in Green Valley, AZ.

- [N508SR](https://openairdocs.org/deregistered/N508SR-2025-02-06.md): Gates Lear Jet 24E · S/N 347 · Cancelled Feb 6, 2025 · Sale reported · Built 1977
- [N701KY](https://openairdocs.org/deregistered/N701KY-2023-01-04.md): Groff A Kenneth STOL CH 701 · S/N 74305 · Cancelled Jan 4, 2023 · Built 2013 · Groff A Kenneth
- [N1145D](https://openairdocs.org/deregistered/N1145D-2020-08-02.md): Cessna 140A · S/N 15708 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1951 · Lowe Harper C
- [N418DD](https://openairdocs.org/deregistered/N418DD-2018-05-01.md): Cessna 172L · S/N 17260474 · Cancelled May 1, 2018 · Built 1972 · Meyer Dan
- [N2431W](https://openairdocs.org/deregistered/N2431W-2017-10-27.md): Schweizer SGS 1-26B · S/N 362 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1966 · Corwell Kulesza George G
- [N17887](https://openairdocs.org/deregistered/N17887-2013-11-29.md): Schweizer SGS 2-33A · S/N 257 · Cancelled Nov 29, 2013 · Exported to Canada · Gordon Jerry C
- [N614LF](https://openairdocs.org/deregistered/N614LF-2013-09-12.md): Air Creation CLIPPER · S/N 1998FR · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1998 · Romanelli Fred
- [N5884Z](https://openairdocs.org/deregistered/N5884Z-2013-04-23.md): Piper PA-22-108 · S/N 22-9744 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1963 · Bingham Carrol W
- [N516AA](https://openairdocs.org/deregistered/N516AA-2013-04-02.md): Land Noel A FALCON-XP · S/N 600115 · Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1984
- [N537AT](https://openairdocs.org/deregistered/N537AT-2011-10-27.md): Flight Design CTSW · S/N 06-09-04 · Cancelled Oct 27, 2011 · Exported to Australia · Built 2006 · A & T Air Adventures LLC
- [N2194Z](https://openairdocs.org/deregistered/N2194Z-1998-01-20.md): Dorrell Carl E QUICKSILVER SPRT II · S/N 506 · Cancelled Jan 20, 1998 · Triennial form not returned · Dorrell Carl E
- [N747RR](https://openairdocs.org/deregistered/N747RR-1995-05-17.md): Ralph'S Transfer SCORPION 133 · S/N RW2869 · Cancelled May 17, 1995 · Triennial form not returned · Livsey Elmr E Buzz
- [N777CJ](https://openairdocs.org/deregistered/N777CJ-1993-05-26.md): Lydick Clark LONG-EZ · S/N 1114 · Cancelled May 26, 1993 · Triennial form not returned · Anderson Robert E
- [N111MG](https://openairdocs.org/deregistered/N111MG-1991-01-17.md): Scheibe ZUGVOGEL IIIB · S/N 1023 · Cancelled Jan 17, 1991 · Second triennial mailing, no response · Tornquist Robet H
- [N808VV](https://openairdocs.org/deregistered/N808VV-1990-07-20.md): Flug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 037 · Cancelled Jul 20, 1990 · Kulesza George G
- [N8698M](https://openairdocs.org/deregistered/N8698M-1972-04-29.md): Beech P35 · S/N D-7284 · Cancelled Apr 29, 1972 · Obrien J J

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 = 'GREEN VALLEY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/AZ/Green%20Valley/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
