OpenAirDocs.org
Greenfield, IA

Registered aircraft · 22

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N10721Sioux COUPE 90-B · S/N 401Built 1933 · Antique Preservation Association Of GreenfieldN1138TDJI AGRAS T40 · S/N 64TBKBL002002QSickles Trucking LLCN118STDJI AGRAS T50 · S/N 1581F6BUB243U001T6TGSickles BrandonN170RMMilburn Richard L NIEUPORT 17 · S/N 30Built 1998 · Antique Preservation Association Of GreenfieldN17247Piper J-2 · S/N 913Built 1937 · Antique Preservation Assn GreenfieldN20PPitts Special S1C · S/N 101MBuilt 1968 · Antique Preservation Association Of GreenfieldN2708ASchweizer SGU-1-20 · S/N 30ABuilt 1956 · Antique Preservation Assoc GreenfldN278YQDJI AGRAS T20P · S/N 1581F574B2391001006WSickles BrandonN34912Aetna AEROCRAFT 2SA · S/N 4Built 1941 · Antique Preservation Association Of GreenfieldN35180Piper J5A · S/N 5-567Built 1941 · Schildberg Matthew JN3758UDehavilland-Schildberg DH 82A · S/N 1269Built 1941 · Antique Preservation Assn GreenfieldN4221DBreshears Donald L DYKE DELTA JD-2 · S/N 1269Built 1995 · Antique Preservation Associaiton Of GreenfieldN447CBBock Charles C JR EUROPA CLASSIC · S/N 1Built 2000 · Antique Preservation Assoc Of Greenfield Ia Avn MuN4507LEvangel Air 4500-300 · S/N 006Built 1973 · Antique Preservation Associationof GreenfieldN547YMTalos Drones T60X · S/N 2104F7EZW258E001K2Z5Caviness MerrittN580YATalos Drones T60X · S/N 2104F7EZW25B7001788YCaviness MerrittN7145Curtiss Wright ROBIN · S/N 6Built 1928 · Antique Pres Assoc Of Greenfield IaN8828Stearman C3-R · S/N 5001Built 1929 · Antique Preservation Association Of GreenfieldN8966Dehavilland TIGER MOTH DH-82C · S/N 1767Built 1942 · Antique Preservation Assn GreenfieldN914PPDJI AGRAS T40 · S/N 1581F574B221C001002FSickles BrandonN95734Taylorcraft BC12-D · S/N 8034Built 1946 · Antique Preservation Association Of GreenfieldN98733Piper J3C-65 · S/N 18963Built 1946 · Antique Preservation Assn Greenfield
Back to Greenfield, IA