OpenAirDocs.org
Ridgecrest, CA

Registered aircraft · 45

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

N1160SSchweizer SGS 1-34 · S/N 60Sierra Soaring ClubN1168BMooney M20J · S/N 24-1303Built 1982 · Vitti TylerN121WTSchleicher ASK-21 · S/N 21524Built 1991 · Kline Clare F JrN126LJAS+ AC 4 · S/N 046Built 1999 · Hudson Peter ON15573Piper PA-28-140 · S/N 28-7325103Built 1972 · Matwiczak Justin MN1562XPiper PA-28R-200 · S/N 28R-7535326Built 1975 · Laliberte Christopher MN1574DCessna 195 · S/N 7796Built 1952 · Williams Marc AN1653QCessna 150L · S/N 15072953Dust Devil Weekend Warriors LLCN2793TBeech V35 · S/N D-8499Built 1967 · Haas Mark AN292ABeech 65-90 · S/N LJ-99Built 1966 · Placebo Air LLCN303SLAmerican Champion 7GCBC · S/N 1201-94Built 1994 · Buffalo Aircraft Maintenance LLCN3091CZautner George W KITFOX III · S/N 1022Built 1993 · Williams Timothy RN3653BBeech C-50 · S/N CH-128Built 1954 · Placebo Air LLCN4072WPiper PA-32-300 · S/N 32-40113Built 1966 · Bradford Alan R JrN4099NMooney M20F · S/N 680174S O Witt And Associates LLCN413HHelmick HP-11A · S/N 48Built 1971 · Helmick Hugh MN45488Luscombe 8A · S/N 2015Built 1946 · Heitkotter ShariN4632JPiper PA-28R-180 · S/N 28R-30519Built 1968 · Mckellar Todd RN46MRCessna T210L · S/N 21060778Built 1975 · Davin MatthewN51EZSpencer Gary/Charlene LONG EZE · S/N 1534Built 1986 · Spencer Gary EN5201TPiper PA-28R-200 · S/N 28R-7235193Built 1972 · Owen Richard DN5722PPiper PA-24-250 · S/N 24-796Built 1959 · Crazy 8 Aviation LLCN573JBBrabec Josef E HP-18 SAILPLANE · S/N 85Built 1983 · Helmick Hugh MN601RBSmith AEROSTAR 601 · S/N 61-0040-77Built 1969 · Bandy Robert WN60865Cessna 150J · S/N 15070631Built 1969 · Breitberg Benjamin DN6182PRaytheon A36 · S/N E-3582Built 2005 · Storch Mark Gerald TrusteeN6203PPiper PA-24-250 · S/N 24-1304Built 1959 · Clark Jason HN623YBSchweizer SGS 1-35 · S/N 38Sierra Soaring ClubN66040Cessna 180K · S/N 18052911Built 1977 · Sierra Auto Recycling IncN6880ECessna 175A · S/N 56380Built 1959 · Bartel Anthony E JrN6936HCessna 172M · S/N 17265652Built 1975 · Quist Donald GN699EECessna T210L · S/N 21061184Built 1976 · Mathes Jay BN7253WPiper PA-28-180 · S/N 28-1081Built 1963 · Gross Matthew AN725CStinson 108-3 · S/N 108-3725Built 1947 · Gotzler Ronald PN7373ECessna 210 · S/N 57073Built 1960 · Quist Donald GN739LBCessna 172N · S/N 17270618Built 1978 · Bandy Robert WN802SLet L-23 SUPER BLANIK · S/N 928002Built 1992 · Sierra Soaring ClubN82FUDJI S1000+ · S/N 03P0011653Enviroplus Consulting IncN8464WPiper PA-28-180 · S/N 28-2702Built 1965 · Wiedemann Shane LN8859BCessna 172 · S/N 36559Built 1958 · Randolph James CN887JBCessna 337B · S/N 337-0559Built 1966 · Bertrand Carolyn LN91385Rodieck RS-15 · S/N 43Built 1978 · Rodieck Ralph WN9219LAmerican AA-1A · S/N AA1A-0119Built 1971 · Hart Gene EN951CCCessna 182Q · S/N 18266998Built 1979 · Brouchoud Jayson R TrusteeN9983BCessna 182A · S/N 34383Built 1957 · Martyn Michael L
Back to Ridgecrest, CA