# Cancelled registrations: Jessup, MD

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

Cancelled aircraft registrations in Jessup, MD.

- [N937WP](https://openairdocs.org/deregistered/N937WP-2020-02-28.md): Uav Solutions TALON 120LE · S/N 139 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N934WP](https://openairdocs.org/deregistered/N934WP-2020-02-03.md): Uav Solutions TALON 120LE · S/N 136 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N935WP](https://openairdocs.org/deregistered/N935WP-2020-02-03.md): Uav Solutions TALON 120LE · S/N 137 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N936WP](https://openairdocs.org/deregistered/N936WP-2020-02-03.md): Uav Solutions TALON 120LE · S/N 138 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N938WP](https://openairdocs.org/deregistered/N938WP-2020-02-03.md): Uav Solutions TALON 120LE · S/N 140 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N939WP](https://openairdocs.org/deregistered/N939WP-2020-02-03.md): Uav Solutions TALON 120LE · S/N 141 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Uav Solutions Inc
- [N607BD](https://openairdocs.org/deregistered/N607BD-2019-09-06.md): Uav Solutions TALON 120LE · S/N 112 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Uav Solutions Inc
- [N742ZR](https://openairdocs.org/deregistered/N742ZR-2019-09-06.md): DJI PHANTOM 2 VISION + · S/N PH636127698 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Rothfuss Engineering Co
- [N157BD](https://openairdocs.org/deregistered/N157BD-2019-01-11.md): Uav Solutions PHOENIX ACE LE · S/N 103 · Cancelled Jan 11, 2019 · Uav Solutions Inc
- [N903BD](https://openairdocs.org/deregistered/N903BD-2019-01-11.md): Uav Solutions TALON 240-G · S/N 103 · Cancelled Jan 11, 2019 · First renewal notice · Uav Solutions Inc
- [N906BD](https://openairdocs.org/deregistered/N906BD-2019-01-11.md): Uav Solutions TRIDENT UAV · S/N 107 · Cancelled Jan 11, 2019 · Uav Solutions Inc
- [N154BD](https://openairdocs.org/deregistered/N154BD-2019-01-09.md): Uav Solutions PHOENIX 15 · S/N 12 · Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Uav Solutions Inc
- [N244BD](https://openairdocs.org/deregistered/N244BD-2018-08-20.md): Uav Solutions TALON 240-G · S/N 102 · Cancelled Aug 20, 2018 · Registration expired, pending cancellation · Uav Solutions Inc
- [N240BD](https://openairdocs.org/deregistered/N240BD-2018-08-18.md): Uav Solutions TALON 240 · S/N 105 · Cancelled Aug 18, 2018 · Registration expired, pending cancellation · Uav Solutions Inc
- [N301BD](https://openairdocs.org/deregistered/N301BD-2018-08-18.md): Uav Solutions PHOENIX 30 · S/N 113 · Cancelled Aug 18, 2018 · Registration expired, pending cancellation · Uav Solutions Inc
- [N604BD](https://openairdocs.org/deregistered/N604BD-2018-08-18.md): Uav Solutions PHOENIX 60 · S/N 137 · Cancelled Aug 18, 2018 · Registration expired, pending cancellation · Uav Solutions Inc
- [N1620Y](https://openairdocs.org/deregistered/N1620Y-1998-04-01.md): Cessna 172C · S/N 17249320 · Cancelled Apr 1, 1998 · Triennial form not returned · Claudy Steven A

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

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