Lincoln, CA
Registered aircraft · 81
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 = 'LINCOLN' 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 = 'LINCOLN' 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.
N104LDMasys Daniel R VANS RV-10 · S/N 40448N105RZZinkham Ralphe E RV6A · S/N 24527N11566Cessna 177B · S/N 17702348N115BESingleton Jeff RANS S-12 · S/N 02030960N123HFFrentzel Herman E SONEX AIRCRAFT ONEX · S/N ONX0026N132AMPiper PA-28-181 · S/N 28-7990245N1569BLuscombe 8E · S/N 6196N1600TCessna 414 · S/N 414-0380N160BABeyea Kyle H AVID MAGNUM · S/N 46MN2008QCessna 177RG · S/N 177RG0408N20PPPiper PA-22-150 · S/N 22-4554N223GEdward B Resnick AR-1 · S/N 0010N251JAEvektor-Aerotechnik A S HARMONY LSA · S/N 2021 2151N2653AQuicksilver MLII SPRINT · S/N 4655503N2789WMooney M20E · S/N 1169N31GCCraig George Sanders RUTAN VARIVIGGEN · S/N 330N3252RBeech A36 · S/N E-2952N327KCCopeland Kenneth R & Barbara L KIT-PA18 REPLICA · S/N JA1309079N338CACessna 172N · S/N 17269465N3667DCessna 310 · S/N 35367N3755LCessna 172G · S/N 17253924N3906NMooney M20C · S/N 680003N3939VCessna 150M · S/N 15076660N3977Curtiss Wright TRAVEL AIR 4000 · S/N 326N42811Piper PA-28-151 · S/N 28-7415402N42876Cessna 182L · S/N 18259229N442KLLedwith Kenneth E MIDGET MUSTANG II · S/N 442N447RVTondu Walter H VANS RV-7A · S/N 71266N4590HPiper PA-17 · S/N 17-4N464TTPilatus PC-12/47E · S/N 1464N4825DCessna 182A · S/N 34925N4EVBeech C35 · S/N D-3302N4UPBill Rose PITTS SPECIAL S-1E · S/N 735HN51865Cessna 172P · S/N 17274362N5274HCessna 172M · S/N 17265392N5401PPiper PA-24-180 · S/N 24-455N5478RCessna 172F · S/N 17253041N5675ACessna 172 · S/N 28275N568KBDJI AGRAS T100 · S/N 1581F8ZLC258P0028Y6JN56951Piper PA-28R-200 · S/N 28R-7435062N577AZOpperman Christopher J RV-7A · S/N 70428N579WWCirrus Design SR20 · S/N 1639N583DMMiller Douglas A AVID MK IV · S/N 1582DN6147HPiper PA-28-161 · S/N 28-7816229N66885Beech A36TC · S/N EA-48N6942Sullivan Edwin B JUNGSTER II · S/N JII-76004RN702DCCrotts L/Crotts N RV-7 · S/N 70296N703TRMartin Maisel CAVALIER SA102.5 · S/N 77018LFN7044VMooney M20C · S/N 20-1202N7216GCessna 172K · S/N 17258916
Back to Lincoln, CA