OpenAirDocs.org
Maurice, IA

Registered aircraft · 36

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

N10FZCessna 425 · S/N 425-0117Built 1981 · Airflair IncN2256LAyres S2R-T34 · S/N T34-232Built 1997 · Crop Dusters LLCN22815Ayres S2R-T34 · S/N T34-239Crop Dusters LLCN23034Ayres S2R-T34 · S/N T34-259Built 1999 · Crop Dusters LLCN2769KCessna 180K · S/N 18053064Millennium Air IncN3104YAyres S2R-T34 · S/N T34-156Built 1991 · Crop Dusters LLCN40145Ayres S2R-T34 · S/N T34-261Built 1999 · Crop Dusters LLCN406RBPiper PA-32R-300 · S/N 32R-7880009Built 1977 · Airflair IncN416BKBeech C90 · S/N LJ-816Built 1978 · Optic Air LLCN425DDCessna 425 · S/N 425-0083Built 1981 · Air Flair IncN433BSDJI AGRAS T40 · S/N 1581F574B239B0010076R & M Spraying Service LtdN433CRDJI AGRAS T40 · S/N 1581F574B2363001013FR & M Spraying Service LtdN438LTEa Vision EA J100 · S/N 85740Crop Dusters LLCN4922HCessna 182R · S/N 18267853Built 1981 · Optic Air LLCN502BCCessna 560XL · S/N 560-5098Built 2000 · Onarco2 LLCN5080YCessna 182R · S/N 18267875Built 1981 · Optic Air LLCN524SLAyres S2R-T34 · S/N T34203DCBuilt 1994 · Crop Dusters LLCN5298HThrush S2R-T34 · S/N T34-312Built 2009 · Crop Dusters LLCN5308SThrush S2R-T34 · S/N T34-326DCBuilt 2010 · Crop Dusters LLCN534PWThrush S2R-510 · S/N 510-102Built 2021 · Crop Dusters LLCN602RMDJI AGRAS T50 · S/N 1581F6BUB232N00102TWR & M Spraying Service LtdN603DWCessna 550 · S/N 550-1109Built 2005 · Onarco2 LLCN603RMDJI AGRAS T50 · S/N 1581F6BUB24920011FXPR & M Spraying Service LtdN6123QPiper PA-28-181 · S/N 28-7790065Built 1976 · Airflair IncN6135UAyres S2R-T34 · S/N T34-215Built 1996 · Crop Dusters LLCN6900GNorth American T-6G · S/N 168-498Built 1959 · Van Skike Gary AN74RFCessna 425 · S/N 425-0153Built 1983 · Air Flair IncN7507DT Jay Larsen KITFOX 1 · S/N 11Built 2018 · Larsen T JayN759JXCessna 182Q · S/N 18266041Built 1977 · Optic Air LLCN78TDCirrus Design SR20 · S/N 2345Built 2017 · Airflair IncN800WECessna 182Q · S/N 18267408Built 1979 · Optic Air LLCN8440MPiper PA-28-161 · S/N 28-8216002Built 1981 · Airflair IncN873GREa Vision EA J100 · S/N 85601Crop Dusters LLCN888GTCessna 182Q · S/N 18266861Built 1979 · Optic Air LLCN9234RCessna A188B · S/N 18802173TRegistration pendingBuilt 1975N950SAPiper PA-31T2 · S/N 31T-8166028Built 1981 · Crop Dusters LLC
Back to Maurice, IA