OpenAirDocs.org
Newtown, PA

Registered aircraft · 26

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

N10WHSchleicher ASW-19B · S/N 19322Built 1980 · Odonnell Michael FN12635Cessna 172M · S/N 17262130Built 1973 · Schnell Jonathan EN12GTCirrus Design SR22T · S/N 1438Built 2016 · November One Two Golf Tango LLCN137JWAmerican Champion 8GCBC · S/N 537-2011Built 2011 · Network Sales & Leasing IncN222VWCessna 182S · S/N 18280085Cool Beans LLCN2297QPiper PA-32R-300 · S/N 32R-7780245Built 1977 · Fact Ware IncN2635KCessna 180K · S/N 18053020Built 1978 · Verdi StephenN28758Grumman American Avn. AA-5B · S/N AA5B0794Built 1978 · Halstrick Richard WN290MPiper PA-23-250 · S/N 27-7554111Surging Skyward IncN374TGSchleicher KA 6 CR · S/N 1002Built 1961 · Peterson Thomas J JrN37JWCessna 208B · S/N 208B5001Built 2012 · Network Sales & Leasing IncN3976HEngineering & Research 415-CD · S/N 4677Built 1947 · Dubois WilliamN4872HCessna T182 · S/N 18267849Built 1981 · Passanante John LN585CACommander 114-B · S/N 14586Built 1993 · Thomas-Guy LtdN720GECessna 210L · S/N 21060671Built 1975 · Houcke PascalN725EDPiper PA 46-350P · S/N 4636555Built 2012 · Molden ErikN74639Grumman American Avn. AA-5B · S/N AA5B0308Built 1976 · Ford Edward JN767RHRichard W Halstrick KOLB TWINSTAR MKIII · S/N M13X21.1.00118Halstrick Richard WN7JWEmbraer Executive EMB-505 · S/N 50500172Built 2013 · Network Sales And Leasing IncN809BWMooney M20M · S/N 27-0334Built 2005 · Gilly ChristianN811EACirrus Design SR22T · S/N 1265Built 2016 · Blind Squirrel Aviation LLCN83606Aeronca 7AC · S/N 7AC-2282Built 1946 · Hayter Andrew JN8823YPiper PA-30 · S/N 30-1981Built 1969 · Ferrara John MN9197JPiper PA-28-180 · S/N 28-3265Built 1966 · Difabio Jack FN930VMSocata TBM 700 · S/N 1147Built 2016 · Blue Altitude LLCN9687ECessna 182R · S/N 18268437Built 1984 · Frohbieter Jack A
Back to Newtown, PA