Registered aircraft · 46

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'COTTONWOOD' ORDER BY g.n_number

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

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 = 'COTTONWOOD'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N10773Cessna 150L · S/N 15075026Built 1973 · Cole Clayton R N167ECCollier Everett M PULSAR · S/N 167First renewal noticeBuilt 2009 · Collier Everett M N1916Cessna 182P · S/N 18263299Built 1974 · Rauser Richard A Trustee N26543Taylorcraft BL-65 · S/N 1884Built 1940 · Mcconnell Wayne L N285Cessna T337G · S/N P3370228Built 1975 · Crawford Geoffrey E N310KBWilson Jeffrey B VANS AIRCRAFT RV-6 · S/N 20948Built 1996 · Schulte Delmar L N31284Bellanca 7GCBC · S/N 411-72Built 1972 · Allen Earl R N3337RWebb James A RV-4/ROCKET · S/N 333Built 1997 · Spoon Eric T N3458TCessna 177 · S/N 17700758Built 1968 · Brown Lance D N3843EAeronca 11AC · S/N 11AC-S-51Built 1947 · Joyce Chantz N3858SCessna 172E · S/N 17251058Built 1963 · Dearman Daniel R Sr N396RVMichael Tripe THE FLYING TURD · S/N 001Tripe Michael D N39ZZLarry Lawrence Black BLACK STORMER-S · S/N 20141939-2Built 2015 · Black Larry L N400SKCessna 172H · S/N 17256077Built 1967 · Cappello Dave A N4353TThomas Robert E RV-6 · S/N 20117Jones Charles E Jr N470JSBigham Jack L & Colleen R STARDUSTER TOO SA300 · S/N 470Built 1980 · Short Jeffery G N49500Piper J3C-65S · S/N G-3Built 1942 · Chain Steven R N4971FCessna 172N · S/N 17273110Registration pendingBuilt 1979 N5395KNavion NAVION B · S/N NAV-4-2295BBrown Mark S N542EZHopelain/Rice LONG-EZ · S/N 80Lesher Caleb J N548KKRaytheon 400A · S/N RK-151Built 1997 · Blue Hawk Co LLC N5508VPiper PA-28R-201T · S/N 28R-7703129Delaney John J N58182Cessna 182A · S/N 51222Built 1958 · Gregory Jess R N585YCSteven Chain REHAWK 500 · S/N 0100Chain Steven N585ZCSteven Chain REHAWK 680 · S/N 0200Chain Steven N6013HPiper J3C-65 · S/N 19151Built 1946 · Jones Charles E Jr N601LGGingell Lance ZODIAC 601 XL · S/N 6-5428Built 2005 · Gingell Lance N6310NChampion 7ECA · S/N 463Built 1967 · Humbert Jeff M N6360ACessna 182 · S/N 33160Built 1956 · Claiborne Howard N6UZKrueger Arthur G SONEX · S/N 0095Built 2005 · Krueger Arthur G N700TJSocata TBM 700 · S/N 27Herrmann Holdings Inc N70831Piper J3C-65 · S/N 17849Built 1946 · Jones Charles E N714DPCessna 150M · S/N 15079098Built 1976 · Delaney John N7347PPiper PA-24-250 · S/N 24-2525Built 1961 · Van Eyck Christopher N7397ACessna 172 · S/N 29497Built 1956 · Willems Scott F N742GGingell Lance RV-7A · S/N 73239Built 2011 · Gingell Lance N7513XCessna 172B · S/N 17248013Built 1960 · N7513x LLC N7738ECessna 150 · S/N 17538Built 1959 · Krueger Arthur G N789LPablo Martinez Ejarque HELIPABLO A · S/N 2-04Ejarque Pablo Martinez N8259GCessna 172N · S/N 17273619Cappello Dave Allen N828JLBell 47G-3B-2 · S/N 7687Martinez Ejarque Pablo N8579TCessna 182C · S/N 52479Built 1960 · Goldschmidt Scott N906WFPiper PA-28-140 · S/N 28-7125163Built 1971 · Papesh Sandra J N937QBeech 35-B33 · S/N CD-394Humbert Jeffery Michael N95PFCessna 182 · S/N 18265281Ehorn William M N985SRPilatus PC-12/47G · S/N 3042Built 2026 · Walnut Street 738 LLC

Back to Cottonwood, CA