OpenAirDocs.org
Smoketown, PA

Registered aircraft · 25

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

N1607ACameron Balloons US Z-225 · S/N 6701Built 2013 · Morning Star Visions IncN165JCRobinson Helicopter R22 · S/N 0146Smoketown Helicopters LLCN181AFRobinson Helicopter R44 · S/N 2100Built 2010 · Smoketown Helicopters LLCN1989PCameron Balloons US O-84 · S/N 5260Morning Star Visions IncN2364TPiper PA-28-140 · S/N 28-7225055Built 1971 · Vintage Aero ClubN24597Beech B19 · S/N MB-549Built 1972 · Smoketown Flight Center LLCN309AKDR John Cocker VANS RV 6A · S/N 23369Wings 'N Tails LLCN3100UCameron Balloons US Z-250 · S/N 6972US Hot Air Balloon TeamN345LHRobinson Helicopter R22 BETA · S/N 2533Built 1995 · Smoketown Helicopters LLCN3688EChampion 11BC · S/N 11AC-1849Built 1947 · Eaa Chapter 540 Lancaster CountyN435MCBeech 95-C55 · S/N TE-435Built 1967 · Smoketown Flight Center LLCN4537SBalony Kubicek Spol Sro BB40Z · S/N 749Morning Star Visions IncN5239KCessna 172P · S/N 17274027Built 1980 · Smoketown Flight Center LLCN540ADSattler W R ACRODUSTER TOO SA750 · S/N SA-1Horst Kendall NN6140GCessna 150K · S/N 15071640Built 1969 · Smoketown Flight Center LLCN65492Cameron Balloons Z-140 · S/N 6737Built 2014 · Morning Star VisionsN65625Cameron Balloons US Z-225 · S/N 6630Built 2011 · Morning Star VisionsN69521Cameron Balloons US Z-140 · S/N 6795Lancaster Balloon RidesN6954DCameron Balloons US Z-250 · S/N 6764Built 2015 · Morning Star VisionsN704ELCessna 150M · S/N 15078552Built 1976 · Lancaster Aero LLCN8321PRobinson Helicopter R22 BETA · S/N 2538Built 1995 · Smoketown Helicopters LLCN924DMRobinson Helicopter R44 · S/N 1253Built 2002 · Smoketown Helicopters LLCN94JGGarrison Jerry P SA-750 ACRODUSTER · S/N 0021Wings N Tails LLCN9547GCameron Balloons US V-77 · S/N 5577Built 1990 · Morning Star Visions IncN969TTCessna 172M · S/N 17261635Built 1973 · Smoketown Flight Center LLC
Back to Smoketown, PA