OpenAirDocs.org
Doylestown, PA

Registered aircraft · 42

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

N14DRBeech B-55 · S/N TC-2310Built 1980 · Randall Adam MN1647YCessna 172C · S/N 17249347Rudolphi William AN192MCCessna 172S · S/N 172S10162Built 2006 · Warrington Flying Club IncN1946VCessna R172K · S/N R1722221Built 1976 · Leading Edge Aviation IncN19SKCirrus Design SR22 · S/N 10862Built 2025 · Eagle Capital Holdings LLCN223TPBeech B200 · S/N BB-1348Built 1989 · Aviapa LLCN2437UCessna T210N · S/N 21064782Built 1983 · Planetosea LLCN25704Beech A36 · S/N E-475Built 1973 · Arrison Frank JN3418UCessna 182F · S/N 18254818Built 1963 · Hyer Randall NN3576HPiper PA-28-181 · S/N 28-8090205Built 1979 · Johnson Grant JN36615Piper PA-32-300 · S/N 32-7840166Built 1978 · Booth Warren RussellN38639Piper PA-28R-201T · S/N 28R-7703255Built 1977 · Mccullough Peter LeeN4533ZPiper PA-22 · S/N 22-8038Built 1961 · Davis Taylor MN4600TSchleicher KA 6 CR · S/N 6315Devine Steven CN499RMMooney M20R · S/N 29-0499Built 2008 · Schell Robert W TrusteeN5054KBellanca 8KCAB · S/N 534-79Built 1979 · Obe Aviation LLCN54097Piper PA-23-250 · S/N 27-7405408Built 1974 · Piper Nia 1 LLCN561PHHoey Peter F SONEX B · S/N SNB0021Built 2022 · Hoey Peter FN5648SBeech 35-C33 · S/N CD-1034Built 1966 · Winged Warriors Aviation LLCN5808CBeech C35 · S/N D-2760Built 1951 · Deasy John F JrN58700Boeing A75N1(PT17) · S/N 75-3908Built 1942 · Mile High Advertising IncN58AYBeech B200 · S/N BB-1511Built 1995 · Aviapa Flight LLCN595KCessna 172L · S/N 17260401Built 1972 · Harvey Air LLCN5GHMooney M20E · S/N 700046Built 1970 · Dowin Robert RN6245XCessna 182T · S/N 18282089Built 2008 · Warrington Flying Club IncN6252TCessna TR182 · S/N R18201947Built 1983 · Venkataswamy LakshmiN631AKAdam Randall/Kyle Randall VANS AIRCRAFT RV-7 · S/N 72023Built 2019 · Randall Adam MN677YCessna 182K · S/N 18258374Built 1967 · N677y IncN700HSNanchang China CJ-6A · S/N 4032006Built 1982 · Booth Warren RN734AUCessna 172N · S/N 17268709Built 1977 · Leading Edge Aviation IncN745CCTextron 525B · S/N 525B0663Built 2022 · Fred Beans Ford IncN755PRaytheon G58 · S/N TH-2162Noble Advertising Inc DBAN75CVCirrus Design SR22T · S/N 10354Built 2024 · Beans Fred WN7611SCessna 182Q · S/N 18265259Built 1976 · Mile High Advertising IncN784CACirrus Design SR22 · S/N 11101Built 2026 · Eagle Capital Holdings LLCN79224Cessna 172K · S/N 17257976Wolstenholme James LN793SPCessna 172S · S/N 172S8718Built 2001 · Leading Edge Aviation IncN800JSPiper PA 46-350P · S/N 4636534Built 2012 · J M S Enterprises IncN812BCNorth American SNJ-5 · S/N 43812River Birch CoN913WGGan Thomas W RV9-A · S/N 91887Built 2013 · Gan Thomas WN92TRRobinson Helicopter R22 BETA · S/N 2375Built 1993 · Shuhart Harvey A JrN94006Cessna 152 · S/N 15285582Built 1982 · Leading Edge Aviation Inc
Back to Doylestown, PA