OpenAirDocs.org
Coatesville, PA

Registered aircraft · 24

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

N12517Cessna 172M · S/N 17262034Built 1973 · Huxster Robert HN201SUCessna 560 · S/N 560-0586Non-citizen corporation, flight hours not reportedBuilt 2001 · Imp IncN204SMMickelson Sheldon VANS RV-7A · S/N 70759Built 2005 · Krug Lee AN2417SCessna 337B · S/N 337-0717Built 1967 · Piasecki Aircraft CorporationN3296BCommander 114-B · S/N 14673Built 2000 · Command-Aire LLCN3344LBeech C24R · S/N MC-467Built 1976 · Blauner Peter DN359SXPiasecki AIR SCOUT · S/N 001Piasecki Aircraft CorpN35WYPilatus PC-12/47E · S/N 1180Built 2009 · Imp IncN36147Taylorcraft BL-65 · S/N 3126Built 1954 · Goldsborough Darryl SN3958VCessna 170 · S/N 18277Built 1948 · Kelsall William JN403BJCirrus Design SR20 · S/N 1665Built 2006 · Wiegand Mark HN40VTSikorsky X-49A · S/N 163283Built 2007 · Piasecki Aircraft CorpN44XEPiasecki EAGELS TD · S/N 001Piasecki Aircraft CorpN459XPiasecki PA-459 · S/N 001Piasecki Aircraft CorpN4618MBeech 58P · S/N TJ-150Built 1978 · Bedrock Siteworks LLCN4998NBoeing A75N1(PT17) · S/N 75-4210Macario T Michael IIIN531TBeech 35-A33 · S/N CD-325Built 1961 · Deck Dakota BN540CXHarris William Paul BRC 540C · S/N 376Built 2001 · Piasecki Aircraft CorpN6137SAir & Space America 18A · S/N 18-45Built 1965 · Piasecki Aircraft CorpN616HPiasecki 16H · S/N 1Piasecki Aircraft CorpN624THPiasecki PA-106 · S/N 001Piasecki Aircraft CorpN727LEDM Aerotec COAX 2 · S/N AEH0015Built 2019 · Piasecki Aircraft CorpN7933CPiper PA-28-181 · S/N 28-7690090Laytham Ricky AN934VPEDM Aerotec COAX 2 · S/N AEH 0005Built 2017 · Piasecki Aircraft Corp
Back to Coatesville, PA