OpenAirDocs.org
Germansville, PA

Registered aircraft · 19

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

N1227SSchweizer SGS 2-33A · S/N 212Built 1971 · Kutztown Aviation Service IncN17847Piper J-2 · S/N 1282First renewal noticeFlying M Services IncN20SRWilliams James Bruce SR 3500X · S/N SR0901Built 2010 · Williams James BruceN226ASRans RANS COYOTE · S/N 89090Williams Robert WN2637HSchweizer SGS 2-33A · S/N 447Built 1976 · Kutztown Aviation Svc IncN2659HSchweizer SGS 2-33A · S/N 459Built 1976 · Kutztown Aviation Service IncN2838HSchweizer SGS 2-33A · S/N 546Kutztown Aviation Service IncN327PKCirrus Design SF50 · S/N 0568Built 2024 · Squadron Blue LLCN386CStinson 108-2 · S/N 108-3386Flying M Services IncN5173LPiper PA-28-180 · S/N 28-3994Built 1967 · Devries Pat DBAN51807Boeing A75N1(PT17) · S/N 75-2529Built 1942 · Maniscalco PeterN57472Bellanca 7GCBC · S/N 512-73Built 1973 · Kutztown Aviation Service IncN5970Williams James Bruce KITFOX 5 · S/N 597040213Williams James BN6248HPiper J3C-65 · S/N 19423Built 1946 · Maniscalco PeterN745CUniversal Stinson 108-3 · S/N 108-3745Built 1947 · Maniscalco PeterN762BTRaymond M Steele TRAVELER · S/N BLAKT004Steele Raymond MN78628Cessna 172K · S/N 17257694Built 1968 · Milot John MN8902HNorth American NAVION · S/N NAV-4-902Built 1947 · Kutztown Aviation Service IncN905CStinson 108-3 · S/N 108-3905Flying M Services Inc
Back to Germansville, PA