OpenAirDocs.org
Hanford, CA

Registered aircraft · 44

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

N104SAXag P100 PRO · S/N 8219347N5844Young Family Farms LLCN1110EBellanca 8KCAB · S/N 302-77Registration pendingBuilt 1977N124JLJorge Luis Flores Lizarraga NIEUPORT 17 · S/N 001Lizarraga Jorge Luis FloresN141BLLoogman R L KODIAC · S/N L4Loogman Robert AN1680RCessna R182 · S/N R18200512Built 1978 · Schulze Roger FN16BQBeard Bradley A LANCAIR IV · S/N LIV492Built 2004 · Beard Bradley AN19110Cessna 150L · S/N 15074175Built 1972 · Killebrew Edward LN205CJGeissinger Walter H CJ2V · S/N 205Built 1987 · Aeronautics Education Enterprises IncN2149NDJI AGRAS T40 · S/N 64TBL5A00200PEDanell Rance DanielN221CTFlight Design CTSW · S/N 06-04-13Built 2006 · Stamper JeffN2380QLeading Edge Aerial Tech PV40X · S/N 11444Kings Mosquito Abatement DistrictN2448KPiper PA-38-112 · S/N 38-79A0641Built 1979 · Central Valley Flight School LLCN245BGGwin Bryan D F1 ROCKET · S/N 063Built 2011 · Murphy Daniel DN255MGCostruzioni Aeronautiche Tecna P2006T · S/N 087/USBuilt 2011 · Central Valley Flight School LLCN299DRHughes Helicopters 369E · S/N 196EBuilt 1986 · Kings County Sheriffs OfficeN299KCCessna T206H · S/N T20608177Built 2000 · Kings County Sheriff'S OfficeN4328HMooney M20J · S/N 24-0708Built 1978 · Calabretta Charles JN500LGGates Lear Jet 28 · S/N 005Jet Manager IncN5234XChampion 7ECA · S/N 684Built 1969 · Zonneveld Case MN577KBRaytheon B36TC · S/N EA-668Built 2001 · David A Bush IncN612PZBeech A36 · S/N E-2108Built 1983 · Lovrencevic MarkN6591NCessna T210N · S/N 21063114Built 1978 · Rickey James RN6602RBeech B19 · S/N MB-734Built 1974 · Fagundes FarmsN6688RMooney M20E · S/N 431Built 1964 · Farley ClaytonN6920CMooney M20C · S/N 690065Built 1969 · Kiesel James LN6BQBeard Bradley A LANCAIR 320 · S/N 348-320-57-5PBuilt 1998 · Beard Bradley AN7335WPiper PA-28-180 · S/N 28-1205Registration expired, pending cancellationBuilt 1963 · Whitworth Kenneth WN740WTPiper PA-28R-180 · S/N 28R-31029Built 1969 · Central Valley Flight School LLCN7609JPiper PA-28R-180 · S/N 28R-31001Built 1968 · Mcmaster William TimothyN76VVVandersteen Richard J VELOCITY XL-RG · S/N 3RX118Built 2005 · Vandersteen Richard JN784APHawker Beechcraft B300 · S/N FL-747Built 2011 · Daniel C Salas Harvesting IncN79390Mooney M20C · S/N 2929Built 1965 · Grass Louis Humberto IIIN800GAGates Lear Jet 28 · S/N 003Built 1979 · Gorilla Aviation LLCN8036TBeech A36TC · S/N EA-150Built 1980 · Paysse John GN805KBHawker Beechcraft C90GTI · S/N LJ-1924Built 2008 · David A Bush IncN81715Piper PA-28-161 · S/N 28-8016291Registration pendingN8237TCessna 175B · S/N 17556937Built 1960 · Lamattino Brandon LN823CDCirrus Design SR22 · S/N 0185Built 2002 · Profeta Glen A TrusteeN8342MCessna A150K · S/N A1500042Built 1969 · Streeter Wyatt EN8917PPiper PA-24-260 · S/N 24-4372Built 1966 · Logsdon James CN914RLCessna 182T · S/N 18281399Built 2004 · Nichols Charles CN9425WPiper PA-28-235 · S/N 28-11134Built 1968 · Popejoy Arthur TN946WKLeading Edge Aerial Tech PRECISION VISION 35X · S/N 11127Kings Mosquito Abatement DistrictN9476FCessna 182S · S/N 18280208Built 1998 · F & M Miya LLC
Back to Hanford, CA