York, PA
Registered aircraft · 60
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 = 'YORK' 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 = 'YORK' 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.
N11SWBurkhart Grob Flugzeugbau STANDARD CIRRUS · S/N 243GN14076Waco UMF · S/N 3941N140TSCessna 650 · S/N 650-0141N143RPHonda HA-420 · S/N 42000143N15471Piper PA-28-180 · S/N 28-7305080N154MWWaco Classic YMF-F5C · S/N F5C-8-154N1632HPiper PA-28-181 · S/N 28-7790319N177PLCessna 177B · S/N 17702609N17XAX-Air XA85 · S/N XA850004N19367Cessna 150L · S/N 15074369N1967RRaven S-50A · S/N S50A-182N19958Cessna 172M · S/N 17260887N200FTCessna 525A · S/N 525A-0200N2015JCameron Balloons US A-120 · S/N 6528N207BHCessna T207A · S/N 20700735N207FDCessna 207A · S/N 20700760N25559Curtiss Wright JN4C · S/N 10875N2659BCirrus Design SR22 · S/N 0237N275GCBombardier CL-600-2B16 · S/N 5943N27649Taylorcraft BL-65 · S/N 2291N280YBIai GULFSTREAM G280 · S/N 2284N294DCDiamond Aircraft Ind DA20-C1 · S/N C0529N300VCVic Syracuse 300L · S/N 2106N321BFHawker Beechcraft B200GT · S/N BY-83N34764Cessna 177B · S/N 17701990N3963Waco GXE · S/N 1264N4304SLinebaugh Ricky L KOLB TWINSTAR · S/N TS273N448KCTextron 680 · S/N 680-0588N449KCPilatus PC-12/47E · S/N 2074N44DZPiper PA-32-260 · S/N 32-7300046N44WBCessna A152 · S/N A1520909N450DCRotorsport UK ROTORSPRT UK CAVALON · S/N RSUK-V00604N4668Waco 10 · S/N 1405N47995Piper PA-28-181 · S/N 28-7890168N48JSCirrus Design SR20 · S/N 2496N5136GCessna 172K · S/N 17258450N5170MBeech C23 · S/N M-2050N517MECessna 560XL · S/N 560-6005N5386JCessna 172N · S/N 17273776N53VETextron G58 · S/N TH-2530N54416Piper PA-32-260 · S/N 32-7400018N555SSRockwell International 114 · S/N 14045N61525Boeing A75N1(PT17) · S/N 75-1023N65LWCessna 525B · S/N 525B0373N6816UMooney M20C · S/N 2531N7114SCessna 182P · S/N 18265064N7246XCessna 150A · S/N 15059346N7364HSchweizer 269C · S/N S1938N757FQCessna 152 · S/N 15279708N79DFBeech 95-B55 (T42A) · S/N TC-1883
Back to York, PA