OpenAirDocs.org
Lafayette, CA

Registered aircraft · 31

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

N1115BLuscombe 8F · S/N 5742Bradley Lawrence AN1373BSilvaire LUSCOMBE 8F · S/N 6000Built 1948 · Chaffey George E TrusteeN1478YCessna 172C · S/N 17249178Built 1962 · Cunningham Richard EN1512BLuscombe 8F · S/N 6139Bradley Larry AN1ZPBeech A36 · S/N E-262Built 1971 · Concord Flying Club IncN220KFKevin L Olson KITFOX S7 STI · S/N KA21265516Olson Kevin LN2646LArbc Inc DBA Lindstrand 90A · S/N 5526Built 2013 · Michalek GaryN2701TBeech V35 · S/N D-8436Gray Stephen TN272DDDiamond Aircraft Ind DA 62 · S/N 62.C053Built 2023 · 2dd Aviation LLCN278JPiper PA46-500TP · S/N 4697127Built 2002 · Larkin Matthew WN313PGriff Richard E RV-7A · S/N 70837Built 2006 · Concord Flying Club IncN320SSinclair W Robert LANCAIR L-320 · S/N 368-320-124-14PBuilt 2000 · Sinclair William RobertN37789Schuldt VOLKSPLANE-I · S/N ESVP-1Built 1977 · Schuldt Eric RN390VGKubicek Factory S R O BB26Z · S/N 2035Built 2022 · Michalek Gary LN39SGRolladen Schneider LS-8A · S/N 8219Built 1998 · Guerin MarianneN425PMStemme STEMME S 12 · S/N 12-038Built 2021 · Mcwhirter PaulN4269LCessna 172G · S/N 17254338Built 1966 · Bussey StuartN42720Raven S55A · S/N S-55A321Built 1977 · Elliott Thomas J IIIN4449Henry Steven L KITFOX III · S/N 81HBS048Cunningham Richard EN510ARCessna 182R · S/N 18267733Built 1981 · Brudigam NormanN52563Cessna 182P · S/N 18262677Built 1973 · Concord Flying Club IncN533BGSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 533Built 2007 · Guerin MarianneN577MCCessna 550 · S/N 550-0861Built 1998 · Ultraa Air LLCN58PHHuddleston Ed/Poor Robert L PITTS S-1S · S/N 7-0359Olson Kevin LN61LPBeech A36 · S/N E-1807Built 1981 · Rossetter EricN66HDAlexander Schleicher ASW 27-18 E · S/N 29734Built 2017 · Guerin MarianneN77114Cessna 140 · S/N 11572Built 1946 · Bowers Byron LN783MKCirrus Design SR22T · S/N 1921Built 2019 · Dove Si Trova La Stazione Di Tren LLCN91420North American NAVION A · S/N NAV-4-82Built 1946 · Bradley Larry AN925LLTextron T182T · S/N T18209174Built 2025 · Sutton-Gee RyanN927DCBeech V35B · S/N D-9855Built 1976 · Ciruli David E
Back to Lafayette, CA