Cedar Falls, IA
Registered aircraft · 44
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 = 'CEDAR 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 = 'IA' AND g.registrant_city = 'CEDAR 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.
N112WBVans RV-12IS · S/N 120887N116JFEavision EA-J150 · S/N JMZKJ150UAV602595501N1222FCessna A185F · S/N 18502784N15203Piper PA-28-140 · S/N 28-7325012N156PGEmbraer Executive EMB-505 · S/N 50500488N166TAXag P100 PRO · S/N 82194253HR50N17173Cessna 177B · S/N 17702509N1811ZDJI AGRAS T40 · S/N 64TBL1V00200F3Registration pendingN2024HErcoupe 415-C · S/N 2647N225MAPiper PA46-500TP · S/N 4697106N2360ACessna 206H · S/N 20608016Registration pendingN2434YCessna 206H · S/N 20608078Registration pendingN315RDBell 206B · S/N 2852N3568ZPiper PA-22-150 · S/N 22-7484N3930RPiper PA-28-180 · S/N 28-5848N39609Piper PA-28-181 · S/N 28-7890542N39BCPiper PA-28-235 · S/N 28-7410013N40700Piper J5A · S/N 5-1132N4152DPiper PA 46-350P · S/N 46-36304N4197NRaven S-60A · S/N S60A-216N4224ZEa Vision EA J100 · S/N 85413N429QZEa Vision EA J100 · S/N 85425N47589Piper PA-28R-201T · S/N 28R-7703404N4951FCessna TU206A · S/N U206-0651N52STCessna 340A · S/N 340A0696N5310AEa Vision J-150 · S/N JMZKJ150UAV602595187N5711HMooney M20J · S/N 24-1426N61RWCessna 320E · S/N 320E0001N6410NCessna T210N · S/N 21062986N6513PAerostar International S-60A · S/N S60A-3060N701TTTolhurst William ZENITH CH 701 · S/N 7-9139N710DEXag P100 PRO · S/N 1863FPEG82194258F7T0Registration pendingN712WMWyatt J Girton RV7A · S/N 71292N72RKCessna T206H · S/N T20608315N734XPCessna 172N · S/N 17269199N775EWCirrus Design SR22 · S/N 0526N78ASCessna T206H · S/N T20608078N8381CPiper PA-28-181 · S/N 28-7690128N858SRPiper PA-32R-301T · S/N 32R-8329037N939LTRush Larry T RV-6A · S/N 24509N9489VMooney M20F · S/N 700048N95TTBeech B200 · S/N BB-917N98297Piper PA-28-140 · S/N 28-26254N99052Ercoupe 415-C · S/N 1675
Back to Cedar Falls, IA