OpenAirDocs.org
Milford, IA

Registered aircraft · 25

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 = 'MILFORD'
  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.

N126HBeech V35 · S/N D-8544Built 1967 · Bockman LtdN135JABeech V35 · S/N D-8478Built 1967 · D & K Aviation IncN2775GDJI AGRAS T40 · S/N 1581F574B235400100DHFrischmeyer DavidN278DPDJI AGRAS T40 · S/N 1581F574B2354001009RFrischmeyer DavidN295NKXag P100 PRO · S/N 1863FPEG8219329SQ057Kremmin Sky Farm LLCN3002Xag P100 PRO · S/N 8219323179HXBockman Brothers LLCN3005Xag P100 PRO · S/N 8219329Q9J15Bockman Brothers LLCN3166LDJI AGRAS T40 · S/N 1581F574B2387001009KPrentice Customs LLCN3169CDJI AGRAS T40 · S/N 1581F574B238700100A4Prentice Customs LLCN36BHBeech A36 · S/N E-1056Built 1977 · Hobo LLCN38612Piper J3L-65 · S/N 7144Wilken Christopher WN3PEBeech 58 · S/N TH-820Built 1977 · Jabr Aviation LLCN4018YAyres S2R-T11 · S/N T11-003Built 1980 · Van Kleek Steve DN408RGRobinson Helicopter R44 II · S/N 14183Built 2018 · Gould RodN485HBTalos Drones T60X · S/N 2104F7EXB251J001M167Bockman Brothers LLCN4988YPiper PA-25-260 · S/N 25-4797Built 1968 · Van Kleek Steve DN5037KBellanca 7GCBC · S/N 1087-79Built 1979 · D & K Aviation IncN5434BTalos Drones T60X · S/N 2104F7EZW25670014CWMBockman Brothers LLCN5553TCessna 172E · S/N 17251453Built 1964 · Van Kleek Steve DN5755ECessna 150 · S/N 17255Built 1959 · Wilken Christopher WN731CQCessna A188B · S/N 18802794TBuilt 1977 · D & K Aviation IncN785NADJI AGRAS T100 · S/N 1581F8ZLC25AC00200S5Bockman Brothers LLCN8192CPiper PA-18-150 · S/N 18-4108Built 1954 · D&K Aviation IncN9230MMooney M20E · S/N 1187Built 1966 · Pernick KevinN96923Cessna 182Q · S/N 18266896Built 1979 · Green David C
Back to Milford, IA