Beaver Falls, PA
Registered aircraft · 45
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 = 'PA' AND g.registrant_city = 'BEAVER 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 = 'PA' AND g.registrant_city = 'BEAVER 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.
N10365Piper L-21B · S/N 54-2533N14749Fairchild 24 C8C · S/N 2655N156ABeech 58TC · S/N TK-56N15MCBeech D-45 · S/N BG-295N191NDPiper PA-44-180 · S/N 4495003N201FPMooney M20J · S/N 24-0189N201YDMooney M20J · S/N 24-0510N214SFNorth American T-28B · S/N 138311N2152SCessna 172S · S/N 172S9444N22968Fairchild C-123K · S/N 54-664N230CKKurella Charles R PITTS S-2AE · S/N 001CKN262NDPiper PA-28-161 · S/N 2842061N282NDPiper PA-28R-201 · S/N 2844024N3378XMooney M20E · S/N 1093N37MTCessna 172S · S/N 172S8205N42110Piper J3C-65 · S/N 14337N422RMPiper PA-28-181 · S/N 2843526N42RJRJB Aviation Enterprises SKYBOLT · S/N A-1N44091Halas Paul S-14-RANS · S/N 0792025N44093Halas Paul TITAN II TORONADO · S/N D97503 50HK 0256N4416GMather Paul M SQUARE · S/N 00582N4491BCessna 170B · S/N 26835N507MAPiper PA32-301XTC · S/N 3255014N514CPiper PA-28-181 · S/N 2843684N5312MCessna 152 · S/N 15284526N5356YPiper PA-28-181 · S/N 2843528N567NDCessna 172S · S/N 172S10805N5998ECessna 150 · S/N 17498N7196QCessna 172L · S/N 17260496N7547MCessna 175 · S/N 55847N79902Cessna 172K · S/N 17258236N81102Mcclish FUNK B75L · S/N 232N8275DPiper PA-28-181 · S/N 2843096N836MDouglas C-47 · S/N 43-48716N863DZShort Bros C-23B SHERPA · S/N 93-1320N8765WCirrus Design SR20 · S/N 1826N9161KPiper PA 46-350P · S/N 4622022N9469VMooney M20E · S/N 700038N9682SChampion 7ECA · S/N 469N984BTCessna 172R · S/N 17280431N984WUCessna 172R · S/N 17280510N986AVCessna 172R · S/N 17280580N986BTCessna 172R · S/N 17280443N987AVCessna 172R · S/N 17280585N995WWCessna 172R · S/N 17280720
Back to Beaver Falls, PA