Harrisburg, PA
Registered aircraft · 53
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 = 'HARRISBURG' 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 = 'HARRISBURG' 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.
N114KKRockwell International 112TCA · S/N 13163N115PFCessna 182S · S/N 18280224N1183CCessna 177B · S/N 17702681N119FSSchreiner Doug KITFOX SERIES 5-TW · S/N 59505-0119N185PYCessna A185F · S/N 18502715N208DSDiamond Aircraft Ind DA 40 · S/N 40.587N21FFCessna 182N · S/N 18260179N247MBBombardier BD-100-1A10 · S/N 20579N2512KLuscombe 8E · S/N 5239N258ZEDJI AGRAS T100 · S/N 1581F8ZLC25AE002118ZN2621XCorman Ned E ONEX · S/N ONX0062N269MCameron Balloons US Z-77 · S/N 6524N33818Piper J3C-65 · S/N 5988N353KSCirrus Design SR22 · S/N 10212N354CHBurgener Gerald W CHLNGR 2PL CLP WING · S/N CH2-1200-CW-2038N3622PPiper PA-22-150 · S/N 22-3355N37TNUptain Troy N BD-5 · S/N 4651N3KZCousins Robert L KR 2M · S/N RLC-0003First renewal noticeN44XTAero Vodochody/Pride AERO-L39ZO · S/N 831123-PAN47207Taylorcraft DCO-65 · S/N L-5814N50PEHawker Beechcraft B200GT · S/N BY-90N5180UCessna 206 · S/N 206-0180N52301Cessna 182P · S/N 18262515N5380HPiper PA-16 · S/N 16-187N54HTCessna 550 · S/N 550-1001N5553UPiper PA-28-140 · S/N 28-26278N5613YDestiny Powered Parachute XLT · S/N 1C0274N570JHBell Helicopter Textron 206L-1 · S/N 45428N5887UPiper PA-28-140 · S/N 28-26722N595SRCirrus Design SR22 · S/N 2449N59700Beech F17D · S/N 413N60193Eagle Balloons C-7 · S/N E82737N6158ECessna 172 · S/N 46258N648JWCessna 510 · S/N 510-0073N6564UMooney M20C · S/N 2346N656ZEDJI AGRAS T100 · S/N 1581F8ZLC25AE0021J4FN6729GCessna 150L · S/N 15072229N67ADCessna 182P · S/N 18265029N6887NMooney M20C · S/N 680159N6953HCameron Balloons ZL-84 · S/N 6703N717WVGulfstream Aerospace GVII-G500 · S/N 72048N72CLLamb CJ-1 · S/N 747N772DFMooney M20J · S/N 24-0937N809NGCirrus Design SR22 · S/N 11437N84457Champion 7AC · S/N 7AC-3156N8473CPiper PA-32R-301 · S/N 32R-8213014N859ACirrus Design SR20 · S/N 11287N887SBTextron 525 · S/N 525-0887N8918KStinson 108-1 · S/N 108-1918N896UTDaniel Brian RAF-2000 · S/N H2-94-5-143
Back to Harrisburg, PA