# Cancelled registrations: Newhall, CA

A list on [Newhall, CA](https://openairdocs.org/faa-place/CA/Newhall.md).

Cancelled aircraft registrations in Newhall, CA.

- [N300UJ](https://openairdocs.org/deregistered/N300UJ-2018-05-30.md): Gulfstream American G-1159A · S/N 316 · Cancelled May 30, 2018 · Sale reported, canceled · Built 1980
- [N45KR](https://openairdocs.org/deregistered/N45KR-2017-11-15.md): Gulfstream Aerospace G-1159A · S/N 433 · Cancelled Nov 15, 2017 · Built 1984 · 818 Aviation Inc
- [N95NM](https://openairdocs.org/deregistered/N95NM-2017-03-24.md): Gulfstream Aerospace G-1159A · S/N 485 · Cancelled Mar 24, 2017 · 818 Aviation Inc
- [N9454L](https://openairdocs.org/deregistered/N9454L-2016-06-24.md): American AA-1A · S/N AA1A-0254 · Cancelled Jun 24, 2016 · First renewal notice · Built 1971 · Moir Jeffery K
- [N480RW](https://openairdocs.org/deregistered/N480RW-2015-02-26.md): Gulfstream Aerospace G-1159A · S/N 301 · Cancelled Feb 26, 2015 · Sale reported · Built 1980
- [N87063](https://openairdocs.org/deregistered/N87063-2013-09-17.md): Engineering & Research ERCOUPE 415-C · S/N 236 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1946 · Sullivan Shirley
- [N179T](https://openairdocs.org/deregistered/N179T-2013-08-15.md): Gulfstream Aerospace G1159B · S/N 86 · Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1970
- [N5096A](https://openairdocs.org/deregistered/N5096A-2013-06-04.md): King James R PULSAR · S/N 171 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1993 · King James R
- [N3GR](https://openairdocs.org/deregistered/N3GR-2013-04-09.md): Ross Grant D LONG EZ · S/N 930 · Cancelled Apr 9, 2013 · Sale reported, canceled
- [N353VA](https://openairdocs.org/deregistered/N353VA-2013-01-03.md): Gulfstream Aerospace G-1159A · S/N 371 · Cancelled Jan 3, 2013 · Built 1982 · 818 Aviation Inc
- [N2680](https://openairdocs.org/deregistered/N2680-2012-09-18.md): Blake GYRO COPTER · S/N 1WRB · Cancelled Sep 18, 2012 · Revoked, canceled · Blake William R
- [N114D](https://openairdocs.org/deregistered/N114D-1993-11-15.md): Beech 58 · S/N TH69 · Cancelled Nov 15, 1993 · Exported to Argentina · Blumer Robin D
- [N23045](https://openairdocs.org/deregistered/N23045-1991-05-21.md): Cessna 150H · S/N 15068696 · Cancelled May 21, 1991 · Triennial form not returned · Checinski Jan
- [N7320A](https://openairdocs.org/deregistered/N7320A-1991-02-25.md): Cessna A150M · S/N A1500713 · Cancelled Feb 25, 1991 · Triennial form not returned · Checinski Jan
- [N2417](https://openairdocs.org/deregistered/N2417-1971-09-09.md): Sharp ROTOCRAFT · S/N 7 · Cancelled Sep 9, 1971 · Sharp George E
- [N1400](https://openairdocs.org/deregistered/N1400-1971-08-02.md): Bensen B8M · S/N SR-100 · Cancelled Aug 2, 1971 · Rose Larry
- [N2428](https://openairdocs.org/deregistered/N2428-1971-03-01.md): Hanson A · S/N 001 · Cancelled Mar 1, 1971 · Built 1969 · Hanson Thomas F
- [N33E](https://openairdocs.org/deregistered/N33E-1929-07-20.md): Lockheed VEGA 1 · S/N 34 · Cancelled Jul 20, 1929 · Exported to Norway · Lockheed Aircraft Co

## 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 = 'CA' AND d.registrant_city = 'NEWHALL'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/CA/Newhall/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.