# Earlier aircraft under this name: City Of Wilmington

A list on [City Of Wilmington](https://openairdocs.org/faa-owner/CITY%20OF%20WILMINGTON.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N16GR](https://openairdocs.org/deregistered/N16GR-2024-11-15.md): DJI MAVIC PRO · S/N 08QCE5D01224VP · Cancelled Nov 15, 2024 · Wilmington, DE
- [N666BL](https://openairdocs.org/deregistered/N666BL-2024-11-14.md): DJI MATRICE 300 RTK · S/N 1ZNBJ6600C00HG · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666BR](https://openairdocs.org/deregistered/N666BR-2024-11-14.md): DJI MATRICE 30T · S/N 1581F5BKD227700B5339 · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666CZ](https://openairdocs.org/deregistered/N666CZ-2024-11-14.md): DJI MATRICE 300 RTK · S/N 1ZNBJ5T00C00AT · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666DP](https://openairdocs.org/deregistered/N666DP-2024-11-14.md): DJI MAVIC 2 ENTERP ADV · S/N 4GCCJ8SR0A0N6Q · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666FP](https://openairdocs.org/deregistered/N666FP-2024-11-14.md): DJI MATRICE 210 V1 · S/N OGODF3M0230009 · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666LB](https://openairdocs.org/deregistered/N666LB-2024-11-14.md): DJI MAVIC 2 ENTERP ADV · S/N 4GCCK6QR0B0QPP · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666MP](https://openairdocs.org/deregistered/N666MP-2024-11-14.md): DJI MAVIC 2 ENTERPRISE · S/N 276DFAP001623X · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666PD](https://openairdocs.org/deregistered/N666PD-2024-11-14.md): DJI MATRICE 210 V1 · S/N OGODECE230007 · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666PW](https://openairdocs.org/deregistered/N666PW-2024-11-14.md): DJI MAVIC 2 ENTERPRISE · S/N 276CH1KR0A00CX · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666RA](https://openairdocs.org/deregistered/N666RA-2024-11-14.md): DJI MATRICE 210 V2 · S/N 1DADFCQ00100BQ · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666XP](https://openairdocs.org/deregistered/N666XP-2024-11-14.md): DJI MAVIC 2 ENTERP ADV · S/N 4GCCK6QR0B0QKB · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666XZ](https://openairdocs.org/deregistered/N666XZ-2024-11-14.md): DJI MATRICE 210 V2 · S/N 1DADG7K00100RQ · Cancelled Nov 14, 2024 · Wilmington, DE
- [N666ZA](https://openairdocs.org/deregistered/N666ZA-2024-11-14.md): DJI MATRICE 30T · S/N 1581F5BKD225S00BU2YF · Cancelled Nov 14, 2024 · Wilmington, DE
- [N551WW](https://openairdocs.org/deregistered/N551WW-2018-04-23.md): DJI PHANTOM VISION 2+ · S/N BF141024402682 · Cancelled Apr 23, 2018 · Second renewal notice · Wilmington, DE
- [N812VW](https://openairdocs.org/deregistered/N812VW-2018-04-23.md): DJI INSPIRE 1 PRO · S/N W21ADH29021365 · Cancelled Apr 23, 2018 · Wilmington, DE

## 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_name = 'CITY OF WILMINGTON' OR list_contains(d.other_registrant_names, 'CITY OF WILMINGTON')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/CITY%20OF%20WILMINGTON/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.