OpenAirDocs.org
Erwinna, PA

Registered aircraft · 32

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

N1105QCessna 310H · S/N 310H0105Built 1963 · Sundale Aviation IncN1626MBoeing A75N1(PT17) · S/N 75-8441Built 1943 · Ogr Air LLCN180DHCessna 180J · S/N 18052615Built 1975 · Marden Aero Services LLCN18922Ryan Aeronautical ST-A · S/N 312Built 1939 · Sundale Aviation IncN201GMAero Commander 200D · S/N 312Built 1966 · Sundale Aviation IncN239EBeech D17S · S/N 4916Built 1943 · Sundale Aviation IncN24312Taylorcraft BL · S/N 1647Built 1940 · Eisenhauer CorpN2619NCessna 120 · S/N 12879Built 1947 · Johnston Andrew JN27567Piper PA-31-310 · S/N 31-7812054Built 1978 · Plecenik William JN28DDSchweizer SGS 2-32 · S/N 20Built 1965 · Sundale Soaring LLCN29368Waco UPF-7 · S/N 5395Built 1940 · Marden Thomas CN32193Waco UPF-7 · S/N 5825Built 1942 · Marden Aero Services LLCN40JXInterplane Spol.S.R.O SKYBOY · S/N 030/2001Sundale Aviation IncN42803Piper J3C-65 · S/N 15118Built 1946 · Ass Bag Cub LLCN46317Cessna 180J · S/N 18052416Built 1974 · Mcvicker Andrew BN4689Travel Air Mfg 2000 · S/N 403Built 1928 · Eisenhauer Loring BN47JPiper J4A · S/N 4-765Registration pendingBuilt 1939N484FLPiper PA-28-140 · S/N 28-7125292Built 1971 · Smith Stephen AN485CMeyers Industries 200A · S/N 253Built 1959 · Sundale Aviation IncN523SCPiper PA-18-125 · S/N 18-670Built 1951 · Bush Rider LLCN591DBDehavilland DHC-2 · S/N 1310Built 1959 · Wet Dreams LLCN615SSSmith Stephen AVIAT EAGLE II · S/N 461Built 2004 · Smith StephenN6550QAlon A2 · S/N A-150Built 1966 · Marden MicheleN6717ZPiper PA-25-235 · S/N 25-2273Built 1963 · Smith Stephen AN68985Boeing E75 · S/N 75-5043Built 1943 · Mcvicker Andrew BN7601UPitts Special S-1C · S/N 112Built 1968 · Roads End Aero LLCN767JWTatelman-Pitts SPECIAL S-1 · S/N 7777Built 1971 · Roads End Aero LLCN88366Piper J3C-65 · S/N 15984Built 1946 · Whiskey Bravo Air LLCN9294HCessna A185F · S/N 18503428Built 1977 · Wet Dreams LLCN93458Pilatus B4-PC11 · S/N 061Built 1973 · Smith Stephen AN966ESScheppers Eric F PITTS S1C · S/N 966Sale reported, canceledBuilt 2018N9917Curtiss Wright TRAVEL AIR B9-4000 · S/N 1103Built 1929 · Plecenik William J
Back to Erwinna, PA