OpenAirDocs.org
Tehachapi, CA

Registered aircraft · 163

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

N1082EAeronca 7AC · S/N 7AC-4635Built 1946 · Knerr Joshua DN1091ZLittle Toot FL · S/N 1Built 1967 · Stinemetze Matthew WN114RBBower Rod STARDUSTER TWO · S/N BOWER-001Sjostedt Robbie JN117CGGould Cedric O GOULD COZY MKIV · S/N 1515Built 2023 · Gould Cedric ON1266SCessna 182P · S/N 18264834Built 1976 · Barton Jonathan EN12745Cessna 172M · S/N 17262224Built 1974 · Gutierrez Benito EN128MMCloyd Paul C GLASAIR SH-2 · S/N 477RBird Cory RN1355Glasflugel STANDARD LIBELLE · S/N 27Built 1968 · Knerr Joshua DN1363ZBeech N35 · S/N D-6787Built 1961 · Mccune William DN1482YCessna 172C · S/N 17249182Built 1962 · Samuelian Jenna AN14DYYarbro SCHREDER HP-14 · S/N 95Built 1981 · Hutchison Mason MN1580ZBeech P35 · S/N D-6879Built 1961 · Liebmann Christopher JN16064Cessna 150L · S/N 15073451Built 1972 · Wyatt Scott AN161SEAmerican Champion 8KCAB · S/N 1027-2006Built 2006 · Oquinn Timothy MN17888Schweizer SGS 2-33A · S/N 258Registration pendingBuilt 1972N178EZStinemetze Matthew DEJA-VU · S/N 001Built 2007 · Stinemetze Matthew WN17916Schweizer SGS 1-26E · S/N 560Built 1973 · Wheaton Duane LeeN1811WSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 262Built 2000 · Morgan RobertN18997Laister-Kauffmann BOWLUS BA-100 · S/N 106Knerr Joshua DN18LGlasflugel H 301 LIBELLE · S/N 39Built 1966 · Martin J CampbellN194PGlasflugel STANDARD LIBELLE · S/N 217Built 1971 · Bauman JenniferN1951Bowlus BA-100 · S/N 168Knerr Joshua DN195RRiordan James F RANS S-9 · S/N 0806201Built 2008 · Bickers Kevin TN1988VCessna 120 · S/N 14199Built 1947 · Mosher Dustin TN19BPTehachapi Society Of Pilots CH750 CRUZER · S/N 001Built 2021 · Tehachapi Build-A-Plane IncN19LBCessna T210N · S/N 21064705Built 1982 · Sanders Brian LN20NTSchleicher ASW-20 · S/N 20275Built 1979 · Sanders Tyler GN21WVVogel Walter VELOCITY RG · S/N 02Built 1992 · Howell JeffreyN229RDAlexander Schleicher ASW 27-18 · S/N 29060Thomson Mitchell DeanN2372APiper PA-38-112 · S/N 38-78A0661Built 1978 · Oquinn Timothy MN241STBird Cory 001 · S/N 001Built 2003 · Bird Cory RN24MRSchleicher ASW-24 · S/N 24082Alonso Oscar SN27078Piper J4A · S/N 4-1009Built 1940 · Martin Ronald PN271JSSchleicher ASW-27 · S/N 27035Built 1996 · Armstrong Daniel JN2745HSchweizer SGS 2-33A · S/N 525Built 1978 · Barrett Jane TN2775KLuscombe 8E · S/N 5502Built 1947 · Sanders Brian LN2792NCessna 120 · S/N 13053Built 1947 · Sanfillipo Leah MN2843ACessna 180 · S/N 30043Built 1953 · Knerr Joshua DBAN29416Aeronca 65-TC · S/N 3080TBuilt 1940 · Martin Ronald PN2TTOsenga James H RV 4 · S/N 1Built 1988 · Lawthers William TN30267Grau Henry A CASSUTT MODEL IIIM · S/N LA 9Built 2008 · Odell John PN307EZTifft Frank A LONGEZE · S/N 218Built 1982 · Williams Guy WN30CDAerovodochody L-29 DELFIN · S/N 194340Registration pendingBuilt 1971N30HANorth American AT-6B · S/N 847412Smokemaster LLCN3143ELasiter Charles E KITFOX · S/N 857Built 2025 · Gingras John TN3232CBeech E35 · S/N D-3897Built 1954 · Brooks Michael BN33138Piper PA-28-140 · S/N 28-7525161Built 1975 · Ables John MN331JSAlexander Schleicher ASH 31 MI · S/N 31038Built 2011 · Staniforth James AN34292Schweizer SGS 2-33A · S/N 412Registration pendingBuilt 1975N344HHuddleston Henry S VAN GRUNSVEN RV-4 · S/N 344Biviano Joseph J
Back to Tehachapi, CA