OpenAirDocs.org
Allentown, PA

Registered aircraft · 44

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

N111RBCessna 340A · S/N 340A0545Built 1978 · Clear Skies LLCN117KGDassault FALCON 900 EX · S/N 108Built 2002 · Tgv 900 LLCN123KWPiper PA-31-310 · S/N 31-198Built 1968 · 123 LLCN1456APiper PA-22 · S/N 22-359Built 1951 · Mcbride Michael SN1519XPiper PA-28-180 · S/N 28-7505238Built 1975 · Aycd LLCN1559HCessna 177RG · S/N 177RG0733Built 1975 · Cardair IncN188BRaytheon HAWKER 850XP · S/N 258822Patriot Air LLCN19VBeech A36 · S/N E-1107Built 1977 · Choi MarkN214HPCessna 182R · S/N 18267732Built 1980 · Killeen Sean BN224RBRobinson Helicopter R44 II · S/N 11408Built 2006 · R44 LLCN26RFHawker Beechcraft B300 · S/N FL-722Built 2010 · Vuc IncN3005JPiper PA32-301FT · S/N 3232069Built 2007 · Principal Management Group LLCN30414Heldeberg Designs LLC/Blue Her MARATHON · S/N HD05139NBuilt 2007 · Szasz TamasN321PEMcdonnell Douglas Helicopter 369E · S/N 0342EBuilt 1989 · Radnor Construction Of Delaware IncN321TRBeech F90 · S/N LA-48Vertivue LLCN333CECessna 172M · S/N 17265260Built 1975 · Fera Margaret LN365ADKubicek Factory S R O BB34Z · S/N 2175Built 2023 · Along For The Ride LLCN4086EPiper PA-31-350 · S/N 31-8152114Built 1981 · Jj Aviation LLCN40TDBrusehaver Thomas G COZY MK IV · S/N 1Built 2006 · Winick Evan KN4TPPrevost Thomas A RANS S-19 · S/N 011000087Built 2011 · Horn William DN500NRBell 206B · S/N 3049Built 1983 · Aycd LLCN51EMCessna 525C · S/N 525C0086Built 2012 · Jdi Holdings LLCN525GTCessna 525A · S/N 525A-0114Built 2002 · Vertivue LLCN525TMRaytheon 58 · S/N TH-1832Built 1997 · Vertivue LLCN531TCSchweizer 269C-1 · S/N 0285Jj Aviation LLCN5451DBeech H35 · S/N D-5252Restoration Ministry IncN5481TBombardier CL-600-2B16 · S/N 5481Registration pendingBuilt 2001N575CBeech C90 · S/N LJ-532Built 1971 · Lilly David EN5AVPilatus PC-12/47E · S/N 2086Built 2021 · Aycd LLCN613JRBombardier CL-600-2B16 · S/N 6070Built 2016 · Global Aviation Network LLCN61NWhite COUGAR · S/N RW-1Built 1961 · Elsaadany AhmedN711ECGates Learjet 35A · S/N 311Built 1980 · Semper Paratus Td I LLCN732RVCessna T210M · S/N 21061722Jongum LLCN76DHPiper PA-28-181 · S/N 2843019Built 1995 · Karapelou James MN774KVPiper PA-31T2 · S/N 31T-8166057Built 1982 · Tjr Aviation LLCN7765MMooney M20C · S/N 20-0018Built 1974 · Progressive Medical Applications CorpN82EMBombardier BD-700-1A10 · S/N 9239Built 2007 · Jdi Holdings LLCN8410JCessna 150G · S/N 15066310Built 1967 · 1st Flight LLCN877HBombardier CL-600-2B16 · S/N 5445Built 2000 · Challenger 5445 LLCN898WRGutierrez Charlie SONERAI II · S/N 1123Ribardo David SN9379NPiper PA-28R-200 · S/N 28R-35088Built 1969 · Winick EvanN9542ZMooney M20K · S/N 25-0488Built 1980 · D Danger LLCN9726GCessna 180H · S/N 18052226Built 1971 · Irc Holdings LtdN97KLHawker Beechcraft HAWKER 850XP · S/N 258876Built 2007 · Semper Paratus Td I LLC
Back to Allentown, PA