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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1059XHawkins Arch HAWKINS AX-5 · S/N 005N15141Piper PA-28-180 · S/N 28-7305027N156CVStits Flut-R-Bug SA6B · S/N 1N3175VCessna 150M · S/N 15076408N395SBCirrus Design SR20 · S/N 1769N3977BBoeing E75N1 · S/N 75-5310N4098HMooney M20K · S/N 25-0417N483TBRobert May ZENITH STOL 750 · S/N 75-7726N4883PPiper PA-23-250 · S/N 27-464N50132Cessna 150H · S/N 15069080N50284Cessna 150H · S/N 15069195N5614RBeech F33A · S/N CE-1414N5619CCessna 140A · S/N 15622N583MGBeech V35B · S/N D-10177N60056Cessna 150J · S/N 15070041N60323Boeing A75 · S/N 75-109N61038Cessna 150J · S/N 15070755N614JLedvina Jay K LEDVINA-KITFOX XL · S/N CCX004N6255JRaytheon A36 · S/N E-3019N6598LPiper PA-31-300 · S/N 31-483N6712SCessna 150H · S/N 15067512N69983Cessna T310Q · S/N 310Q1055N6LArnhart H L/Curry F E SWEARINGEN SX300 · S/N 19N714DDCessna 150M · S/N 15079089N741CAAero Commander 500 S · S/N 3191N80788Cessna 172M · S/N 17266748N8133UCessna 150M · S/N 15077897N866STTextron 525B · S/N 525B0521N881MDMichael P Depew A69 · S/N 001N8875UCessna 150M · S/N 15078009N9036AAdams Balloon L.D. · S/N 020N9040AAdams Balloon L D-S · S/N 022N9328BCessna 175 · S/N 55128N9451MCessna 182P · S/N 18264766N9805SAdams Balloon A55S · S/N 180N9928CSilvaire LUSCOMBE 8F · S/N S-32N9930ECessna 182R · S/N 18268473
Back to Mechanicsburg, PA