West Chester, PA
Registered aircraft · 76
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 = 'WEST CHESTER' 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 = 'WEST CHESTER' 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.
N10MQPerson Michael MICHAEL QUESTAIR-SPI · S/N 001N121RPMooney M20R · S/N 29-0141N12571Cessna 172M · S/N 17262082N1300YCessna 172C · S/N 17249000N1370VBoeing E75 · S/N 75-5185N1477MEisele Donald L VANS RV-14 · S/N 140329N15021Piper PA-28R-200 · S/N 28R-7235319N15SBCompagnie Daher TBM 700 · S/N 1405N1832XCessna 182H · S/N 18255932N2211MPiper J3C-65 · S/N 21002N2224BPiper PA-28-236 · S/N 28-7911014N2242FPiper PA-28-236 · S/N 28-7911059N23663Taylorcraft BC · S/N 1394N237VWVans RV-12 · S/N 120996N2445XCessna 182H · S/N 18256345N25PYTextron T206H · S/N T20609521N284JATextron G36 · S/N E-4163N2885NPiper PA-28-181 · S/N 28-7990527N300WEPiper PA-32RT-300 · S/N 32R-7985007N3040QPiper PA-28-181 · S/N 28-7990300N32642Piper J3L-65 · S/N 5511N328DACirrus Design SR22T · S/N 8534N3316QCessna 320D · S/N 320D0116N343ASMeserole William H RV-4 · S/N WM-2N3543HCessna 182T · S/N 18281024N3603HMooney M20C · S/N 20-1240N3763WPiper PA-32-260 · S/N 32-681N4306BPiper PA-28-181 · S/N 28-8390068N440WARobinson Helicopter R44 II · S/N 14888N4454HPiper PA-15 · S/N 15-243N4547ZCharles H Shipman SPACEWALKER II R · S/N SA-SW20811N47406Piper PA-28-161 · S/N 28-7816068N48608Ryan Aeronautical ST3KR · S/N 1905N49EHRolladen-Schneider LS-4 · S/N 4005N50DJPiper PA-32-301T · S/N 32-8124021N51964Cessna T206H · S/N T20608936N5279TPiper PA-28-140 · S/N 28-7225386N530TBRemos REMOS G-3/600 · S/N 245N5317EBeech K35 · S/N D-5808N54254Fairchild M-62A-3 · S/N T-42-1831N5488MCessna 152 · S/N 15284596N5515Fender Craig R COMMANDER · S/N ACF-01N556PLCirrus Design SR22 · S/N 9388N561VWVaughan Jeff NORTHWING NAVAJO · S/N 003N56FCessna 172M · S/N 17265348N5966FPiper PA-28-181 · S/N 28-7790146N5HBell 47B · S/N 3N600GPPiper PA-46-600TP · S/N 4698205N610ELFender Raymond E EUROPA XS · S/N H126N6141VBeech D95A · S/N TD-614
Back to West Chester, PA