OpenAirDocs.org
Hummelstown, PA

Registered aircraft · 29

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

N100REBeech F33A · S/N CE-987Built 1981 · Schooler Jordan BenjaminN10FKKosik Frank STEEN SKYBOLT #1 · S/N KOSIK-1Built 1985 · Weller Steven CN10PHCessna 560XL · S/N 560-6142Built 2013 · Blue Sky Harbour LLCN1331PDJI PHANTOM 3 PROFESSION · S/N P76DCI10010621Searer Scott AN139WTMooney M20M · S/N 27-0283Built 2000 · Cotton Business Enterprises LLCN1506MCessna 182P · S/N 18264356Built 1975 · Bonn StevenN151SWHooper William HOOPER GN-1 · S/N 001Built 2000 · Sager Kenneth AN224FRCirrus Design SR22 · S/N 2953Built 2008 · Victor 93 LLCN226JHCirrus Design SR22 · S/N 3443Built 2009 · Ameritech Flight Services LLCN27154Piper J3L-65 · S/N 4399Built 1940 · Heekin Michael PN28554Luscombe 8A · S/N 1383Built 1940 · Ruth-Ann Baughman BellN2968XCessna 177 · S/N 17700368Built 1967 · Jansen Edward MN3178DCessna 180 · S/N 31976Built 1955 · Sager Kenneth AN348GSSlatt Gary E SLING 2 · S/N 75Built 2019 · Slatt Gary EN39JDLaister Sailplane Products LP-49 · S/N 20Built 1972 · Weller Steven CN43255Taylorcraft BC12-D · S/N 6914Built 1946 · Bell Brian TN4446TBurkhart Grob G 103 TWIN II · S/N 3824Built 1983 · Weller Steven CN483DMCessna T210L · S/N 21060819Built 1975 · N483dm LLCN49251Schriebmaier CASSUTT-111M · S/N 499Built 1973 · Weller Steven CN504CSCirrus Design SR22 · S/N 4131Built 2014 · Beach Cruiser Express LLCN5302TCessna 172E · S/N 17251202Built 1964 · Hoak Edward CN575DCPiper PA-32RT-300 · S/N 32R-7985105Built 1979 · Armadillo Aviation LLCN6004Heller DER JAGER DIX · S/N 95Weller Steven CN629BWWilliam C Woodell KITFOX SUPER SPORT · S/N KA10244176Built 2017 · Woodell William CN70SXMenear Elwood F SX-300 · S/N 70Built 1999 · Menear Elwood FN71CMNorth American NAVION · S/N NAV-4-630Built 1947 · Heekin Michael PN8414VAero Commander CALLAIR A-9A · S/N 1614Built 1971 · Weller Steven CN8667UCessna 172F · S/N 17252570Built 1965 · Hillier Ian PN8819EPiper PA-28R-200 · S/N 28R-7635209Built 1976 · Transition Aviation LLC
Back to Hummelstown, PA