Westfield, IN
Registered aircraft · 47
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 = 'IN' AND g.registrant_city = 'WESTFIELD' 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.
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 = 'IN' AND g.registrant_city = 'WESTFIELD' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N101WKWillke Ronald S RANS S-20 RAVEN · S/N 07150047N118JSKubicek Factory S R O BB34Z · S/N 1989N121MLMichael E King RANS S-21 OUTBOUND · S/N 08250436N14TEElmore Travis C KITFOX IV · S/N 1534N1506NPiper J3C-65 · S/N 23036Registration pendingN1717Beausoleil Barry R ACRO SPORT-1 · S/N 5431521N2147HEngineering & Research ERCOUPE 415-C · S/N 2770N217MMDJI PHANTOM 3 PROFESSION · S/N P76DCE18011375N21WCBrowne-Curd EAA ACROSPORT · S/N 76N221PZipperer Richard P RV-6 · S/N 60049N22523Cessna 150H · S/N 15068334N2383ZDJI AVATA · S/N 1581F4QWD22760023G48N24FFAviat PITTS S-2B · S/N 5265N262KGKubicek Factory S R O BB26Z · S/N 2598N2688EAeronca 7AC · S/N 7AC-6268N26VZDennis Smith M26 VICTOR · S/N 26266306N298LSArbc Inc DBA Lindstrand 77X · S/N 5600N3071LCessna 310J · S/N 310J0071N315LLStrategie Baloes E Inflaveis L AMAZON C 30 · S/N AB-SS-01N319HSAir Fly Balonismo E Inflaveis AF-SS-93 · S/N LP2025-02N320XPLarry Joseph Boggs SUPER RV-8 · S/N 82249N335TBBeech F33A · S/N CE1166N4404CBuckeye DREAM MACHINE · S/N 6939N4531BGulfstream American AA-5B · S/N AA5B1159N471KJohnson Kenneth W HATZ CB-1 · S/N 471AN47TDLewis Tim RV-6A · S/N 60023N500JMPiper PA46-500TP · S/N 4697118N516GZDenis Charbonneau GLASTAR · S/N 5639N51JFFerraro STARDUSTER TOO SA300 · S/N 858N525KTCessna 525C · S/N 525C0059N52693Convair BT-13A · S/N 5674N533TPPrecision Drone PACESETTER · S/N DA000011N587ATCirrus Design SR22 · S/N 3459N6957QBeech A23-24 · S/N MA-305N70351Piper J3C-65 · S/N 17335N7143JAerostar International XP-DRAGON · S/N XP-DRAGON-3001N714CECessna 150M · S/N 15079398N771MLKing Michael E VANS RV8 · S/N 90952N797MPAmerican AA-1 · S/N AA1-0211N81741Piper PA-28-181 · S/N 28-8090134N8386GCessna 150F · S/N 15062486N905LSLibra Baloes E Inflaveis Ltda AX-7 · S/N 013N918BVCessna 421C · S/N 421C1247N927HABalony Kubicek Spol Sro BB26XR · S/N 1903N928KFMeyer Scott KITFOX S7 SUPERSPORT · S/N KA19019393N961MMLearjet 45 · S/N 356N9957UGrumman American Avn. AA-5A · S/N AA5A0357
Back to Westfield, IN