OpenAirDocs.org
Chowchilla, CA

Registered aircraft · 43

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

N1559LBeech F33A · S/N CE-673Built 1976 · Lauritzen CliftonN16FFNorth American SNJ-5 · S/N 90882Built 1944 · Oflanagan Clancy HN176PSCirrus Design SR22 · S/N 2249Built 2006 · Jr Barragan IncN17KRBeech 95-C55 · S/N TE-210Built 1966 · Merriam LowellN17SFBeech D17S · S/N 6890O'Flanagan Clany HN180JJCessna 180J · S/N 18052607Oflanagan Clancy HN198RBStinson L-5 · S/N 4298633Built 1942 · Oflanagan Clancy HN19ATHawker Beechcraft G36 · S/N E-3900Built 2009 · Eastside Transporation LLCN212DTAir Tractor AT-802A · S/N 802A-0212Built 2005 · Thiel Aircare IncN22NHBell 206B · S/N 1547Built 1974 · Schuh Roger JN231NSMooney M20K · S/N 25-0329Built 1980 · Lawrence Steven RN23219Air Tractor AT-301 · S/N 301-0369Thiel Air Care IncN2367CAir Tractor AT-301 · S/N 301-0412Thiel Air Care IncN247SEAir Tractor AT-802A · S/N 802A-0444Built 2012 · Thiel Air Care IncN283XLBell 206B · S/N 715Built 1971 · Thiel Air Care IncN2949WBell 206B · S/N 824Built 1972 · Thiel Air Care IncN31626Air Tractor AT-400 · S/N 400-0511Built 1983 · James Richard WN350JKKing N Judge LONGEZ · S/N 350Built 1982 · Lawrence Steven RN390TBNorth American T-6D · S/N 44-81634Built 1944 · Merriam Lowell GN44769Naval Aircraft Factory N3N-3 · S/N 2598Built 1940 · Merriam LowellN4537DBeech G35 · S/N D-4751Built 1956 · Blech Connor NN458DCDJI AGRAS T30 · S/N 3U4DJKT0011EP8Precision Drone LLCN46296Beech F17D · S/N 332Built 1939 · L G Merriam Equipment LLCN5176XChampion 7KCAB · S/N 188Thiel Douglas EN52FFCessna 152 · S/N 152-82375Oflanagan Clancy HN53493Boeing PT-17 · S/N 75-1480Built 1941 · Stearman Pt 17 LLCN587LBeech M35 · S/N D-6239Built 1959 · Blech Connor NN6737VBeech A36TC · S/N EA-63Riverview RanchesN68835Boeing PT-13D · S/N 755647Built 1944 · Oflanagan Clancy HN6FCBeech B35 · S/N D2461Merriam Lowell GN6TFNorth American SNJ-5 · S/N 84969Built 1945 · Oflanagan Clancy HN70441Piper J3C-65 · S/N 17435Built 1946 · Oflanagan Clancy HN7054LRobinson Helicopter R44 II · S/N 13545Schuh Roger JN802DTAir Tractor AT-802A · S/N 802A-0590Built 2015 · Thiel Air Care IncN82CTCessna 182M · S/N 18259804Built 1969 · Coelho Gabriel PN83992Aeronca 7AC · S/N 7AC-2678Built 1946 · Mandala Michael LN84053Aeronca 7AC · S/N 7AC-2740Built 1946 · Mandala Mike LN9075EMaule M-5-210C · S/N 6196CBuilt 1977 · Talley Clifford CN9090YAir Tractor AT-502B · S/N 502B-0616Built 2000 · Thiel Air Care IncN918SABeech C90 · S/N LJ918Built 1980 · Thiel Air Care IncN91918Air Tractor AT-502 · S/N 502-0227Built 1993 · Thiel Air Care IncN93JTPiper PA-11 · S/N 11-1474Built 1947 · O Flanagan Clancy HN985FFBoeing A75N1(PT17) · S/N 75-7782Built 1943 · Oflanagan Clancy H
Back to Chowchilla, CA