OpenAirDocs.org
Petaluma, CA

Registered aircraft · 93

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

N1036MCessna 172S · S/N 172S10599Built 2007 · Mangon Aircraft IncN107PTCessna 525B · S/N 525B0127Built 2006 · Papa Tango LLCN113LRRotorsport UK ROTORSPORT UK CAVALO · S/N RSUK-V00428Built 2019 · Cierva Service LLCN11CWPiper PA-28R-201 · S/N 28R7737079Built 1977 · Jabez Aviation LLCN122PGBeech 95-55 · S/N TC-149Built 1961 · Mcgaw Thomas DN136MPMooney M20L · S/N 26-0016Benjamin Freelove Aerobatics LLCN137KTHeckman Harry H LANCAIR 235 · S/N 205Built 1997 · Crowther MichaelN159TBCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 086Built 2006 · Young Christopher TrusteeN1601Stecher Joe STECHER RV-6A · S/N 20588Built 2004 · Moretti Warren RN167CWSmith Harold M SMITH-VANS RV-6A · S/N 1001Built 2002 · Norinsky DavidN181TCPiper PA-28-181 · S/N 28-7990324Built 1979 · Dezendorf Thomas CN1978JMooney M20J · S/N 24-0563Built 1978 · Jasinski David W TrusteeN21XAX-Air XA85 · S/N XA850007Built 2010 · Jones Marlin LN221GSCessna T182T · S/N T18208034Built 2001 · Barientos Bryan IN241JEJanzen F/Enns D RV-6A · S/N 23868Built 2001 · Smedshammer Paul JN246GSTextron 525C · S/N 525C0275Built 2018 · Golden State Lumber IncN247AVArcturus Uav JUMP 20 · S/N 132805_100021Arcturus Uav IncN249AVArcturus Uav JUMP 20 · S/N 132805_100022Arcturus Uav IncN249WSCirrus Design SR22 · S/N 0975Built 2004 · Smith Charles L IIIN251AVArcturus Uav JUMP 20 · S/N 132805_100023Arcturus Uav IncN253AVArcturus Uav JUMP 20 · S/N 132805_100024Arcturus Uav IncN254AVArcturus Uav JUMP 20 · S/N 122708_100005Arcturus Uav IncN257AVArcturus Uav JUMP 20 · S/N 122708_100006Arcturus Uav IncN258AVArcturus Uav JUMP 20 · S/N 122708_100007Arcturus Uav IncN270AVArcturus Uav JUMP 20 · S/N 137086_100001Arcturus Uav IncN27192Piper J3C-65 · S/N 4426Built 1940 · Kreloff Richard LN2809ESocata TB-20 TRINIDAD · S/N 1141North Marin Air LLCN28631Grumman American Avn. AA-5B · S/N AA5B0712Built 1978 · Perry Colin CN289RTCessna 525A · S/N 525A-0093Jp Aviation LLCN291AVArcturus Uav JUMP 20 · S/N 118903_100028Arcturus Uav IncN292HPPiper PA-28-181 · S/N 2843587Built 2004 · Missimer N292hp LLCN295AVArcturus Uav JUMP 20 · S/N 118889_100104Av IncN296AVArcturus Uav JUMP 20 · S/N 118889 100125Av IncN320GCPiper PA-39 · S/N 39-60Built 1970 · Nordquist Mark ON32NVGoddard Tom/Goddard Peter GLASAIR III · S/N 3378Built 2006 · Ringvold Martin PN3422TCessna 177 · S/N 17700722Built 1967 · Mangon Ronald AN36483Taylorcraft BC12-D · S/N 6412Built 1945 · Kreloff Richard LN3849VCessna 170A · S/N 18736Paulas DanielN39DUSouthern Aero Sports VANS RV-6 · S/N 22818Yokoo KurehaN41MTCessna 182Q · S/N 18265725Built 1977 · X2nsat IncN42358Piper PA-28-140 · S/N 28-7425314Built 1974 · Bakker Margaret E TrusteeN423CDCirrus Design SR22 · S/N 1109Grzebik Ellerine PN42PTBoeing A75N1(PT17) · S/N 75-8387Built 1943 · Woods Michael JN4371FPiper PA-32R-300 · S/N 32R-7680443Built 1976 · Spongberg Paul FN454DMCessna TR182 · S/N R18201162Built 1979 · German George DerlinN4586SBeech V35B · S/N D-9809Built 1975 · Ejh Teton Properties LLCN460JPManojcher Adli LANCAIR · S/N L2K-204Built 2003 · Newman CharlesN469YStinson SM-8A · S/N M-4277Built 1930 · Myburgh Hendrick TN46AJCressey John DR-107 · S/N 94-0155Built 1998 · Posson John L TrusteeN4888LCessna 152 · S/N 15284239Built 1980 · Ashton Marc J
Back to Petaluma, CA