# Cancelled registrations: Mansfield, OH

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

Cancelled aircraft registrations in Mansfield, OH.

Page 1 of 2 · 52 registrations

- [N10BM](https://openairdocs.org/deregistered/N10BM-2025-01-04.md): Sparks Burrell G SA6B FLUT-R-BUG · S/N P2107 · Cancelled Jan 4, 2025 · Sale reported, canceled · Built 1984
- [N8074F](https://openairdocs.org/deregistered/N8074F-2023-02-10.md): Cessna 150F · S/N 15064174 · Cancelled Feb 10, 2023 · Registration expired, pending cancellation · Built 1966 · Yoxtheimer David R
- [N242BA](https://openairdocs.org/deregistered/N242BA-2022-07-30.md): DJI Innovations PHANTOM 2 VISION + · S/N PH645502699 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Richland County Sheriffs Office
- [N180RM](https://openairdocs.org/deregistered/N180RM-2019-07-12.md): C G S Aviation/Mckenna HAWK ARROW II · S/N 296 · Cancelled Jul 12, 2019 · Registration expired, pending cancellation · Built 2007 · Barlow Steven J
- [N84291](https://openairdocs.org/deregistered/N84291-2018-04-06.md): Aeronca 7AC · S/N 7AC-2985 · Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Grace Burgess L
- [N5463C](https://openairdocs.org/deregistered/N5463C-2017-11-20.md): Cessna 170B · S/N 19497 · Cancelled Nov 20, 2017 · Revoked, canceled · Built 1950 · Sternbaums Complete Foodmarts
- [N3713Y](https://openairdocs.org/deregistered/N3713Y-2017-04-04.md): Beech 77 · S/N WA-182 · Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1980 · Arrowhead Of Michigan Inc DBA
- [N84BR](https://openairdocs.org/deregistered/N84BR-2015-05-21.md): Rickett R L REVOLUTION MINI 500 · S/N 427 · Cancelled May 21, 2015 · Registration expired, pending cancellation · Rickett Ralph L Sr
- [N6806T](https://openairdocs.org/deregistered/N6806T-2014-12-16.md): Cessna 310D · S/N 39106 · Cancelled Dec 16, 2014 · Registration pending, canceled · Built 1960
- [N6752B](https://openairdocs.org/deregistered/N6752B-2013-11-13.md): Piper PA-22-150 · S/N 22-4086 · Cancelled Nov 13, 2013 · Registration expired, pending cancellation · Rall Ronnie J
- [N51356](https://openairdocs.org/deregistered/N51356-2013-08-22.md): Cessna 150J · S/N 15069947 · Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1968
- [N13728](https://openairdocs.org/deregistered/N13728-2013-08-06.md): Anderson Marcus L SONERAI II · S/N 513 · Cancelled Aug 6, 2013 · Sale reported, canceled
- [N8443D](https://openairdocs.org/deregistered/N8443D-2013-05-14.md): Piper PA-22-160 · S/N 22-5698 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Sparks Burrell G
- [N5832C](https://openairdocs.org/deregistered/N5832C-2013-04-23.md): Beech C35 · S/N D-2784 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1951 · Lootens Charles W
- [N2865S](https://openairdocs.org/deregistered/N2865S-2013-02-21.md): Cessna 150G · S/N 15066765 · Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1967 · Reining Robert L
- [N4648B](https://openairdocs.org/deregistered/N4648B-2012-10-22.md): Cessna 152 · S/N 15283562 · Cancelled Oct 22, 2012 · Sale reported, pending cancellation · Built 1979
- [N39234](https://openairdocs.org/deregistered/N39234-2012-10-19.md): Pilkenton/Beer CGS HAWK · S/N H-4-115-C · Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1983 · Pilkenton Hugh
- [N2637Y](https://openairdocs.org/deregistered/N2637Y-2012-09-06.md): Cessna 340 · S/N 340-0013 · Cancelled Sep 6, 2012 · Registration pending, canceled
- [N2139S](https://openairdocs.org/deregistered/N2139S-2012-08-23.md): Cessna 210L · S/N 21061100 · Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1975 · Bank One Of Mansfield
- [N51294](https://openairdocs.org/deregistered/N51294-2012-08-13.md): Fairchild M-62A · S/N 2323AE · Cancelled Aug 13, 2012 · Revoked, canceled · Built 1943 · Owens Albert B
- [N9475X](https://openairdocs.org/deregistered/N9475X-2009-09-17.md): Cessna 210A · S/N 21057775 · Cancelled Sep 17, 2009 · Registration revoked · Built 1961 · Ullinskey George W
- [N120Q](https://openairdocs.org/deregistered/N120Q-2009-07-30.md): Cessna 550 · S/N 550-0332 · Cancelled Jul 30, 2009 · Exported to Canada · Built 1982 · Therm-O-Disc Inc
- [N3102H](https://openairdocs.org/deregistered/N3102H-2008-10-17.md): Ercoupe 415-E · S/N 3727 · Cancelled Oct 17, 2008 · Built 1946 · Lootens Charles W
- [N120FR](https://openairdocs.org/deregistered/N120FR-2005-06-29.md): Odonnell Francis W LANCAIR 235 · S/N 120 · Cancelled Jun 29, 2005 · Triennial form not returned · Williams Ted A
- [N9137A](https://openairdocs.org/deregistered/N9137A-2003-09-08.md): Smith Andrew SCORPION TOO · S/N 10460 · Cancelled Sep 8, 2003 · Triennial form not returned · Weeks John R
- [N7AV](https://openairdocs.org/deregistered/N7AV-2000-04-13.md): Avian Balloon FALCON II · S/N 16 · Cancelled Apr 13, 2000 · Triennial form not returned · Maul Dean E
- [N8277S](https://openairdocs.org/deregistered/N8277S-1993-10-06.md): Piper PA-28RT-201T · S/N 28R8131006 · Cancelled Oct 6, 1993 · Exported to Germany · Jones James A
- [N584A](https://openairdocs.org/deregistered/N584A-1976-05-25.md): Bensen Gyrocoper B-8M · S/N EW-1 · Cancelled May 25, 1976 · Wilson Elmer
- [N206MA](https://openairdocs.org/deregistered/N206MA-1976-05-06.md): Bell 206B · S/N 1750 · Cancelled May 6, 1976 · Exported to Canada · Mansfield Airways Inc
- [N339LC](https://openairdocs.org/deregistered/N339LC-1974-10-07.md): Beech 95-B55 (T42A) · S/N TC-1284 · Cancelled Oct 7, 1974 · Exported to Canada · Service Air Corp
- [N5951Q](https://openairdocs.org/deregistered/N5951Q-1973-06-25.md): Mooney M20C · S/N 3192 · Cancelled Jun 25, 1973 · Clarence Boterf
- [N31803](https://openairdocs.org/deregistered/N31803-1971-03-18.md): Aeronca 65-LB · S/N LB11200 · Cancelled Mar 18, 1971 · Built 1940 · Northrup Elbert W II
- [N1836H](https://openairdocs.org/deregistered/N1836H-1970-06-25.md): Cessna 310C · S/N 35936 · Cancelled Jun 25, 1970 · Built 1959 · Richland Aviation Inc
- [N1790C](https://openairdocs.org/deregistered/N1790C-1965-04-16.md): Cessna 180 · S/N 30490 · Cancelled Apr 16, 1965 · Rice Armour C
- [N7034E](https://openairdocs.org/deregistered/N7034E-1964-08-19.md): Cessna 175A · S/N 56534 · Cancelled Aug 19, 1964 · Private Flying Inc
- [N5564C](https://openairdocs.org/deregistered/N5564C-1960-01-06.md): Cessna 170A · S/N 19617 · Cancelled Jan 6, 1960 · Harsh R C
- [N3397V](https://openairdocs.org/deregistered/N3397V-1956-11-08.md): Beech 35 · S/N D872 · Cancelled Nov 8, 1956 · Built 1947 · Weaver Stuart M
- [N61036](https://openairdocs.org/deregistered/N61036-1956-02-15.md): Stinson L-5 · S/N 76-274 · Cancelled Feb 15, 1956 · Newdome William P
- [N46367](https://openairdocs.org/deregistered/N46367-1955-10-24.md): Fairchild M-62A · S/N 5253AE · Cancelled Oct 24, 1955 · Built 1945 · Sweet K B Murray G J Mabee R E
- [N2327B](https://openairdocs.org/deregistered/N2327B-1954-08-10.md): Temco GC-1B · S/N 3627 · Cancelled Aug 10, 1954 · Gorman James C III
- [N2646D](https://openairdocs.org/deregistered/N2646D-1953-06-03.md): Cessna 170B · S/N 20798 · Cancelled Jun 3, 1953 · Richland Aviation Inc
- [N6420K](https://openairdocs.org/deregistered/N6420K-1951-09-24.md): Republic RC-3 · S/N 665 · Cancelled Sep 24, 1951 · Exported to Canada · Richland Aviation Inc
- [N2316H](https://openairdocs.org/deregistered/N2316H-1951-09-07.md): Ercoupe 415-C · S/N 2941 · Cancelled Sep 7, 1951 · Built 1946 · Richland Aviation Inc
- [N90027](https://openairdocs.org/deregistered/N90027-1949-05-27.md): Cessna 140 · S/N 9085 · Cancelled May 27, 1949 · Spreng W J
- [N6327K](https://openairdocs.org/deregistered/N6327K-1947-12-30.md): Republic RC-3 · S/N 551 · Cancelled Dec 30, 1947 · Reed Myron S
- [N802H](https://openairdocs.org/deregistered/N802H-1947-10-07.md): Pitcairn PA-6 · S/N 42 · Cancelled Oct 7, 1947 · Bookwalter Charles Frederick
- [N25358](https://openairdocs.org/deregistered/N25358-1947-01-02.md): Luscombe 8A · S/N 1234 · Cancelled Jan 2, 1947 · Harrington Air Service
- [N14131](https://openairdocs.org/deregistered/N14131-1936-09-08.md): Waco YKC · S/N 3995 · Cancelled Sep 8, 1936 · Built 1934 · Harrington James R
- [N150V](https://openairdocs.org/deregistered/N150V-1935-03-16.md): Travel Air 10-D · S/N 10-2006 · Cancelled Mar 16, 1935 · Harrington James R
- [N3370](https://openairdocs.org/deregistered/N3370-1934-05-30.md): Lincoln LINCOLN PAGE 3 · S/N 137 · Cancelled May 30, 1934 · Built 1927 · Russell Harry E & Gimbel Paul

Next page: https://openairdocs.org/faa-place/OH/Mansfield/earlier.md?page=2

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

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