OpenAirDocs.org
Bishop, CA

Registered aircraft · 46

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

N11GVGlasflugel H 301 LIBELLE · S/N 6Built 1965 · Grah David BN1238VFleet FLEET 16B · S/N 512Built 1948 · Philbrick Rodney CN144DBBrackett Dennis KITFOX IV · S/N 1528Built 1995 · Milliron Curtis WN1598BCessna T182 · S/N 18268108Built 1982 · Timerider Technologies IncN16433Piper PA-28-140 · S/N 28-7325271Built 1973 · Pn4 Aviation Holdings LLCN1659BLuscombe 11A · S/N 11-165Built 1948 · Philbrick Rodney CN1876MCessna 182P · S/N 18264463Built 1975 · Tracy Peter EN2034RPiper PA-28-180 · S/N 28-5439Built 1969 · Pn4 Aviation Holdings LLCN2068ZCessna 150C · S/N 15059868Built 1963 · Thompson Jeffrey AN211KAKlinefelter Kevin James EUROPA XS · S/N 01Klinefelter Kevin JN2486CCessna 180 · S/N 30786Built 1954 · Armstrong Patrick TrusteeN2491MPiper PA-12 · S/N 12-1698Built 1947 · Pope Geoffrey MN2883YPiper PA-34-200T · S/N 34-7970327Nimmo PhilipN3010YPiper PA-28RT-201T · S/N 28R-7931151Built 1979 · Pn4 Aviation Holdings LLCN324JWGulfstream American G-1159A · S/N 324Built 1981 · Vip Jet Transportation IncN3530Draganfly Innovations X4ES · S/N 8B8743Great Basin Unified ApcdN39DNAircraft Mfg & Development CH601XL SLSA · S/N 601-031SBuilt 2007 · Davis Steven CN4218PPiper PA-23-160 · S/N 23-1711Pn4 Aviation Holdings LLCN4388VCessna 195 · S/N 7310Built 1949 · Philbrick Rodney CN44JRRodgers Jerry/Gaust Gregory RV-6 · S/N 24545Built 1997 · Rodgers Jerry TN456YAAndrew Bell BEARHAWK LSA · S/N 31-72/73Built 2025 · Bell Andrew RN4797UCessna TU206G · S/N U20605108Built 1979 · Philbrick Rodney C DBAN4825FCessna TU206A · S/N U206-0525Built 1966 · Lober Richard MN4863BCessna 310 · S/N 35163Built 1955 · Beach Travis WN5153RCessna TR182 · S/N R18200637Built 1978 · Vogel Todd JN5348LPiper PA-28-180 · S/N 28-4651Pn4 Aviation Holdings LLCN534MAPiper PA-34-220T · S/N 3449278Built 2003 · Pn4 Aviation Holdings LLCN5546ECessna 150 · S/N 17046Built 1958 · Rosenthal John SN5592CCessna 170A · S/N 19821Built 1950 · Grah David BN5629NMaule M-5-235C · S/N 7216CBuilt 1978 · Dusaint Jonathan EN5646UPiper PA-28-140 · S/N 28-26442Pn4 Aviation Holdings LLCN64DCPiper PA-28R-201T · S/N 28R-7703397Built 1977 · 64dc LLCN696HZDraganfly Innovations DRAGANFLYER COMMANDE · S/N 33EAFDGreat Basin Unified ApcdN70ZZFlight Design CTLS · S/N F-12-05-05Built 2013 · Clark Dolphe SN71164Cessna 182M · S/N 18259516Built 1968 · Core Jerry MN737QHCessna TR182 · S/N R18200873Built 1979 · Philbrick Rodney C DBAN756UBCessna TR182 · S/N R18201156Built 1979 · Sayer WayneN758AJCessna R172K · S/N R1722939Built 1978 · Holman DavidN777XTWright Dan NXT · S/N 1-BBuilt 2005 · Beach Travis WN7914RBeech V35A · S/N D-8943Built 1969 · Frith Smith Michael JN807BFIsrael Aircraft Industries 1124 · S/N 194Sale reportedBuilt 1976N8337APiper PA-28-236 · S/N 28-8111051Built 1981 · Pn4 Aviation Holdings LLCN881ZPPergande Mark A SONEX · S/N 0542Built 2020 · Nix Brian TN89600Cessna 152 · S/N 15282801Built 1978 · Philbrick Rodney C DBAN933KNNorth Wing Uum SCOUT XC · S/N E9035Built 2022 · Kent CliveN9499BBradley S Wyatt WYATT VANS RV-9 · S/N 90631Built 2012 · Wyatt Bradley S
Back to Bishop, CA