OpenAirDocs.org
La Quinta, CA

Registered aircraft · 26

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 = 'LA QUINTA'
  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.

N10167Mooney M20K · S/N 25-0563Built 1981 · Sterling Air LLCN109YKYakovlev YAK 52 · S/N 811510Built 1981 · Gilbert William ON160TXGrumman American Avn. AA-5A · S/N AA5A-0143Built 1976 · Stark Micah SN17927Schweizer SGS 1-26E · S/N 561Schwemmer RichardN2036RCessna 182G · S/N 18255236Built 1964 · Elsing Myles HN366CCRaytheon B300 · S/N FL-366Conquest Logistics IncN3670EBeech 58TC · S/N TK-124Built 1980 · Fresh-Pic Harvest IncN392EAPipistrel D O O ALPHA TRAINER · S/N AT162A0002Built 2025 · Socal Pilot CenterN397EAPipistrel D O O ALPHA TRAINER · S/N AT162A0004Built 2025 · Socal Pilot CenterN428EAPipistrel D O O ALPHA TRAINER · S/N AT162A0031Socal Pilot CenterN446CSTextron 172S · S/N 172S12001Built 2017 · Socal Pilot CenterN449TTPiper PA46R-350T · S/N 4692163Built 2011 · Gen2 Ventures LLCN456HLHakan Langebro RV-7A · S/N 72282Built 2013 · Crawford Clark W TrusteeN4715WCessna P210N · S/N P21000624Built 1980 · Kelley Christopher LN58HEBeech 58TC · S/N TK-59Built 1977 · Soaring Ventures LLCN6028UCessna T182T · S/N T18208538Built 2006 · Desert Sky Aviation LLCN6046RCessna T182T · S/N T18208577Ids IncN6229CCessna T210N · S/N 21063838Built 1979 · Clause James W TrusteeN641THTextron 172S · S/N 172S12641Built 2021 · N641th CorpN6616ZDJI DA2SUE1 · S/N 2020AP13784Zachman James AN688MDMooney M20TN · S/N 31-0017Built 2007 · Diamond Aero CorpN713AADJI AGRAS T40 · S/N 64TBK8L00100RSJunior Enterprises LLCN764DCKFC Montana 2024 RISEN · S/N 36Built 2024 · Currier CarolynN76534Cessna 120 · S/N 10970Built 1946 · Shilling EricN78328Temco GC-1B · S/N 2328Bucklar Construction CoN8402WPiper PA-28-180 · S/N 28-2616Built 1965 · Anderson Thomas
Back to La Quinta, CA