OpenAirDocs.org
Tehachapi, CA

Registered aircraft · 161

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.

N361KSSchleicher ASK-21 · S/N 21224Built 1984 · Barrett Jane TN3695ZPiper PA-18-150 · S/N 18-7430Built 1961 · Sherrier Mark AN3772VSmith Frank G SONEX · S/N 0348Lowerre Fredric CN3824JCessna 150G · S/N 15065124Built 1966 · Balcsik Christopher AN3894ASchweizer SGU 2-22C · S/N 59Martin Ronald PN3908ASchweizer SGS 1-23H · S/N 45Gingras John TN39573Aeronca 65-CA · S/N CA18472Martin Ronald PN400MJPiper PA-23-160 · S/N 23-1627Haney Michael WN4119FCessna 172 · S/N 46019Built 1958 · Plymate Claude LN41ADAerovodochody L-29 DELFIN · S/N 893141Built 1968 · Riley JacobN4207EPiper PA-38-112 · S/N 38-78A0489Built 1978 · Dohnke Frederick WilliamN420ZBBeech A36 · S/N E-1765First renewal noticeBuilt 1980 · Adaptive Aerospace CorpN421SLSchleicher ASK-21 · S/N 21808Built 2006 · Barrett Jane TN424DBSchleicher ASW-24B · S/N 24255Built 1998 · Laningham BillN430TLDuffy Thomas J LONG EZ · S/N 66First renewal noticeBuilt 1985 · Agold Terry GN43550Piper PA-28-151 · S/N 28-7415521Built 1974 · Browning Neil GN4362YPiper PA-25-235 · S/N 25-4868Built 1969 · Barrett Jane TN437DCCahoon David W RV-4 · S/N 1607Roslansky James JosephN4386KRyan NAVION · S/N NAV-4-1386Built 1949 · Machen Scott TN447RGGillespie Robbie HIMAX 1400Z · S/N 937Built 2011 · Lowerre Fredric CN44EBGlasflugel STD LIBELLE 201B · S/N 379Kreigh Daniel TN454YJoshua Dace Knerr FRANKLIN PS-2 JDK · S/N 115Built 2023 · Knerr Joshua DN4603RPiper PA-28-140 · S/N 28-21351Built 1965 · Radcliff Rocky J SrN461RPPaisley Robert RV7 · S/N 70155Shane Hugh AN4658ACessna 180 · S/N 32255Built 1956 · Lerner Michael MN474JBBrick John VANS RV-4 · S/N 3958Built 2005 · Reitz Brian CN4814YPiper PA-25-260 · S/N 25-4597Knerr Joshua D DBAN48DGGugeler Donald R STEEN SKYBOLT · S/N DRG-2Built 1987 · One Flight USA IncN492XARolladen-Schneider LS-1C · S/N 212Gingras JohnN4EJWhite Roger G GLASAIR FT · S/N 265Alvarez Juan MN500AWCessna T310R · S/N 310R0077Mcnulty Kim EN5198UCessna 206 · S/N 206-0198Built 1964 · Ferguson Kenneth RN52304Cessna 182P · S/N 18262516Built 1973 · Haney Michael WN5262LPiper PA-28-180 · S/N 28-4560Built 1967 · Williams Gregory LN5499YSjostedt Rob J 15 METER · S/N SX-3Sjostedt Rob JN54VVStuwe Werner RV 4 · S/N 3030Built 1996 · Voutour Ryan RN555ABSchleicher ASH-25E · S/N 25041Built 1992 · Knerr Joshua DN56599Piper J4E · S/N 4-1612Built 1941 · Hetge Kenneth RN57325Piper PA-28R-200 · S/N 28R-7435081Built 1973 · Baker Ken CN59688Schweizer TG3A · S/N 25Built 1942 · Knerr Joshua DN59GWSchempp-Hirth VENTUS-B · S/N 129Built 1983 · Walker Scott GN5TDPurdy / Weekes DRAGONFLY · S/N 778Built 1991 · Quinn Jeff GN6058LAmerican AA-5 · S/N AA5-0158Built 1972 · Mccune William DN607VBeech 35-33 · S/N CD-88Built 1960 · Wright Kenneth CN61268Boeing A75N1(PT17) · S/N 75-3259Built 1942 · Mosher Dustin TN6136CForney F-1 · S/N 5607Built 1956 · Regan Corey JN61636Laister-Kauffman LK-10A · S/N 86Knerr Joshua DN632BBeech J35 · S/N D-5367Built 1957 · Bickers KevinN6336William R Briegleb BG-6 · S/N 36Built 2013 · Knerr Joshua DN633GGGordon Gus G THORP T-18 · S/N 1098Built 1985 · Biviano Joseph John
Back to Tehachapi, CA