Granite Falls, MN
Registered aircraft · 43
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 = 'MN' AND g.registrant_city = 'GRANITE FALLS' 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 = 'MN' AND g.registrant_city = 'GRANITE FALLS' 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.
N1386MCessna 182P · S/N 18260826N1426JRockwell International 112A · S/N 426N209TWGoodyear FG1D · S/N 92489N2470Stinson L-5B · S/N 44-17184N251LNorth American P-51D · S/N 44-63864N266FCompagnie Daher TBM 700 · S/N 1270N300LExtra Flugzeugbau EA 300/L · S/N 108N3220JBeech A36 · S/N E-2920N325NNorth American B-25N · S/N 10847452N345BNNorth American P-51D-25-NT · S/N 4412864N402WHCurtiss Wright P-40K-10 · S/N 42-10083N41EKPiper PA-32RT-300 · S/N 32R-7885096N45086Cessna 177RG · S/N 177RG1092N46197Fairchild M-62A · S/N T43-7272N473VPRocca John C VPII · S/N 001N48HDCurtiss Wright SB2C5 · S/N 4401N4960VBoeing B-17G · S/N 43-38978N51WPRaytheon A36 · S/N E-3508N54841Consolidated Vultee BT-13A · S/N 5225N553TTMitsubishi A6M3ZERO · S/N 3858N566FCessna 560XL · S/N 560-5606N566FFCompagnie Daher TBM 700 · S/N 1413N57184Ryan Aeronautical ST3KR · S/N 1306N58GMMalone Franklin GLASAIR-MALONE · S/N 153N5900VPiper PA-28-181 · S/N 28-7790510N63502Boeing A75N1 · S/N 75-2419N65VCGrumman TBM-3 · S/N 85715N68JRNorth American/Aero Classics P-51D · S/N 44-72051N68KAAeronca 7GC · S/N 7GC-21N704QZGrumman TBM-3 · S/N 85597N714AWNorth American SNJ-4 · S/N 27234N7205ACurtiss Wright P-40E · S/N AK823/1036N731WFCirrus Design SR22 · S/N 4421N7470JPiper PA-28R-180 · S/N 28R-30823N75463Fairchild M-62A-4 · S/N T42-4299First renewal noticeN767WJRepublic P-47D · S/N 4432817N774FMGrumman FM-2 · S/N 86774N79123Lockheed P-38L-5 · S/N 422-8235N83431Aeronca 7AC · S/N 7AC-2098N9207LAmerican AA-1A · S/N AA1A-0107N9265AGrumman A/C ENG Corp-Nichols F6F-5 · S/N 78645N926AREley Robert B SONEX · S/N 0388N93RWDouglas A-24B · S/N 42-54682
Back to Granite Falls, MN