OpenAirDocs.org
Bethlehem, PA

Registered aircraft · 43

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

N102BSShannon Bruce Scott PHANTOM · S/N 222Built 1984 · Shannon Bruce ScottN108CBBrown Charles E RV 4 · S/N 346Nanna Whitney BN123CMPiper PA-28-181 · S/N 28-7790575Built 1977 · Sweet Wings IncN170BSCessna 170B · S/N 26214Built 1954 · Mcintyre James CN18284Beech A36 · S/N E-1073Built 1977 · Condor Aviation LLCN182JSCessna 182S · S/N 18280655Built 1999 · John W Spurlock Md LtdN184MMeyers Industries 200C · S/N 282Highland Holdings LLCN19400Cessna 150L · S/N 15074395Bailis David PN200XLPiper PA-31T2 · S/N 31T-8166010Built 1981 · Condor Aviation LLCN2446MPiper PA-12 · S/N 12-1672Built 1947 · Condor Aviation LLCN2643EAeronca 7AC · S/N 7AC-6225Built 1946 · Bailis DavidN31734Piper PA-28R-201 · S/N 28R-7837246Built 1978 · Oscar Air LLCN345PDDJI PHANTOM 3 ADVANCED · S/N P76DCE11013194City Of Bethlehem Police DeptN3739KFricke Karl E MAINAIR BLADE 912 · S/N 117609987W979Built 1998 · Sobota Mark SN409ACAero Commander 200D · S/N 336Built 1966 · Highland Holdings LLCN4150AGoodyear S-94 · S/N P-6Built 1957 · Has Anyone Seen My Balloon IncN44394Taylorcraft BC12-D · S/N 10194Built 1955 · Shea James RN443JDiamond Aircraft Ind DA 42 NG · S/N 42.N565Built 2024 · Contrail IncN5089VCessna 182Q · S/N 18267506Built 1980 · 89v LLCN5128SPiper PA-28-140 · S/N 28-7125512Built 1971 · Donegan Martin A ON57823Mooney M20K · S/N 25-0848Built 1984 · Sg Aircraft IncN5813UMooney M20J · S/N 24-1649Stackhouse Thomas GN611ESCirrus Design SR22 · S/N 3053Built 2008 · Gs Flying Club LLCN6215BCessna 182Q · S/N 18266135Built 1977 · Artskills IncN622ELCirrus Design SF50 · S/N 0669Built 2025 · Jf Air LLCN62640Cessna 172P · S/N 17275318Built 1981 · Condor Aviation LLCN651WBSocata TBM 700 · S/N 364Built 2006 · Contrail IncN700JCRockwell International NA-265-65 · S/N 465-74Built 1981 · Salameh Aviation LLCN700VWPiper PA-60-700P · S/N 60-8423012Built 1984 · Condor Aviation LLCN703TGRockwell International 112TCA · S/N 13195Built 1977 · Mcneil OtisN7052USchweizer SGS 1-26A · S/N 18Built 1955 · Bailis David PN7365YPiper PA-30 · S/N 30-416Built 1964 · Loguidice AnthonyN7412KPiper PA-20 · S/N 20-322Built 1950 · Bailis David PN7662UCessna 150M · S/N 15077788Built 1976 · Mcintyre James CN768FPDJI INSPIRE 1 · S/N W13DCG16040351Lehigh University Police DepartmentN7840FPiper PA-28-181 · S/N 28-7790228Built 1976 · Lederach David BN80438Beech 35 · S/N D-38Built 1947 · Newhard Glenn KN809APiper PA-22 · S/N 22-114Built 1951 · Keller Gene MN8614KStinson 108-1 · S/N 108-1614Registration pendingBuilt 1947N910DPCessna 750 · S/N 750-0239Built 2005 · N910dp LLCN9271MMooney M20C · S/N 3459Built 1966 · Cantelmi Richard LN929PGMooney M20F · S/N 680039Built 1967 · N929pg LLCN9327HAeronca 7BCM · S/N 7BCM-318Built 1947 · Bealer David C
Back to Bethlehem, PA