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.

N6403DOwens William T KR2S · S/N 220Roslanksky James JN647TFVans RV-12IS · S/N 121099Built 2020 · Hbfc IncN653AMAircraft Mfg & Development CH601XL SLSA · S/N 601-034SMcguire Timothy LN6568KRepublic RC-3 · S/N 838First renewal noticeSandy George TN65824Schweizer SGS 2-33A · S/N 304Built 1973 · Barrett Jane TN658KASchleicher K 8 B · S/N 8497Knerr Joshua DN65GBSegelfluggrupe GRUNAU BABY IIB · S/N 6Knerr JoshuaN660FLHawker Beechcraft B300 · S/N FL-660Dandy ThomasN662ESInterplane SKYBOY · S/N AS-001Built 2002 · Pinnell Kim JN66CXPatterson David L CASSUTT 3M · S/N 11166Built 2001 · Mack Andrew MN6738KRepublic RC-3 · S/N 1026First renewal noticeBuilt 1947 · Sandy George TN6821VAerostar Acft Corp Of Texas M20C · S/N 20-0003Miller Titan GN6857ZPiper PA-25-235 · S/N 25-2538Built 1963 · Barrett Jane TN69GGTaylorcraft F19 · S/N F-067Built 1976 · Mosher Dustin TN69VWDavid M Nelson DAVID M NELSON VP-1 · S/N 1Sale reportedBuilt 2020N7003Laister Sailplane Products LP-49 · S/N 12Built 1968 · Martin J CampbellN7014ZPiper PA-25-235 · S/N 25-2768Built 1964 · Barrett Jane TN70633Cessna 182M · S/N 18259333First renewal noticeBuilt 1968 · North County Flying ClubN7065YMartin Helen Tabor RIDGE RUNNER · S/N 101Samuelian PhilipN717UPNorth American T-6G · S/N 49-3529ABuilt 1949 · Vanhoy David LN71EMSchempp-Hirth DISCUS 2A · S/N 6Built 1998 · Grandstaff Sylvia CN71WFCessna R182 · S/N R18200618Robins David MN7224FPiper PA-28-140 · S/N 28-25136Biviano Joseph JN72791Cessna 140 · S/N 9977First renewal noticeBuilt 1946 · Anderson Wayne GN727HCLyons Harold A VANS RV7 · S/N 71540Built 2008 · Meyer Robert R JrN735ZVCessna 182Q · S/N 18265823Built 1977 · Wilhelm James SN7588Schweizer SGS 2-33A · S/N 190Built 1970 · Barrett Jane TN7687BBellanca 14-19-2 · S/N 4038First renewal noticeBuilt 1957 · Roberts James D TrusteeN7703ZPiper PA-25-235 · S/N 25-3863Built 1966 · Barrett Jane TN799LWPiper PA-24-180 · S/N 24-2868Built 1961 · Koszyk Jerry AN7PNNafziger Paul A LANCAIR 320 · S/N 001Built 2002 · Nafziger Paul AN8038CPiper PA-22-135 · S/N 22-2225French Christopher KN80569Globe GC-1A · S/N 72Samuelian Stephen PN8155PPiper PA-24-250 · S/N 24-3410Built 1963 · Sanders Tyler GeorgeN818VMPiper PA-22-150 · S/N 22-3357Built 1955 · Reitz Brian CN827GSSharp Gary A RV-6A · S/N 23646Fosha KathrynN8300KStinson 108-1 · S/N 108-1300Bauman Jennifer NN83MZZeitlin Marc J COZY MKIV · S/N 386Built 2002 · Zeitlin Marc JN84325Aeronca 7AC · S/N 7AC-3019Built 1946 · Machen Scott TN8524XCessna P172D · S/N P17257124Built 1962 · Pedroza Everett WN865DSMcallister David E VANS RV-6 · S/N 23947Built 2018 · Mcallister David EN86GPAerotek PITTS SPECIAL S-1S · S/N 1-0011Built 1973 · Nichols Clint TN8709RSchempp-Hirth SHK1 · S/N 05Built 1965 · Knerr Joshua DN88499Piper J3C-65 · S/N 16123Built 1946 · Lawthers William TN888EZKreidel/Kreidel LONG EZ · S/N 564Built 1983 · Rabideau Jacob NN88KLAdams Dennis Allen VARIEZE · S/N 1644Built 1983 · Rybczynski Douglas RN88VSSchleicher ASW-20C · S/N 20863Built 1987 · Grubb Mark DN90612Prue Irving O 215-A · S/N 1Knerr Joshua DN9063PPiper PA-24-260 · S/N 24-4530Built 1966 · Davis Clyde Jackson Jr TrusteeN9156LBellanca 7ACA · S/N 17-71Built 1971 · Lerner Michael M
Back to Tehachapi, CA