OpenAirDocs.org
State College, 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 = 'STATE COLLEGE'
  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.

N123YWRobinson Helicopter R44 II · S/N 10606Built 2005 · Maxwell Truck And Equipment LLCN225CZArnold James A COZY MK IV · S/N MK-0225Taylor Stephen MarklewN24018Beech C23 · S/N M-1926Built 1977 · Schulte David LN2570UPiper PA-28-161 · S/N 28-8016036Built 1979 · Jla Aero LLCN2848HSchweizer SGS 2-33A · S/N 538Built 1978 · Groshel Joseph CN28TRSchleicher ASW-19B · S/N 19419Houseknecht Thomas JN3073UPiper PA-28-161 · S/N 28-7916320Built 1979 · Jla Aero LLCN330CLBeech 35-B33 · S/N CD-488Non-citizen corporation, flight hours not reportedCoalos IncN33PRPiper PA-32R-300 · S/N 32R-7780087Built 1976 · Wings To Carolina LLCN36336Bellanca 7ECA · S/N 965-73Built 1973 · Mierzejewski KarlN3731GCessna T310R · S/N 310R0906Built 1977 · Maxwell Truck & Equipment LLCN38997Piper PA-32R-300 · S/N 32R-7780496Built 1977 · Blg Air IncN39265Burkhart Grob Flugzeugbau G109 · S/N 6158Built 1983 · Central Pa Soaring LLCN51178Cessna 172P · S/N 17274274Built 1980 · Tussey Mountain Flying Club LLCN52GHBell 206L-3 · S/N 51276Built 1989 · Pleasant Gap Land Co IncN542CJTextron 525B · S/N 525B0542Built 2018 · Hnp Air LLCN54DACessna 525 · S/N 525-0470Built 2001 · Thoroughbred II LLCN5548CSocata TB 10 · S/N 1247Bme&G Enterprises LLCN57AHAviat A-1C-180 · S/N 3307Built 2018 · Seven Mountain Flyers LLCN59WVCirrus Design SR22T · S/N 0516Built 2013 · Sanders GrahamN6098JCessna A150L · S/N A150-0397Built 1973 · Hall David KN7042SCessna 150H · S/N 15067742Built 1967 · Nuernberger Howard PN7240PSchleicher ASW-15 · S/N 15022Built 1969 · Houseknecht Thomas JN7655Schweizer SGS 1-34 · S/N 35Built 1970 · Groshel Joseph CN8115PPiper PA-28-161 · S/N 28-8016120Built 1979 · Jla Aero LLCN812NCPilatus PC-12/47E · S/N 1545Built 2015 · Quest Aviation LLCN8218SPiper PA-34-220T · S/N 34-8233165Built 1982 · Thoroughbred Aviation LtdN834ZCessna 180 · S/N 32038Built 1955 · Groshel Joseph CN8382JCessna 150G · S/N 15066282Built 1967 · Houseknecht ThomasN9283EAeronca 11AC · S/N 11AC-920Built 1946 · Erickson James RN988JFPiper PA-28-181 · S/N 2843287Built 1999 · Mcdaniel Patrick D
Back to State College, PA