OpenAirDocs.org
Bakersfield, CA

Registered aircraft · 372

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

N100VTDJI AGRAS T100 · S/N ASHCN9U001075KPunelli Eugene CN1011Cessna T210N · S/N 21064004Built 1980 · Martin Rex L TrusteeN1011TBellanca 7ECA · S/N 863-72Built 1972 · Pedersen MichaelN103WTTatham Willard M MITCHELL U-2 · S/N 175Schultz ToddN109MDBeech B200 · S/N BB-1213Built 1985 · M B Duncan IncN121SBBookout Brent AVID MKIV · S/N 1029DBuilt 1996 · Bookout BrentN122RCCessna T210K · S/N 21059298Curtis Alvis JrN12365Cessna 172M · S/N 17261950Built 1973 · Singh JaganpreetN124WDAmerican Champion 7GCAA · S/N 444-2000Built 2000 · Kcsi Aerial Patrol IncN128AHIniziative Industriali Italian SKY ARROW 600 SPORT · S/N LSA004Frazier Vicki LN1322ZTextron T182T · S/N T18209134Built 2024 · International Realty Group LLCN133MBeech 35 · S/N D-557Golden Age Flight MuseumN136KCBeech A36 · S/N E-1373Built 1978 · Prescribed Agriculture Services IncN141JGCessna 177 · S/N 17700930Built 1968 · Cardinal 1jg LLCN145GKVans RV-12 · S/N 120382Built 2011 · Sigrest Edwin DN148PRBeech V35 · S/N D-8580Built 1967 · Jaspar Dorsey EN1497GBeech P35 · S/N D-6936Built 1962 · Diaz Jose RN15233Waco CUC-1 · S/N 4318Built 1935 · Waco Cuc-1 LLCN157BBell 47D1 · S/N 11Built 1947 · Lewis Gerald KN159TMAmerican Champion 7GCAA · S/N 462-2002Built 2002 · Kcsi Aerial Patrol IncN15WMCessna 340A · S/N 340A0523Sidhu Teg SinghN1633RGrumman American Avn. AA-1B · S/N AA1B-0633Lawrence Guy AN16410Piper PA-28-140 · S/N 28-7325266Built 1973 · Cherokee Five LLCN16580Waco YKS-6 · S/N 4518Built 1936 · Hendrix Todd MN1687BLuscombe 11A · S/N 11-193Built 1949 · Dendrix Todd MN172PKCessna 172N · S/N 17273616Built 1979 · Kcsi Aerial Patrol IncN175LBeech A36 · S/N E-985Built 1977 · Kern Charter Service IncN1776DCessna 170A · S/N 20219Built 1951 · Robbins Flight Training LLCN177KACessna 177RG · S/N 177RG1139Built 1977 · Rosenthal PhilipN17873Schweizer SGS 2-33A · S/N 243Peterson AdamN185JMCessna A185E · S/N 18501685Built 1970 · Silicz JacobN1902DJI AGRAS T50 · S/N 1581F6BUB246Q001MEBYSunridge Nurseries IncN191JWJames P Watkins HARMON ROCKET II · S/N 0269Built 2015 · Watkins James PN194RJPiper PA-28-180 · S/N 28-2760Built 1966 · Smith Collin CN1956Cessna 310 · S/N 35337Built 1956 · Sturges George S JrN197NDAmerican Champion 7GCAA · S/N 409-98Built 1998 · Kcsi Aerial Patrol IncN19HXBell 206L-3 · S/N 51096Built 1984 · Premier Aircraft Services LLCN19REBeech F33A · S/N CE-299Built 1970 · Etcheverry Ray LN20039Cessna 172M · S/N 17260952Built 1972 · Kcsi Aerial Patrol IncN200JLBeech 200 · S/N BB-40Built 1975 · Crest Trading CompanyN2036ESmith Paul F RAF 2000 · S/N H2-23-95Cobar Alexis RN204JBBell UH-1B · S/N 63-13088Built 1963 · Premier Aircraft Services LLCN2052TSchweizer SGS 2-33A · S/N 497Peterson AdamN206AZCessna T206H · S/N T20609176Built 2015 · Grant Investments LLCN210TJCessna T210N · S/N 21063948Built 1980 · Jaco Oil CompanyN2118JCessna T182T · S/N T18208238Built 2004 · Lamb Chops IncN2133WBeech F33A · S/N CE-502Built 1974 · Beck Robert MN21396Cessna 182P · S/N 18261609Built 1972 · Greers Banner Air Of Bakersfield IncN21598Cessna 182P · S/N 18261742Built 1973 · Kcsi Aerial Patrol IncN2161CCessna 195B · S/N 16146Built 1954 · Hendrix Todd M
Back to Bakersfield, CA