# Registered aircraft: Fairfield, IA

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N108CR](https://openairdocs.org/aircraft/N108CR.md): Socata TBM 700 · S/N 347 · Built 2006 · Cambridge Investment Group Inc
- [N2692Z](https://openairdocs.org/aircraft/N2692Z.md): DJI AGRAS T40 · S/N 1581F574B238F001001C · Perlee Ag Services LLC
- [N2693A](https://openairdocs.org/aircraft/N2693A.md): DJI AGRAS T40 · S/N 1581F574B239100100R9 · Perlee Ag Services LLC
- [N2694Z](https://openairdocs.org/aircraft/N2694Z.md): DJI AGRAS T40 · S/N 1581F574B238A00102SA · Perlee Ag Services LLC
- [N269XP](https://openairdocs.org/aircraft/N269XP.md): DJI AGRAS T40 · S/N 1581F574B235B00102ZK · Perlee Ag Services LLC
- [N269YZ](https://openairdocs.org/aircraft/N269YZ.md): DJI AGRAS T40 · S/N 1581F574B238000101GN · Perlee Ag Services LLC
- [N32500](https://openairdocs.org/aircraft/N32500.md): Piper PA-28-140 · S/N 28-7525076 · Fairfield Flying Service Inc
- [N399C](https://openairdocs.org/aircraft/N399C.md): Universal Stinson 108-2 · S/N 108-3399 · Built 1947 · Miller Eric M
- [N468NP](https://openairdocs.org/aircraft/N468NP.md): DJI AGRAS T25 · S/N 1581F6BUB234B00100Q3 · Perlee Ag Services LLC
- [N5175F](https://openairdocs.org/aircraft/N5175F.md): Cirrus Design SR22 · S/N 0818 · Built 2004 · Broomstick Aviation LLC
- [N5944G](https://openairdocs.org/aircraft/N5944G.md): Cessna 150H · S/N 15068028 · Built 1967 · Yakich Adam J
- [N625BP](https://openairdocs.org/aircraft/N625BP.md): Lindstrand Technologies LTL RACER 56 · S/N 063 · Built 2017 · Picard Benjamin C
- [N66329](https://openairdocs.org/aircraft/N66329.md): Aeronca 7BCM · S/N 7BCM-176 · Nelco Farms Inc
- [N6859A](https://openairdocs.org/aircraft/N6859A.md): Cessna 172 · S/N 28959 · Clark Brenton J
- [N8031A](https://openairdocs.org/aircraft/N8031A.md): Cessna 170B · S/N 20883 · Built 1952 · Jims Aviation LLC
- [N8089C](https://openairdocs.org/aircraft/N8089C.md): Piper PA-28-181 · S/N 28-7690102 · Nelco Farms Inc
- [N853DC](https://openairdocs.org/aircraft/N853DC.md): DJI AGRAS T20P · S/N 1581F574B239K001006F · Stone Ag Drones LLC
- [N8617P](https://openairdocs.org/aircraft/N8617P.md): Piper PA-24-260 · S/N 24-4067 · Built 1964 · Frisbie Kevin R
- [N9003T](https://openairdocs.org/aircraft/N9003T.md): Mitchell Bill CHALLENGER II · S/N CH2-1198-1796 · Built 2000 · Johnston Jeremy I
- [N922B](https://openairdocs.org/aircraft/N922B.md): Beech 95-B55 (T42A) · S/N TC-994 · Built 1966 · Vander Linden Tom
- [N9748E](https://openairdocs.org/aircraft/N9748E.md): Bellanca 17-30A · S/N 76-30835 · Built 1976 · Anderson Aviation LLC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'IA' AND g.registrant_city = 'FAIRFIELD'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/IA/Fairfield/aircraft

---
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.