# Earlier aircraft under this name: Lapeer Airport Inc

A list on [Lapeer Airport Inc](https://openairdocs.org/faa-owner/LAPEER%20AIRPORT%20INC.md).

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

- [N36972](https://openairdocs.org/deregistered/N36972-1949-01-05.md): Aeronca 65-TAF · S/N 4212 · Cancelled Jan 5, 1949 · Lapeer, MI
- [N52305](https://openairdocs.org/deregistered/N52305-1948-11-18.md): Aeronca L-3C · S/N 6732 · Cancelled Nov 18, 1948 · Built 1945 · Lapeer, MI
- [N52452](https://openairdocs.org/deregistered/N52452-1948-11-18.md): Aeronca L-3 · S/N 058B1882 · Cancelled Nov 18, 1948 · Built 1945 · Lapeer, MI
- [N51405](https://openairdocs.org/deregistered/N51405-1948-11-15.md): Taylorcraft DCO-65 · S/N 5560 · Cancelled Nov 15, 1948 · Lapeer, MI
- [N51410](https://openairdocs.org/deregistered/N51410-1948-11-10.md): Taylorcraft BL-65 · S/N 3062 · Cancelled Nov 10, 1948 · Lapeer, MI
- [N29348](https://openairdocs.org/deregistered/N29348-1948-11-08.md): Waco UPF-7 · S/N 5375 · Cancelled Nov 8, 1948
- [N49651](https://openairdocs.org/deregistered/N49651-1948-11-04.md): Boeing PT-17 · S/N 75-2463 · Cancelled Nov 4, 1948 · Lapeer, MI
- [N47200](https://openairdocs.org/deregistered/N47200-1948-11-01.md): Taylorcraft L-2A · S/N L-5120 · Cancelled Nov 1, 1948
- [N47201](https://openairdocs.org/deregistered/N47201-1948-11-01.md): Taylorcraft L-2A · S/N 6-5156 · Cancelled Nov 1, 1948
- [N47429](https://openairdocs.org/deregistered/N47429-1948-11-01.md): Aeronca 0-58B · S/N 058B-2942 · Cancelled Nov 1, 1948
- [N47430](https://openairdocs.org/deregistered/N47430-1948-11-01.md): Aeronca 0-58B · S/N 058B-9363 · Cancelled Nov 1, 1948
- [N47281](https://openairdocs.org/deregistered/N47281-1948-10-26.md): Taylorcraft DCO-65 · S/N L-5087 · Cancelled Oct 26, 1948
- [N47338](https://openairdocs.org/deregistered/N47338-1948-10-26.md): Taylorcraft DCO-65 · S/N 5123 · Cancelled Oct 26, 1948
- [N26495](https://openairdocs.org/deregistered/N26495-1948-09-28.md): Berk Glen W A · S/N 3 · Cancelled Sep 28, 1948 · Lapeer, MI
- [N38844](https://openairdocs.org/deregistered/N38844-1948-09-16.md): Piper J3L-65 · S/N 7331 · Cancelled Sep 16, 1948 · Built 1941 · Lapeer, MI
- [N33794](https://openairdocs.org/deregistered/N33794-1948-08-20.md): Aeronca 65-TL · S/N 9531 · Cancelled Aug 20, 1948 · Lapeer, MI
- [N33834](https://openairdocs.org/deregistered/N33834-1948-08-20.md): Aeronca 65-TL · S/N 9681 · Cancelled Aug 20, 1948 · Lapeer, MI
- [N34612](https://openairdocs.org/deregistered/N34612-1948-08-17.md): Stinson 10A · S/N 8012 · Cancelled Aug 17, 1948 · Lapeer, MI
- [N47363](https://openairdocs.org/deregistered/N47363-1945-11-29.md): Taylorcraft DCO-65 · S/N 0-4235 · Cancelled Nov 29, 1945
- [N34300](https://openairdocs.org/deregistered/N34300-1945-11-19.md): Meyers OTW · S/N 44 · Cancelled Nov 19, 1945 · Lapeer, MI

## 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 = 'LAPEER AIRPORT INC' OR list_contains(d.other_registrant_names, 'LAPEER AIRPORT INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/LAPEER%20AIRPORT%20INC/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
