# Cancelled registrations: Smithfield, NC

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

Cancelled aircraft registrations in Smithfield, NC.

- [N7535Z](https://openairdocs.org/deregistered/N7535Z-2025-04-17.md): Robinson Helicopter R22 BETA · S/N 3477 · Cancelled Apr 17, 2025 · Exported to Australia · Built 2003 · N7535z LLC
- [N721BL](https://openairdocs.org/deregistered/N721BL-2022-10-12.md): Textron 172S · S/N 172S12159 · Cancelled Oct 12, 2022 · Exported to India · Built 2018 · Blue Line Aviation LLC
- [N170BL](https://openairdocs.org/deregistered/N170BL-2022-10-11.md): Textron 172S · S/N 172S12166 · Cancelled Oct 11, 2022 · Exported to India · Built 2018 · Blue Line Aviation LLC
- [N401BL](https://openairdocs.org/deregistered/N401BL-2022-03-15.md): Diamond Aircraft Ind DA 40 NG · S/N 40.NC026 · Cancelled Mar 15, 2022 · Exported to Poland · Built 2018 · Blue Line Aviation LLC
- [N5610B](https://openairdocs.org/deregistered/N5610B-2017-11-21.md): Cessna 182 · S/N 33610 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1956 · C S W Inc
- [N554XA](https://openairdocs.org/deregistered/N554XA-2015-05-04.md): Burrus Robert S JR ROTEC RALLY 3 · S/N 64624 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1982 · Lee Stephen Dalton
- [N25805](https://openairdocs.org/deregistered/N25805-2014-10-27.md): Beech A36 · S/N E-2310 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1986 · John-Aire-Inc
- [N9491R](https://openairdocs.org/deregistered/N9491R-2013-05-23.md): Snow S2A · S/N 1130A · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1962 · Stancil Thomas E Jr
- [N9473H](https://openairdocs.org/deregistered/N9473H-2013-03-20.md): Fairchild M-62A-3 · S/N FT-728 · Cancelled Mar 20, 2013 · Sale reported, canceled
- [N6055A](https://openairdocs.org/deregistered/N6055A-2013-02-08.md): Cessna 172 · S/N 28655 · Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1956
- [N4756R](https://openairdocs.org/deregistered/N4756R-2012-09-12.md): Cessna A188B · S/N 18802316T · Cancelled Sep 12, 2012 · Revoked, canceled · Built 1975 · Stancil Thomas E Jr
- [N1083C](https://openairdocs.org/deregistered/N1083C-2009-07-07.md): Mooney M20A · S/N 1354 · Cancelled Jul 7, 2009 · Registration revoked · Built 1959 · Stancil Thomas E Jr
- [N422CS](https://openairdocs.org/deregistered/N422CS-2001-01-09.md): Briggs Leslie GLASAIR III · S/N 3231 · Cancelled Jan 9, 2001 · Stephenson W Carroll Jr
- [N119MC](https://openairdocs.org/deregistered/N119MC-1999-06-04.md): Wsk-Pzl Meilec PZL M18B · S/N 1Z027-10 · Cancelled Jun 4, 1999 · Exported to Canada · Melex USA Inc
- [N60159](https://openairdocs.org/deregistered/N60159-1999-04-01.md): Wsk-Pzl Meilec PZL M18B · S/N 1Z027-30 · Cancelled Apr 1, 1999 · Exported to Canada · Melex USA Inc
- [N3235X](https://openairdocs.org/deregistered/N3235X-1998-09-18.md): Cessna 150G · S/N 15064635 · Cancelled Sep 18, 1998 · Capital Aircraft Leasing Inc
- [N44376](https://openairdocs.org/deregistered/N44376-1998-06-29.md): Wsk-Pzl Meilec PZL M18B · S/N 1Z02722 · Cancelled Jun 29, 1998 · Exported to Canada · Melex USA Inc
- [N9132X](https://openairdocs.org/deregistered/N9132X-1997-09-09.md): Wsk-Pzl Meilec PZL M18B · S/N 1Z02629 · Cancelled Sep 9, 1997 · Exported to New Zealand · Melex USA Inc
- [N62610](https://openairdocs.org/deregistered/N62610-1996-09-03.md): WSK PZL Mielec M-18A · S/N 1Z02609 · Cancelled Sep 3, 1996 · Exported to Australia · Melex USA Inc
- [N8021H](https://openairdocs.org/deregistered/N8021H-1996-07-10.md): WSK PZL Mielec M-18A · S/N 1Z02506 · Cancelled Jul 10, 1996 · Exported to Canada · Melex USA Inc
- [N38234](https://openairdocs.org/deregistered/N38234-1996-05-01.md): Beech A36 · S/N E1779 · Cancelled May 1, 1996 · Administratively canceled · American Dryco Company Inc
- [N81458](https://openairdocs.org/deregistered/N81458-1996-01-10.md): WSK PZL Mielec M-18A · S/N 1Z02526 · Cancelled Jan 10, 1996 · Exported to Spain · Melex USA Inc
- [N8211P](https://openairdocs.org/deregistered/N8211P-1996-01-03.md): WSK PZL Mielec M-18A · S/N 1Z02520 · Cancelled Jan 3, 1996 · Exported to Australia · Melex USA Inc
- [N9279M](https://openairdocs.org/deregistered/N9279M-1995-11-17.md): WSK PZL Mielec M-18A · S/N 1Z02524 · Cancelled Nov 17, 1995 · Exported to Australia · Melex USA Inc
- [N4256Y](https://openairdocs.org/deregistered/N4256Y-1984-10-01.md): Dabbs&Krianiak BENSEN B-8M · S/N 240-98-6537 · Cancelled Oct 1, 1984 · Built 1981 · Dabbs Amos R
- [N8360B](https://openairdocs.org/deregistered/N8360B-1984-03-27.md): Cessna 172 · S/N 36160 · Cancelled Mar 27, 1984 · Administratively canceled · Bryan John C

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

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