OpenAirDocs.org
Pella, IA

Registered aircraft · 40

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N16226Waco UKS-6 · S/N 4454Built 1936 · Classic Aviation IncN1951GCirrus Design SR22 · S/N 0630Built 2003 · Classic Aviation IncN20081National Ballooning 858 · S/N 139Built 2001 · Hartson Jason RN21854Galaxy Balloons GALAXY 9B · S/N GLX-1099BBuilt 2005 · Steenhoek JessicaN257ACAmerican Champion 7GCBC · S/N 1257-99Built 1999 · Classic Aviation IncN2591BPiper PA 46-350P · S/N 4636583Built 2013 · Devries Larry EN26460Meyers OTW-145 · S/N 13Built 1940 · Www Enterprises LLCN26LMBeech 76 · S/N ME-177Built 1979 · Classic Aviation IncN2724JCessna A185E · S/N 185-1474Horseshoe Air LLCN2866MXag P100 PRO · S/N 821932356K3PTwin River Trucking LLCN3114NCessna 120 · S/N 13372Built 1947 · Classic Aviation IncN321PXRick Gritters/Tom Vanderlinden POBER PIXIE · S/N 321Built 2014 · Gritters RickN32TABeech 36 · S/N E-120Built 1968 · Van Wyk Kenneth WN338VHRobinson Helicopter R22 BETA · S/N 2300Built 1993 · Devries Larry EN3463KPiper J3C-65 · S/N 22156Built 1946 · Barnes Fixed Wing LLCN36603Piper PA-28-161 · S/N 28-7816673Built 1978 · J&J Holdings Of Pella LLCN38190Piper PA-28-140 · S/N 28-7725260Built 1977 · Classic Aviation IncN405MWCessna 172D · S/N 17250433Built 1963 · Warin Michael RN441LHHutchinson Matthew S S-21 OUTBOUND · S/N 11190076Built 2021 · Hutchinson Matthew S TrusteeN48VCEmbraer Executive EMB-500 · S/N 50000291Built 2012 · Vermeer Manufacturing Co DBAN48VMEmbraer Executive EMB-505 · S/N 50500292Built 2015 · Vermeer Manufacturing CoN547TXDJI AGRAS T40 · S/N 1581F574B235400100QM5a Flying Ag LLCN5667CCessna 140A · S/N 15623Built 1950 · Classic Aviation IncN57890DJI AGRAS T50 · S/N 63YBMAA002008FBlack Oak Ag Services LLCN61GTCirrus Design SR22 · S/N 3824Fogle DennisN6552VBeech V35A · S/N D-8623Built 1967 · Satellite Airways LtdN696RKKramer Ronald C RV-6 · S/N 20193Built 1992 · Classic Aviation IncN71GVCirrus Design SR22 · S/N 10081Vermeer Manufacturing CoN7213MBeech A36 · S/N E-2206Built 1984 · Tulip City Air LLCN722ATRobinson Helicopter R44 II · S/N 14070Built 2017 · Devries Electric IncN7271FNational Ballooning 858 · S/N 118Hartson Jason RN7272ACessna 172 · S/N 29372Built 1956 · Open Air Ltd Co DBAN733NKCessna 172N · S/N 17268418Built 1977 · Classic Aviation IncN761GNCessna 210M · S/N 21062247Built 1977 · 21 - 55 Aviation LLCN8074KStinson 108-2 · S/N 108-3074Built 1947 · Classic Aviation IncN82940Aeronca 7AC · S/N 7AC-1590Built 1946 · Classic Aviation IncN8441ZCessna 210-5(205) · S/N 205-0441Built 1963 · Wingman Aviation LLCN853DBCirrus Design SR20 · S/N 1620Built 2006 · Classic Aviation IncN9006YNational Ballooning 752-12 · S/N 0123Built 1981 · Hartson JasonN9350MMooney M20E · S/N 1282Built 1966 · Pella Technology Services Inc
Back to Pella, IA