Placerville, CA
Registered aircraft · 68
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 = 'CA' AND g.registrant_city = 'PLACERVILLE' 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 = 'CA' AND g.registrant_city = 'PLACERVILLE' 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.
N110TNPiper PA-28-180 · S/N 28-7305054N115JFCessna 140 · S/N 13498N1171BCessna 172A · S/N 47675N1578SCarlson Steven S KITFOX SERIES 5 · S/N S9611 0201N1587MCessna 182P · S/N 18264379N1592BLuscombe T-8F · S/N 6219N169JGMcpherson John G PIETENPOL AIRCAMPER · S/N M-001N17220Piper J-2 · S/N 886N1824KTim R Kurreck JAVRON PA-18 · S/N JA1708114N182NMCessna 182P · S/N 18263782N2092NCessna 140 · S/N 12328N211GLuscombe/Pedersen T-8F · S/N 6684N221AWCirrus Design SR22 · S/N 0758N23RRLittle Ray R VARIEZE · S/N 1094N252PSAviat PITTS S-2B · S/N 5334N2662JCessna 150G · S/N 15065662N2670DCessna 170B · S/N 20822N2862YCessna 182E · S/N 18253862N2HDDouglas T Delapp RV-8 · S/N 82959N301TAPiper PA-46-701TP · S/N 46020022N322TMMooney M20M · S/N 27-0084N333RKPipistrel D O O VIRUS SW · S/N VSWX1270016N352DRRichard Rood ZENETH ROOD E-2 · S/N 001N376AZI.C.A.-Brasov IS-28B2 · S/N 28N4090BBellanca 17-31ATC · S/N 75-31112N411MKKirkpatrick Mark S MSK6 · S/N 001N411WRAero Commander 680FL P · S/N 1505-19N413PSCzech Sport PIPER SPORT · S/N P1001005N415SMCorder Michael R RV7A · S/N 71844N417GWGeorge A Wilkie KITFOX 5 · S/N GW001N4281BI.C.A.-Brasov IS-28B2 · S/N 123N43AMBeech D95A · S/N TD-572N446WMWolf James D KITFOX IV · S/N 1539N4541MBeech A36 · S/N E-1232N4543BCessna 180 · S/N 31442N4837WRockwell International 114 · S/N 14167N484MLEaa 484 CALAVAIR · S/N ML001N49173Taylorcraft DCO-65 · S/N 5220N4942ACessna 180 · S/N 32339N5150CDennis L Janca GLASTAR · S/N 5241N52HWPiper PA-28-180 · S/N 28-3466N530ECAmerican Eurocopter AS350B3 · S/N 7708N5365PPiper PA-24-250 · S/N 24-414N5548DBeech H35 · S/N D-5111N5604QMooney M20E · S/N 658N5726CCessna 170A · S/N 19680N5850PPiper PA-24-250 · S/N 24-932N628DFRichard C Clark JR VANS RV-14A · S/N 140714N6393TCessna 305A · S/N 21146N657WAPiper PA-46-600TP · S/N 4698057
Back to Placerville, CA