Lancaster, PA
Registered aircraft · 59
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 = 'LANCASTER' 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 = 'LANCASTER' 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.
N102SCSix Chuter LEGEND XL · S/N 3106N108HHitte John J KITFOX IV · S/N 1555N11352Cessna 150L · S/N 15075344N119MABRM Aero BRISTELL S-LSA · S/N 021/2012N152SDCirrus Design SR22 · S/N 3304N17FVPiper PA-28R-201 · S/N 28R-7737089N20628Fairchild 24R-9 · S/N R9-403N2237JCessna 150G · S/N 15065437N223CTFlight Design CTSW · S/N 06-05-01N2371SHead Balloons AX8-88 · S/N 352N257MMCirrus Design SF50 · S/N 0496N2690EOlson Terry CHALLENGER 1 · S/N 0307-0801N307CSCessna T206H · S/N T20609105N3283NNorthwing Design APACHE SPORT · S/N 6199N3430NMooney M20F · S/N 680050N3619NMooney M-20G · S/N 680015N366ABTravis Boston 90B · S/N 01BN384MCCessna 172S · S/N 172S10438N388SGLeinberger Gary XS MOTORGLIDER · S/N A237N3913FCessna 172 · S/N 36813N3VJCessna 310Q · S/N 310Q0746N4170VPiper PA-32R-301T · S/N 3257141N42167Piper PA-28-151 · S/N 28-7415383N4233HPiper PA-14 · S/N 14-36N44887Piper PA-28R-201 · S/N 28R-7737149N4621JPiper PA-28R-180 · S/N 28R-30506N501PFLancair LC-40-550FG · S/N 40021N520CKIsrael Aircraft Industries ASTRA SPX · S/N 094N5290LPiper PA-28-180 · S/N 28-4591N53758Bellanca 7KCAB · S/N 540-75N53TTHentges David PROSTAR PT2C · S/N 1243N55WXMurr John D WAIEX · S/N W0055N607DSDiamond Aircraft Ind DA 40 · S/N 40.207N621PPBombardier BD-100-1A10 · S/N 21090N6502ALancair LC42-550FG · S/N 42048N6659PPiper PA-24-250 · S/N 24-1782N681NGPilatus PC-12/47E · S/N 1681N7001WPiper PA-28-180 · S/N 28-673N7009XSkystar KITFOX LITE · S/N 99N70DRBeech V35B · S/N D-10224N70JLJoseph H Lanzillo MTOSPORT 2017 · S/N M01840N7139WPiper PA-28-180 · S/N 28-942N732BYCessna 210L · S/N 21061398N7402HCameron Balloons N-105 · S/N 5123N7521HPiper PA-12 · S/N 12-385N7574Bell 47G-2A · S/N 2665N757TSPilatus PC-12/47E · S/N 1644N759HSCessna 182Q · S/N 18266012N79307Fairchild M-62A-3 · S/N FZ-337N81271Fairchild 24W-46 · S/N W46-171
Back to Lancaster, PA