# Registered aircraft: Smyrna, DE

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N23231](https://openairdocs.org/aircraft/N23231.md): Cessna 150H · S/N 15068811 · Built 1968 · Jones Robert A
- [N2384S](https://openairdocs.org/aircraft/N2384S.md): Cessna T210L · S/N 21061263 · Built 1976 · Chervenak A Douglas
- [N2969Z](https://openairdocs.org/aircraft/N2969Z.md): Piper PA-28RT-201T · S/N 28R-7931281 · Built 1979 · Jwest Aero LLC
- [N384PB](https://openairdocs.org/aircraft/N384PB.md): Dassault-Breguet FALCON 20 · S/N 384 · Built 1980 · Ovation Jet Parts LLC
- [N3981K](https://openairdocs.org/aircraft/N3981K.md): Piper PA-28-140 · S/N 28-23869 · Built 1967 · Lenko David J
- [N666PF](https://openairdocs.org/aircraft/N666PF.md): DJI PHANTOM 4 PRO · S/N 0AXCF210B30641 · Delaware Emergency Management Agency
- [N675BT](https://openairdocs.org/aircraft/N675BT.md): DJI INSPIRE 1 PRO · S/N W21ACI27010065 · Delaware Department Of Transportation
- [N764ZT](https://openairdocs.org/aircraft/N764ZT.md): DJI INSPIRE 1 PRO · S/N W21ACJ26011854 · Delaware Dept Of Transportation
- [N8082M](https://openairdocs.org/aircraft/N8082M.md): Cessna 150L · S/N 15072542 · Keenan Thomas E Jr
- [N808UD](https://openairdocs.org/aircraft/N808UD.md): DJI PHANTOM 4 PRO · S/N 0AXDDAX0A20609 · First renewal notice · Delaware Department Of Transportation
- [N808VD](https://openairdocs.org/aircraft/N808VD.md): DJI PHANTOM 4 PRO · S/N 0AXDDAX0A20638 · First renewal notice · Delaware Dept Of Transporation
- [N808WL](https://openairdocs.org/aircraft/N808WL.md): DJI PHANTOM 4 PRO · S/N 0AXDDB40A20421 · First renewal notice · Delaware Department Of Transportation
- [N808XL](https://openairdocs.org/aircraft/N808XL.md): DJI PHANTOM 4 PRO · S/N 0AXDDAS0A20134 · First renewal notice · Delaware Department Of Transportation
- [N815ZD](https://openairdocs.org/aircraft/N815ZD.md): DJI PHANTOM 4 PRO · S/N 0AXDDAR0B20051 · First renewal notice · Delaware Emergency Management Agency
- [N8315W](https://openairdocs.org/aircraft/N8315W.md): Piper PA-28-180 · S/N 28-2488 · Built 1965 · Jg Aero LLC
- [N849DF](https://openairdocs.org/aircraft/N849DF.md): DJI U11X MAVIC AIR · S/N 0K1DF1T2BD3662 · Delaware Department Of Transportation
- [N862QG](https://openairdocs.org/aircraft/N862QG.md): DJI MATRICE 210 V1 · S/N 0G02FAX0020002 · Delaware Department Of Transportation
- [N8655U](https://openairdocs.org/aircraft/N8655U.md): DJI MAVIC 2 ENTERPRISE · S/N 298DFCS001PZ34 · Delaware Department Of Transportation
- [N9516K](https://openairdocs.org/aircraft/N9516K.md): Piper PA-28-151 · S/N 28-7615210 · Built 1976 · Smith Dalton L Trustee

## The whole list in SQL

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

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'DE' AND g.registrant_city = 'SMYRNA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/DE/Smyrna/aircraft

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.