# Earlier aircraft under this name: Farm Air Inc

A list on [Farm Air Inc](https://openairdocs.org/faa-owner/FARM%20AIR%20INC.md).

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

- [N7900R](https://openairdocs.org/deregistered/N7900R-2024-07-15.md): Air Tractor AT-502A · S/N 502A-3497 · Cancelled Jul 15, 2024 · Exported to Canada · Astoria, IL
- [N352FA](https://openairdocs.org/deregistered/N352FA-2023-09-01.md): Air Tractor AT-602 · S/N 602-1352 · Cancelled Sep 1, 2023 · Exported to Canada · Built 2023 · Astoria, IL
- [N4553W](https://openairdocs.org/deregistered/N4553W-2023-07-11.md): Air Tractor AT-402A · S/N 402A-0810 · Cancelled Jul 11, 2023 · Exported to Mexico · Built 1991 · Astoria, IL
- [N800FA](https://openairdocs.org/deregistered/N800FA-2021-12-17.md): Air Tractor AT-802A · S/N 802A-0806 · Cancelled Dec 17, 2021 · Exported to Canada · Built 2019 · Astoria, IL
- [N9146H](https://openairdocs.org/deregistered/N9146H-2020-05-22.md): Air Tractor AT-502B · S/N 502B-0633 · Cancelled May 22, 2020 · Exported to New Zealand · Built 2001 · Astoria, IL
- [N2151E](https://openairdocs.org/deregistered/N2151E-2020-02-19.md): Air Tractor AT-504 · S/N 504-4018 · Cancelled Feb 19, 2020 · Exported to Canada · Built 2012 · Astoria, IL
- [N731PV](https://openairdocs.org/deregistered/N731PV-2004-04-23.md): Cessna A188B · S/N 18803056T · Cancelled Apr 23, 2004 · Second triennial mailing, no response · Built 1977 · Prattville, AL
- [N4005J](https://openairdocs.org/deregistered/N4005J-1996-08-02.md): Cessna A188B · S/N 18803709T · Cancelled Aug 2, 1996 · Exported to Argentina · Fairfield, IL
- [N4549X](https://openairdocs.org/deregistered/N4549X-1992-08-25.md): Air Tractor AT-502 · S/N 5020127 · Cancelled Aug 25, 1992 · Exported to Guatemala · Fairfield, IL
- [N9318G](https://openairdocs.org/deregistered/N9318G-1991-11-21.md): Cessna A188B · S/N 18801452 · Cancelled Nov 21, 1991 · Triennial form not returned · Prattville, AL
- [N4545J](https://openairdocs.org/deregistered/N4545J-1982-10-26.md): Cessna T188C · S/N T18803748T · Cancelled Oct 26, 1982 · Built 1980 · Fairfield, IL
- [N4903Y](https://openairdocs.org/deregistered/N4903Y-1973-10-01.md): Piper PA-25-235 · S/N 25-4613 · Cancelled Oct 1, 1973
- [N56921](https://openairdocs.org/deregistered/N56921-1973-06-25.md): Boeing A75N1 · S/N 75-2138 · Cancelled Jun 25, 1973 · Sacramento, CA
- [N73650](https://openairdocs.org/deregistered/N73650-1971-02-04.md): Boeing A75N1(PT17) · S/N RC-75-10 · Cancelled Feb 4, 1971 · Sacramento, CA
- [N7230H](https://openairdocs.org/deregistered/N7230H-1961-07-17.md): Piper J3C-65 · S/N 20499 · Cancelled Jul 17, 1961 · Built 1946 · West Sacramento, CA
- [N2255N](https://openairdocs.org/deregistered/N2255N-1955-10-05.md): Cessna 140 · S/N 12491 · Cancelled Oct 5, 1955 · West Sacramento, 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 = 'FARM AIR INC' OR list_contains(d.other_registrant_names, 'FARM AIR INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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