OpenAirDocs.org
Stockton, CA

Registered aircraft · 100

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 = 'STOCKTON'
  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.

N104KVCirrus Design SR20 · S/N 2683Built 2021 · Katiegirl Aviation LLCN1075KDasse Henry D JR CHALLENGER I · S/N 1194 0513Hole Jeffrey WayneN1116SBell Helicopter Textron Canada 505 · S/N 65176City Of StocktonN111PHPiper PA-34-200T · S/N 34-7970001Built 1978 · Good Flight Aviation LLCN123APPiper PA-34-200T · S/N 34-7770015Built 1977 · Jc Air Academy IncN1251UCessna 172M · S/N 17266946Grewal Amritpal SN126HKDouglas A-26C · S/N 44-35788Built 1944 · Stockton Field Aviation MuseumN1357QCessna 150L · S/N 15072657Built 1971 · Mckenzie PaulN145LRLearjet 45 · S/N 119Built 2000 · Calchem Transportation LLCN147PMQuad City CHALLENGER II · S/N CH2-1002-2694Built 2007 · Zapara Dale AN1530SBeech P35 · S/N D-6973Built 1962 · Thrailkill Robert WN15645Piper PA-28-235 · S/N 28-7310063Built 1972 · Ripken Robert LN1724NCessna 120 · S/N 11968Turcott Joshua AN1759JPiper PA-28-140 · S/N 28-24179Built 1968 · Bt Aero Precission Flight Accademy LLCN1853NCessna 120 · S/N 12097Prost Gary EN18JTThorp T-18 · S/N 02Built 1972 · Bourget Marc JN1945TPiper PA-28-140 · S/N 28-7125506Built 1971 · Patterson John WN1RBBombardier BD-100-1A10 · S/N 20073Built 2005 · Bac Transportation IncN222TXCessna 172 · S/N 29976Built 1957 · J M Williams LLCN224NDPiper PA-28-161 · S/N 2842112Built 2001 · Good Flight Aviation LLCN22828Cessna 150H · S/N 15068548Built 1968 · Shiroma Owen LN231PMooney M20K · S/N 25-0066Built 1979 · Wilverding Jerome CN235PAPiper PA-28-161 · S/N 28-7816678Built 1978 · Good Flight Aviation LLCN2423ECessna 172N · S/N 17271276Built 1978 · Good Flight Aviation LLCN2550SCessna 210L · S/N 21061326Grewal Amritpal SN2689VCessna 170 · S/N 18199Foster Stephen RN272CTBeech A36 · S/N E-2824Built 1993 · Inncal IncN2894MPiper PA-28-161 · S/N 28-7816322Built 1977 · Hernandez Michael AN2950APiper PA-44-180 · S/N 44-7995315Innoutaero LLCN2977AStraw Kevin A MXL II · S/N 9062006Murray Chaz DN29BBPilatus PC-12/45 · S/N 165Built 1996 · Pc-12 Kwru LLCN3078RPiper PA-28R-200 · S/N 28R-35638Built 1969 · Kitaguchi Terry SN3137TNew Piper PA-46-500TP · S/N 4697257Built 2006 · Project Funding CorpN314BMDJI AGRAS T50 · S/N 1581F6BUB236U001005LMorada Farming Co LLCN31853Stinson L-5E · S/N 44-17605Built 1944 · Aeronautical Educational FoundationN333RRJaworski Reginald W DMO 121 VELOCITY · S/N DMO121Built 1993 · Ott Randolph HN354DGBeech J35 · S/N D-5573Built 1958 · Gaines Lawrence CN3699HMooney M20K · S/N 25-0476Built 1980 · Barnhardt JerryN3910TPiper PA-28R-180 · S/N 28R-30245Built 1967 · Speelman Jonathan DN3BTextron 750 · S/N 750-0521Built 2015 · Going Up LLCN3CTCessna 525B · S/N 525B0041Built 2005 · Inncal LLCN402YDDJI AGRAS T50 · S/N 1581F6BUB248C001D3LWMorada Farming Company LLCN41521Adams Terry DRAGONFLY MK1 TA · S/N H-5141Built 2005 · Adams TerryN419WPAviat A-1 · S/N 1331Built 1996 · Hole Jeffrey WayneN42920Carpency Joseph T GLASTAR · S/N 5762Built 2006 · Sanders Craig AN42RYYanish Ronald L RV4 · S/N 3939Built 1998 · Ragsdale Brent NathanielN4338RCessna 172M · S/N 17263091Built 1974 · Thompson Group IncN4382JPiper PA-28-161 · S/N 28-8516018Built 1984 · Good Flight Aviation LLCN4428CBeech A36TC · S/N EA-59Built 1980 · Payne Jeffrey C TrusteeN44363Piper PA-28-151 · S/N 28-7415626Built 1974 · Good Flight Aviation LLC
Back to Stockton, CA