OpenAirDocs.org
Ione, CA

Registered aircraft · 38

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

N1334HPiper PA-34-200T · S/N 34-7770121Built 1977 · Preskar Michael HN1646EAeronca 7AC · S/N 7AC-5211Swager Joel PN182CMCessna 182R · S/N 18268152Built 1982 · Mccleary Thomas RN19SFHawker MK 11 SEA FURY · S/N 41H656803Built 1947 · Sanders Aircraft IncN20SFHawker SEA FURY TMK 20 · S/N ES-9505Built 1956 · Sanders Aircraft IncN2306Glasflugel KESTREL · S/N 34Built 1971 · Sanders Dennis RN245RVCarey Mark A RV-10 · S/N 40246Built 2006 · Carey Mark AN2503RCessna 182K · S/N 18258203Nicoliei PaulN2583EChampion AERONCA 7AC · S/N 7AC6166Built 1946 · Sanders Dennis RN3010MPiper PA-12 · S/N 12-1709Built 1947 · Atlseimer John CN303FSCanadair T-33 · S/N 342Sanders Smoke Technologies IncN3045FCessna 182J · S/N 18257145Built 1966 · Finley EricN3580North American/Aero Classics P-51D · S/N 44-74602Hovey Scott RN414CMCessna 414A · S/N 414A0472Built 1980 · Martin Livestock LLCN4173BBellanca 17-30A · S/N 75-30792Built 1975 · Beck Nicholas GN41CWLockheed 18-56 · S/N 6124Sanders Dennis RN44816Naval Aircraft Factory N3N-3 · S/N 2989Swager Shannon DN48078Aeronca 0-58B · S/N 058B-11353Built 1943 · Vaughn Macia JN555LJLearjet 24B · S/N 195Beck Angelique VerschuurN5711MCessna 310P · S/N 310P0011Swager Joel PN5900RCessna 172G · S/N 17253569Built 1965 · Aidan HammondN613RCCanadair T33-AN MK3 · S/N 613Built 1958 · S&S Land And Cattle Company LLCN6507XCessna 210 · S/N 57507Built 1960 · Bailey Scott DN668CStinson 108-3 · S/N 108-3668Built 1947 · Beck Nicholas GN7522UCanadian Car & Foundry HARVARD MK IV · S/N CCF4-214Built 1952 · Pay It Forward Aviation LLCN79106Schweizer SGS 2-8 · S/N 57Built 1946 · Sanders Dennis RN813WCessna 140 · S/N 12729Built 1947 · Pay It Forward Aviation LLCN8236Bell 47G · S/N 1333Built 1955 · Horey Scott RN82360Aeronca 7AC · S/N 7AC-993Swager JoelN8370APiper PA-32R-301T · S/N 32R-8129059Built 1981 · Ilich Randy TrusteeN8582UCessna 172F · S/N 17252482Built 1965 · Martin Livestock LLCN89963Cessna 152 · S/N 15282931Built 1978 · Wardall Wesley DavidN9074NGrumman G-21A · S/N B142Sanders DennisN924GHawker SEA FURY TMK 20 · S/N ES8502Built 1954 · Sanders DennisN92836Cessna 182N · S/N 18260382Built 1970 · Clark WyattN92GYGoodyear FG1D · S/N 92304Sanders Smoke Technologies IncN97580Cessna 182Q · S/N 18267137Built 1979 · Wardall Wesley DavidN999XTBeck Nicholas G NXT · S/N 9Built 2012 · Beck Nicholas G
Back to Ione, CA