Mechanicsburg, PA

Registered aircraft · 37

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

N1059XHawkins Arch HAWKINS AX-5 · S/N 005Depew Michael PN15141Piper PA-28-180 · S/N 28-7305027Built 1972 · Murphy Jeffrey SN156CVStits Flut-R-Bug SA6B · S/N 1Huffnagle Beth VN3175VCessna 150M · S/N 15076408Built 1974 · Dunaire LLCN395SBCirrus Design SR20 · S/N 1769Built 2007 · Pc-Tronix IncN3977BBoeing E75N1 · S/N 75-5310Kampel Thomas EN4098HMooney M20K · S/N 25-0417Lance Aero IncN483TBRobert May ZENITH STOL 750 · S/N 75-7726Built 2020 · May RobertN4883PPiper PA-23-250 · S/N 27-464Built 1961 · Mardis James TN50132Cessna 150H · S/N 15069080Built 1968 · Dunaire LLCN50284Cessna 150H · S/N 15069195Built 1968 · Dunaire LLCN5614RBeech F33A · S/N CE-1414Built 1989 · Ledvina Jay KN5619CCessna 140A · S/N 15622Dunaire LLCN583MGBeech V35B · S/N D-10177Built 1978 · Zazworsky John D JrN60056Cessna 150J · S/N 15070041Built 1968 · Jones EdwardN60323Boeing A75 · S/N 75-109Built 1958 · Kampel Thomas EN61038Cessna 150J · S/N 15070755Built 1969 · Bartholomew Howard R JrN614JLedvina Jay K LEDVINA-KITFOX XL · S/N CCX004Built 1994 · Ledvina Jay KN6255JRaytheon A36 · S/N E-3019Built 1996 · Azimuth Aviation LLCN6598LPiper PA-31-300 · S/N 31-483Built 1969 · Atmospheric Corrosion Specialists IncN6712SCessna 150H · S/N 15067512Built 1967 · Dunaire LLCN69983Cessna T310Q · S/N 310Q1055Built 1974 · Ruble Air LLCN6LArnhart H L/Curry F E SWEARINGEN SX300 · S/N 19Attinger Brian DN714DDCessna 150M · S/N 15079089Built 1976 · Dunaire LLCN741CAAero Commander 500 S · S/N 3191Built 1974 · Harold F MoweryN80788Cessna 172M · S/N 17266748Built 1976 · Bell Aa Flying Club IncN8133UCessna 150M · S/N 15077897Dunaire LLCN866STTextron 525B · S/N 525B0521Carlisle Travel Management IncN881MDMichael P Depew A69 · S/N 001Built 2022 · Depew Michael PN8875UCessna 150M · S/N 15078009Dunaire LLCN9036AAdams Balloon L.D. · S/N 020Depew Michael PN9040AAdams Balloon L D-S · S/N 022Depew Michael PN9328BCessna 175 · S/N 55128Dethlefs Darrell CN9451MCessna 182P · S/N 18264766Built 1976 · Snow Jeffrey JN9805SAdams Balloon A55S · S/N 180Depew Michael PN9928CSilvaire LUSCOMBE 8F · S/N S-32Built 1959 · Taylor Steven EN9930ECessna 182R · S/N 18268473Built 1985 · Bell A A Flying Club
Back to Mechanicsburg, PA