Lodi, CA
Registered aircraft · 47
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 = 'LODI' 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 = 'LODI' 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.
N1094WBeech V35B · S/N D-9470N1128CCessna T210M · S/N 21062711N1428VCessna 172M · S/N 17264687N1525SBeech P35 · S/N D-6967N1556WAir Tractor AT-502 · S/N 502-0185N17718Beech V35B · S/N D-9998N182ACCessna 182Q · S/N 18267482N20193Cessna 172M · S/N 17261085N2438UCessna 172D · S/N 17250038N2528Christopher Dellos GLASAIR SPORTSMAN · S/N 7149N2KFairchild 71 · S/N 675N3122ACessna 170B · S/N 25766N31639Lorain Steven L QUICKSILVER MXII SPR · S/N 529N316TSCirrus Design SR22T · S/N 1906N3181GBarton Jack W /SW Mich College MINI MUSTANG I · S/N MM1-250-BN3294JCubcrafters CC11-160 · S/N CC11-00434N3433MPiper PA-12 · S/N 12-2270N34KCCantrell Kenneth P RV-6 · S/N 60260N35615Cessna 172I · S/N 17256863N357JWWoods Jim W RV-4 · S/N 01-1480N396SPCessna 172S · S/N 172S8293N4026VCessna 170 · S/N 18345N4065BBellanca 17-30A · S/N 76-30847N412BDPiper PA46R-350T · S/N 4692115N431LRQuad City Ultralight CHALLENGER I · S/N CH1-0900-CW-0744N5174SPiper PA-28-180 · S/N 28-7105028N517SHSchumacher Joe VANS RV-7 · S/N 70624N55JWWright John T JR RV-6 · S/N 20490N5614FAlon A2 · S/N A-214N583TFBeech 95-B55 (T42A) · S/N TC-1452N6145GHiller UH-12E · S/N 5177N6260LGrumman American Avn. AA-1B · S/N AA1B-0060N6708XBeech 77 · S/N WA-53N700CNBellanca 7GCBC · S/N 961-77N73603Cessna 172M · S/N 17267572N753DBTextron 182T · S/N 18283330N8198FCessna 150F · S/N 15064298N8385KStinson 108-1 · S/N 108-1385N8800REagle Aircraft Co.-Bellanca EAGLE DW-1 · S/N 0003-80N8806YEagle EAGLE DW-1 · S/N DW-1-0044-81N8813KEagle EAGLE DW-1 · S/N DW-1-0084-82N8979SCessna 150F · S/N 15062279N89TTBell 206B · S/N 1857N920DWWhite Dale B S-6S COYOTE II · S/N 09991343N92921Commonwealth REARWIN 185 · S/N 1653N9500EAeronca 11AC · S/N 11AC-1135N952MMooney M20C · S/N 3364
Back to Lodi, CA