# Registered aircraft: Greenfield, IA

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

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

- [N10721](https://openairdocs.org/aircraft/N10721.md): Sioux COUPE 90-B · S/N 401 · Built 1933 · Antique Preservation Association Of Greenfield
- [N1138T](https://openairdocs.org/aircraft/N1138T.md): DJI AGRAS T40 · S/N 64TBKBL002002Q · Sickles Trucking LLC
- [N118ST](https://openairdocs.org/aircraft/N118ST.md): DJI AGRAS T50 · S/N 1581F6BUB243U001T6TG · Sickles Brandon
- [N170RM](https://openairdocs.org/aircraft/N170RM.md): Milburn Richard L NIEUPORT 17 · S/N 30 · Built 1998 · Antique Preservation Association Of Greenfield
- [N17247](https://openairdocs.org/aircraft/N17247.md): Piper J-2 · S/N 913 · Built 1937 · Antique Preservation Assn Greenfield
- [N20P](https://openairdocs.org/aircraft/N20P.md): Pitts Special S1C · S/N 101M · Built 1968 · Antique Preservation Association Of Greenfield
- [N2708A](https://openairdocs.org/aircraft/N2708A.md): Schweizer SGU-1-20 · S/N 30A · Built 1956 · Antique Preservation Assoc Greenfld
- [N278YQ](https://openairdocs.org/aircraft/N278YQ.md): DJI AGRAS T20P · S/N 1581F574B2391001006W · Sickles Brandon
- [N34912](https://openairdocs.org/aircraft/N34912.md): Aetna AEROCRAFT 2SA · S/N 4 · Built 1941 · Antique Preservation Association Of Greenfield
- [N35180](https://openairdocs.org/aircraft/N35180.md): Piper J5A · S/N 5-567 · Built 1941 · Schildberg Matthew J
- [N3758U](https://openairdocs.org/aircraft/N3758U.md): Dehavilland-Schildberg DH 82A · S/N 1269 · Built 1941 · Antique Preservation Assn Greenfield
- [N4221D](https://openairdocs.org/aircraft/N4221D.md): Breshears Donald L DYKE DELTA JD-2 · S/N 1269 · Built 1995 · Antique Preservation Associaiton Of Greenfield
- [N447CB](https://openairdocs.org/aircraft/N447CB.md): Bock Charles C JR EUROPA CLASSIC · S/N 1 · Built 2000 · Antique Preservation Assoc Of Greenfield Ia Avn Mu
- [N4507L](https://openairdocs.org/aircraft/N4507L.md): Evangel Air 4500-300 · S/N 006 · Built 1973 · Antique Preservation Associationof Greenfield
- [N547YM](https://openairdocs.org/aircraft/N547YM.md): Talos Drones T60X · S/N 2104F7EZW258E001K2Z5 · Caviness Merritt
- [N580YA](https://openairdocs.org/aircraft/N580YA.md): Talos Drones T60X · S/N 2104F7EZW25B7001788Y · Caviness Merritt
- [N7145](https://openairdocs.org/aircraft/N7145.md): Curtiss Wright ROBIN · S/N 6 · Built 1928 · Antique Pres Assoc Of Greenfield Ia
- [N8828](https://openairdocs.org/aircraft/N8828.md): Stearman C3-R · S/N 5001 · Built 1929 · Antique Preservation Association Of Greenfield
- [N8966](https://openairdocs.org/aircraft/N8966.md): Dehavilland TIGER MOTH DH-82C · S/N 1767 · Built 1942 · Antique Preservation Assn Greenfield
- [N914PP](https://openairdocs.org/aircraft/N914PP.md): DJI AGRAS T40 · S/N 1581F574B221C001002F · Sickles Brandon
- [N95734](https://openairdocs.org/aircraft/N95734.md): Taylorcraft BC12-D · S/N 8034 · Built 1946 · Antique Preservation Association Of Greenfield
- [N98733](https://openairdocs.org/aircraft/N98733.md): Piper J3C-65 · S/N 18963 · Built 1946 · Antique Preservation Assn Greenfield

## 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 = 'GREENFIELD'
ORDER BY g.n_number
```

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