OpenAirDocs.org
La Verne, CA

Registered aircraft · 52

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 VERNE'
  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.

N137RJCessna 172S · S/N 172S8296Built 1999 · Uaa International IncN1727DCessna 170A · S/N 20170Hall L RobertN179DSDiamond Aircraft Ind DA 40 · S/N 40.279Built 2003 · Wright Brother Aviation LLCN181RJPiper PA-28-181 · S/N 28-8190106Built 1980 · Uaa International IncN195YCessna 195 · S/N 7629Built 1951 · Young Kenneth DN196RERemos G-3/600 · S/N 196Big Red Riding Hood LLCN205TKBell 205A-1 · S/N 30131Built 1973 · Coastal Helicopters LLCN212MAPilatus PC-12/47E · S/N 2432Built 2025 · Saurenman Aviation LLCN2505LCessna 172H · S/N 17255705Built 1966 · Cannon Jason PN25976Cessna 152 · S/N 15280890Skylogix Aircraft LLCN286GBell 407 · S/N 53042Built 1996 · Jambb LLCN2900ZPiper PA-22-160 · S/N 22-6868Built 1959 · Cheatham PaulN3378KGlobe GC-1B · S/N 1371Built 1946 · Garcia Michael JN337WGCessna 337 · S/N 337-0091Built 1965 · Grady Charles MartinN35RXBellanca 8KCAB · S/N 496-79Built 1979 · Right Rudder Flight Training LLCN36724Beech 95-B55 (T42A) · S/N TC-2333Built 1980 · Reeves Richard GN3951JCessna 150G · S/N 15065251Built 1966 · Jenani Industries LLCN46293Cessna 172K · S/N 17257162Built 1968 · Keefer TerryN466JWCessna 421C · S/N 421C0241Wf Construction IncN49202Cessna 152 · S/N 15281191Built 1977 · Skylogix Aircraft LLCN510LLCessna 510 · S/N 510-0074Built 2008 · Go Go Martin Enterprises LLCN5176RCessna 172RG · S/N 172RG0044Built 1979 · Right Rudder Flight Training LLCN51BHSikorsky HH-60L · S/N 84-23941Built 1984 · Jambb LLCN525JSSchroeder Jeff R BEDE BD-5A · S/N 3291Built 1997 · Schroeder Jeff RN5328SPiper PA-28-140 · S/N 28-26940Built 1970 · Arreola ChristopherN5407FPiper PA-28-181 · S/N 28-7790112Built 1977 · Fly Quest Aviation LLCN5816WMooney M20J · S/N 24-1586Qin DavidN5882TCessna 421B · S/N 421B0424De Smet Vicki MN613DJEllis Dale VANS RV-8 · S/N 81436Built 2012 · Right Rudder Flight Training LLCN6365XAerostar International RAVEN S49A · S/N S49A-3096Built 1991 · Cheatham LaurieN6522Robinson Helicopter R22 BETA · S/N 0522Uaa International IncN6717WPiper PA-28-140 · S/N 28-20830Built 1965 · Fieri Douglas JN7220PPiper PA-24-250 · S/N 24-2392Built 1960 · Hench Martin StewartN72GRRobinson Helicopter R22 BETA · S/N 4588Well Point IncN73MCBeech C90 · S/N LJ-600Built 1973 · Coastal Helicopters LLCN767PLCirrus Design SR22T · S/N 11400Built 2026 · Fly Girls LLCN79MSPiper PA-28-181 · S/N 28-7990154Built 1978 · Uaa International IncN80BHSikorsky EH-60A · S/N 87-24660Built 1987 · Jambb LLCN8243LPiper PA-32-301T · S/N 32-8024035Built 1980 · Fieri DougN82805Aeronca 7AC · S/N 7AC-1452Built 1946 · Cheatham PaulN82BHSikorsky UH-60A · S/N 79-23270Built 1979 · Jambb LLCN83BHSikorsky EH-60A · S/N 87-24668Built 1987 · Jambb LLCN881EEEric Sung SLING TSI · S/N 437SKBuilt 2023 · Rer Management LLCN884MWWarfel Michael RV-8 · S/N 81525Built 2009 · Warfel Michael GN90067Cessna 140 · S/N 9128Built 1946 · Right Rudder Flight Training LLCN90861Aerostar International RX-7 · S/N RX7-3324Built 1997 · Cheatham LaurieN9157NMooney M20R · S/N 29-0096Built 1996 · Cain JeffreyN918PLArbc Inc DBA Lindstrand 56A · S/N 5703Built 2019 · Cheatham Paul FN918RVDuggan Michael M RV8A · S/N 81865Built 2004 · Duggan Michael MN933CHBell 205A-1 · S/N 30062Built 1969 · Coastal Helicopters LLC
Back to La Verne, CA