OpenAirDocs.org
Bellefonte, PA

Registered aircraft · 31

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

N103WHBurkhart Grob G103C TWIN III SL · S/N 35018Ps Soaring IncN200CLLaidlaw William R CHRISTEN EAGLE II · S/N LAIDLAW 0001Ps Soaring IncN2059MPiper J3C-65 · S/N 20835Built 1946 · Zimmerman John RN22894Piper J3F-50 · S/N 2802Elnitski Jeffrey JN232CAPiper PA-32-300 · S/N 32-7740026Built 1976 · Sawdust Aviation IncN275UHHelipeller XHA-04 · S/N X04F367001Helipeller Aviation LLCN275VHHelipeller XHA-03 · S/N X03H104001Helipeller Aviation LLCN275WHHelipeller XHA-01 · S/N X01H182001Helipeller Aviation LLCN275XHHelipeller XHA-02 · S/N X02F364001Helipeller Aviation LLCN3KGSchempp-Hirth NIMBUS-3DM · S/N 4Built 1988 · Ps Soaring IncN4230JPiper PA-28-140 · S/N 28-22579Built 1966 · Pleasant Valley Aviation IncN42452Piper J3C-65 · S/N 21004Ps Soaring IncN504JNSchweizer 269C-1 · S/N 0112Built 2000 · Polarblast LLCN5298TPiper PA-28-140 · S/N 28-7225396Built 1972 · Pleasant Valley Aviation IncN5311LPiper PA-28-180 · S/N 28-4614Built 1968 · Kitko Stephen DN5798ACessna 172 · S/N 28398Built 1956 · Bowman Ronald JN600ANJohn David Litke TALON A600 · S/N 8126Built 2015 · Polarblast LLCN619DGSchempp-Hirth STANDARD AUSTRIA SH1 · S/N 69Ps Soaring IncN6495HPiper J3C-65 · S/N 19678Built 1946 · Kitko Stephen DN84HRRolladen-Schneider LS 4A · S/N 4438Built 1984 · Banas Frank JrN8563WPiper PA-28-235 · S/N 28-10075Built 1963 · Roche DanielN865KGGrove Randy L RV-4 · S/N 2465Built 2021 · Grove Randy LN86894Cessna M337B · S/N 68-6894Williamson K RN87863Piper J3C-65 · S/N 15481First renewal noticeBuilt 1946 · Kilmer Randall WN8874CPiper PA-28-140 · S/N 28-7625135Built 1976 · Pleasant Valley Aviation IncN88986Schempp-Hirth STANDARD AUSTRIA SH1 · S/N 56Ps Soaring IncN9035XPoulson Randal J POULSON CLIPWING · S/N 2356Grove Randy LN9066EMaule M-5-235C · S/N 7076CFirst renewal noticeBuilt 1977 · Kilmer Randall WN9188YGrove Randy L CASSUTT III · S/N GR-2Built 2012 · Grove Randy LN99952Let BLANIK L-13 · S/N 025903Ps Soaring IncN99968Let BLANIK L-13 · S/N 026048Ps Soaring Inc
Back to Bellefonte, PA