# Earlier aircraft under this name: Pankratz Wallace B

A list on [Pankratz Wallace B](https://openairdocs.org/faa-owner/PANKRATZ%20WALLACE%20B.md).

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

- [N9454R](https://openairdocs.org/deregistered/N9454R-2015-04-27.md): Snow S2C · S/N 1082C · Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1961 · Caliparria, CA
- [N1789S](https://openairdocs.org/deregistered/N1789S-1977-07-21.md): Aero Commander 600 S-2D · S/N 600-1400D · Cancelled Jul 21, 1977 · Calipatria, CA
- [N1688S](https://openairdocs.org/deregistered/N1688S-1975-05-08.md): Snow S2C · S/N 6001269C · Cancelled May 8, 1975 · Calipatria, CA
- [N45044](https://openairdocs.org/deregistered/N45044-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2729 · Cancelled Jun 21, 1973 · Calipatria, CA
- [N45052](https://openairdocs.org/deregistered/N45052-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2844 · Cancelled Jun 21, 1973 · Calipatria, CA
- [N45088](https://openairdocs.org/deregistered/N45088-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2648 · Cancelled Jun 21, 1973 · Calipatria, CA
- [N45118](https://openairdocs.org/deregistered/N45118-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2758 · Cancelled Jun 21, 1973 · Calipatria, CA
- [N8079V](https://openairdocs.org/deregistered/N8079V-1972-05-10.md): Cessna A188 · S/N 188-0329 · Cancelled May 10, 1972 · Calipatria, CA
- [N9526C](https://openairdocs.org/deregistered/N9526C-1971-07-20.md): North American AT-6C · S/N 88-9129 · Cancelled Jul 20, 1971 · Brawley, CA
- [N9527C](https://openairdocs.org/deregistered/N9527C-1971-07-14.md): North American AT-6C · S/N 88-12401 · Cancelled Jul 14, 1971 · Brawley, CA
- [N9417R](https://openairdocs.org/deregistered/N9417R-1971-06-17.md): Snow S2B · S/N 1047 · Cancelled Jun 17, 1971 · Exported to United Kingdom · Calipatria, CA
- [N9461R](https://openairdocs.org/deregistered/N9461R-1971-05-24.md): Snow S2C · S/N 1084C · Cancelled May 24, 1971 · Brawley, CA
- [N8083V](https://openairdocs.org/deregistered/N8083V-1970-07-07.md): Cessna A188 · S/N 188-0333 · Cancelled Jul 7, 1970 · Calipatria, CA
- [N44861](https://openairdocs.org/deregistered/N44861-1968-06-14.md): Naval Aircraft Factory N3N-3 · S/N 1967 · Cancelled Jun 14, 1968 · Brawley, CA
- [N44823](https://openairdocs.org/deregistered/N44823-1963-10-29.md): Naval Aircraft Factory N3N-3 · S/N 4460 · Cancelled Oct 29, 1963 · Brawley, CA
- [N44734](https://openairdocs.org/deregistered/N44734-1962-12-18.md): Naval Aircraft Factory N3N-3 · S/N 2791 · Cancelled Dec 18, 1962 · Brawley, CA

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

This list as a web page: https://openairdocs.org/faa-owner/PANKRATZ%20WALLACE%20B/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.