OpenAirDocs.org
Philadelphia, PA

Registered aircraft · 157

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

N102BGGulfstream Aerospace GVII-G600 · S/N 73061Built 2021 · Contrail Aviation LLCN1088Bombardier CL-600-2B16 · S/N 5798Built 2009 · Fmc CorpN116TGAgustawestland Philadelphia AW139 · S/N 41630Leonardo Helicopters US CorpN117SHEurocopter Deutschland EC 135 P2 · S/N 0369Non-citizen corporation, flight hours not reportedBuilt 2005 · Agustawestland Philadelphia CorpN1298JDJI AIR 2S · S/N 3YTDJ1V00324KHCallaghan Joseph B IncN129RRPipistrel D O O VIRUS SW 121A · S/N VSWX121A0127Built 2022 · Steadfast Entities LLCN131SHEurocopter Deutschland EC 135 P2 · S/N 0373Non-citizen corporation, flight hours not reportedBuilt 2005 · Agustawestland Philadelphia CorpN133SMMooney M20K · S/N 25-0001Built 1979 · Spivack PeterN139ASPdps Pzl-Bielsko SZD-45A OGAR · S/N B-772Built 1978 · Glik YevgeniyN139BAgustawestland Philadelphia AW139 · S/N 41628Agustawestland Philadelphia CorpN148PSAviat S-2C · S/N 6048Built 2001 · Asplundh Wayne BN170TAPiper PA-23-250 · S/N 27-7654005Built 1975 · Keystone Aerial Surveys IncN1737ECessna 310R · S/N 310R1556Built 1978 · Keystone Aerial Surveys IncN18BGWag Inc/Gardner W LANCAIR ES · S/N 02GTommervik SeanN20NSIlyushin IL 78 · S/N 0083485558Meridican IncN210AXCessna T210N · S/N 21063033Built 1979 · Keystone Aerial Surveys IncN221VFAgustawestland Philadelphia AW139 · S/N 41633Agustawestland Philadelphia CorpN223WDPiper PA-28-140 · S/N 28-20366Built 1964 · Gilliam Preston TN237EFAgustawestland Philadelphia AW119MKII · S/N 15037Leonardo Helicopters US CorpN2549QPiper PA-28-161 · S/N 28-7716111Built 1977 · Fly Legacy Planes LLCN26URBeech F33A · S/N CE-1274Built 1988 · Dartswift IncN2704FCessna 182J · S/N 18256804Built 1965 · Ultimate Aviation LLCN270MWCirrus Design SR22 · S/N 0735Built 2003 · M9 Aviation Ventures LLCN282EFAgustawestland Philadelphia AW139 · S/N 41641Leonardo Helicopters US CorpN283EFAgustawestland Philadelphia AW139 · S/N 41650Leonardo Helicopters US CorpN285JCRaytheon A36 · S/N E-3223Coleman John MN290WDDJI PHANTOM 4 PRO+ · S/N 0AXDDCM0B30016Wpvi-TvN292MPMooney M20J · S/N 243339Built 1994 · Rice Kendrick QN292RNBoeing CH-47F · S/N M2414Built 2019 · Boeing CoN296PDAmerican Eurocopter AS350B2 · S/N 7705Built 2013 · City Of PhiladelphiaN297PDAirbus Helicopters AS350B2 · S/N 7810Built 2014 · City Of PhiladelphiaN3028EPiper PA-28-161 · S/N 28-7916168Registration pendingBuilt 1978N308GCAgustawestland Philadelphia AW139 · S/N 41629Leonardo Helicopters US CorpN310MWCessna T310R · S/N 310R0823Built 1976 · Keystone Aerial Surveys IncN312ZBeech 35-33 · S/N CD-210Built 1960 · Fink Group LLCN321RGCirrus Design SR20 · S/N 8820Built 2022 · Irgun Aviation LLCN333FGGulfstream Aerospace G-IV · S/N 1364Built 1999 · Fg Aviation LLCN3444QCessna 320E · S/N 320E0044Built 1966 · Keystone Aerial Surveys IncN34674Cessna 177RG · S/N 177RG1012Built 1976 · Image ComponentsN3576MPiper PA-28-181 · S/N 28-7890315Built 1978 · Fly Legacy Planes LLCN358MNCessna T310R · S/N 310R0881Keystone Aerial Surveys IncN372BGGulfstream Aerospace GVII-G600 · S/N 73024Built 2019 · Contrail Aviation LLCN372MCTextron B300 · S/N FL-1299Built 2022 · Pmc Capair LLCN379EFAgustawestland Philadelphia AW139 · S/N 41634Agustawestland Philadelphia CorpN3899RCessna 172H · S/N 17255399Lockett Joseph JrN39016Grumman American Avn. AA-1C · S/N AA1C0185Built 1978 · Fortnight Aviation LLCN3912NMooney M-20G · S/N 680059Built 1968 · Chiwaya BrandonN3DDSchempp-Hirth DISCUS B · S/N 145Built 1986 · Tirca Laviniu HN4181TCessna 320D · S/N 320D0081Built 1966 · Keystone Aerial Surveys IncN428NEAgusta AW139 · S/N 41001Built 2007 · Leonardo Helicopters US Corp
Back to Philadelphia, PA