OpenAirDocs.org
Washington, PA

Registered aircraft · 35

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

N1117XPiper PA-28R-200 · S/N 28R-7535248Built 1975 · Harshman James MN1118TBeech 95-B55 (T42A) · S/N TC-813Built 1964 · Friend Air Care IncN1280TPiper PA-28R-200 · S/N 28R-7235253Built 1972 · Certified Equipment Inspections LLCN155DMCessna 340A · S/N 340A0511Built 1978 · Harden Aviation LLCN192NMValovich Paul VANS RV-8A · S/N 82243Valovich Paul JN2026EDalesio Robert P HUMMEL BIRD · S/N 731-PDalesio Robert PN2058QCessna 177RG · S/N 177RG0458Built 1973 · N2058q LLCN2280Pitts 9-260L · S/N 10Built 1968 · Grimm Lawrence SN2601RPiper PA-28R-200 · S/N 28R-35223Built 1969 · Harden Aviation LLCN262WBeech 35-C33 · S/N CD-1031Built 1966 · Page Jeffrey VernonN289DACirrus Design SR20 · S/N 2082Built 2011 · Harden Aviation LLCN29SNLearjet 31A · S/N 194Rsb Investments LLCN337CCHawker Beechcraft HAWKER 900XP · S/N HA-0155Built 2009 · Chapman CorpN33992Taylorcraft BC12-65 · S/N 2844Built 1941 · Grimm Lawrence SN342DBBeech/Blackwell D D A-45 · S/N G107Built 1999 · Beitler WilliamN34DFDouglas DC3 · S/N 4865Built 1952 · Vintage Wings IncN3904SCessna 172E · S/N 17251104Built 1963 · Lambert Aviation Service LLCN3DUBell 206B-III · S/N 4492Built 1998 · Crile Consolidated Industries IncN41195Piper PA-28-151 · S/N 28-7415133Built 1974 · Flaus Deborah LN413MPCirrus Design SR22T · S/N 2203Built 2020 · 413 Aviation LLCN418DLLearjet 31A · S/N 181Built 1999 · Rsb Investments LLCN43039Taylorcraft BC12-D · S/N 6698Mocniak Michael JN432EBBell UH-1H · S/N 13903Built 1977 · Rs Aviation LLCN474XGulfstream Aerospace G-IV · S/N 1445Built 2001 · Washington Penn Plastic Co IncN5172Beech A45 · S/N G-729Built 1955 · Beitler William JN520PPav Joseph W VANS RV-7A · S/N 70798Built 2006 · Boggs Kevin DN624CEEnstrom F-28C · S/N 462Certified Equipment Inspections LLCN664MHHarden Michael J FIRE STAR II · S/N FS-664Harden Michael JN7338CPuderbaugh Dean G RV-8 · S/N 83216Harden Michael JN772PPLearjet 60 · S/N 293Built 2005 · Rsb Investments LLCN787WWCessna 172S · S/N 172S8589Built 2000 · Dye KentN81749Piper PA-28-181 · S/N 28-8290107Built 1982 · Friend Aircare IncN8315MCubs Unlimited/Piper PA 18-150 · S/N CU 18-001Built 2004 · Burcin Michael HN8631YEnstrom F-28F · S/N 738Built 1985 · Harden Michael JN97SWLearjet 60 · S/N 201Built 2000 · Rsb Investments LLC
Back to Washington, PA