Napa, CA
Registered aircraft · 151
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 = 'NAPA' 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 = 'NAPA' 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.
N10WMArbc Inc DBA Lindstrand 310A · S/N 5479N1124WGlasflugel KESTREL · S/N 7N1145BCessna T182T · S/N T18208649N129DEEvans William D KITFOX · S/N 420N13DSchempp-Hirth STANDARD CIRRUS · S/N 171N15450Piper PA-28-140 · S/N 28-7325071N1648Accettola Frank T AIRBORNE EDGE X · S/N E-162N172SFCessna 172RG · S/N 172RG1149N1764KLuscombe 8E · S/N 4491N1870VCessna 172M · S/N 17263776N1878APiper PA-18-125 · S/N 18-1713N1939VCessna 140 · S/N 14145N1947TCameron Balloons US A-400 · S/N 6859N201MMMooney M-18C 55 · S/N 357N2022JCameron Balloons US A-250 · S/N 6536N20858Cessna 172M · S/N 17263857N21068Aeronca KCA · S/N KCA-40N210NLCessna P210N · S/N P21000674N2119TPiper PA-28R-200 · S/N 28R-7135064N2195AGiles Dwight F WAG-A-BOND TRAVELER · S/N DG 49N2272PCessna T206H · S/N T20608745N2304JCameron Balloons A-315 · S/N 6633N2330NCessna 140 · S/N 12570N2335FCessna 210E · S/N 21058535N240PMArbc Inc DBA Lindstrand 240A · S/N 5498N24YDJarrett David SEAREY · S/N 1DK427CN2565UPiper PA-28-181 · S/N 28-8090058N25NVCameron Balloons US A-250 · S/N 6927N2629AApex CROSS 5 · S/N GST-AP-1N26GJSchleicher Alexander ASH 26 E · S/N 26141N2700KSilvaire LUSCOMBE 8E · S/N 5427N2736QCessna 182K · S/N 18257936N278LNCessna 525A · S/N 525A0338N2859LCessna 172H · S/N 17256059N2883XCessna 177 · S/N 17700283N2925KLuscombe 8E · S/N 5652N3002AArbc Inc DBA Lindstrand 120A · S/N 5455N30164Marshall Jim AEROCHAIR AX4-31 · S/N 002N301HNNelson Hilary L/Nelson Tyler E VANS RV 8 · S/N 80281N311MMCessna R182 · S/N R18200366N3144VCessna 172S · S/N 172S9123N315RVJohn W Thomason RV-9A · S/N 91061N3171MPiper PA-12 · S/N 12-1852N325PVKubicek Factory S R O BB92Z · S/N 2261N325YVKubicek Factory S R O BB92Z · S/N 2260N3290WBalloon Works FIREFLY 8B-15 · S/N F8B-504N3304KGlobe GC-1B · S/N 1297N3307KGlobe GC-1B · S/N 1300N33378Piper PA-28-180 · S/N 28-7505139N3374VBeech F35 · S/N D-4042
Back to Napa, CA