OpenAirDocs.org
Mcclellan, CA

Registered aircraft · 102

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

N1496CCessna 182T · S/N 18281693Built 2005 · Sbma Services LLCN161SPTextron T206H · S/N T20609667Built 2021 · California Department Of Parks And RecreationN20MSNorth American/Aero Classics P-51D · S/N 4463807Built 1944 · Pacwest P-51 LLCN263HPTextron 208 · S/N 20800719Built 2025 · California Highway PatrolN312RXEurocopter Deutschland EC 135 P2+ · S/N 1099Built 2013 · Reach Air Medical Services LLCN322RXAirbus Helicopters Deutschland EC135 P3 · S/N 1230Built 2016 · Reach Air Medical Services LLCN382SJMerriam PITTS SPECIAL · S/N DMR-1Built 1967 · Aerospace Museum Of CaliforniaN383DCTextron 172S · S/N 172S12648Built 2021 · Dyncorp International IncN385DCTextron 172S · S/N 172S12651Built 2021 · Dyncorp International IncN387DCTextron 172S · S/N 172S12652Built 2021 · Dyncorp International IncN3GPPereira OSPREY 2 · S/N GP3Built 1973 · Aerospace Museum Of CaliforniaN400DFNorth American OV-10A · S/N 305122M65Usda Forest Service FeppN401DFNorth American OV-10A · S/N 305128M68Usda Forest Service FeppN402DFNorth American OV-10A · S/N 305132M70Usda Forest Service FeppN403DFNorth American OV-10A · S/N 305148M78Usda Forest Service FeppN407DFNorth American OV-10A · S/N 305164M86Usda Forest Service FeppN408DFNorth American OV-10A · S/N 305178M90Usda Forest Service FeppN409DFNorth American OV-10A · S/N 155401Usda Forest Service FeppN410DFNorth American OV-10A · S/N 305158M82Usda Forest Service FeppN413DFNorth American OV-10A · S/N 30520M13Usda Forest Service FeppN414DFNorth American OV-10A · S/N 30526M16Usda Forest Service FeppN415DFNorth American OV-10A · S/N 30568M38Usda Forest Service FeppN416DFBeech 200C · S/N BL-124Built 1985 · Usda Forest ServiceN418DFNorth American OV-10A · S/N 30570M39Usda Forest Service FeppN421DFNorth American OV-10A · S/N 305206M107Usda Forest Service FeppN422DFMarsh S-2F3AT · S/N 152817Built 2001 · Usda Forest Service FeppN424DFMarsh S-2F3AT · S/N 152820Built 2001 · Usda Forest Service FeppN425DFMarsh S-2F3AT · S/N 152825Built 1999 · Usda Forest Service FeppN426DFMarsh S-2F3AT · S/N 152824Built 1999 · Usda Forest Service FeppN427DFMarsh S-2F3AT · S/N 153570Built 2001 · Usda Forest Service FeppN428DFMarsh S-2F3AT · S/N 443262Usda Forest Service FeppN429DFNorth American OV-10A · S/N 155400Usda Forest Service FeppN430DFNorth American OV-10A · S/N 305127A60Usda Forest Service FeepN430GRAirbus Helicopters EC 130 T2 · S/N 9735Built 2025 · Reach Air Medical Services LLCN431DFMarsh S-2F3AT · S/N 149265Built 2001 · Usda Forest Service FeppN432DFMarsh S-2F3AT · S/N 149268Usda Forest Service FeppN433DFMarsh S-2F3AT · S/N 149855Usda Forest Service FeppN434DFMarsh S-2F3AT · S/N 153579Usda Forest Service FeppN435DFMarsh S-2F3AT · S/N 153573Built 2001 · Usda Forest Service FeppN436DFMarsh S-2F3AT · S/N 152337Built 2001 · Usda Forest Service - FeppN437DFMarsh S-2F3AT · S/N 149848Usda Forest Service FeppN438DFMarsh S-2F3AT · S/N 151640Usda Forest Service FeppN439DFMarsh S-2F3AT · S/N 149854Built 2002 · Usda Forest Service FeppN440DFMarsh S-2F3AT · S/N 149873Built 2001 · Usda Forest Service FeppN441DFMarsh S-2F3AT · S/N 152808Built 2003 · Usda Forest Service FeppN442DFMarsh S-2F3AT · S/N 152826Built 2005 · Usda Forest Service FeppN444DFMarsh S-2F3AT · S/N 151654Usda Forest ServiceN445DFMarsh S-2F3AT · S/N 152345Built 2004 · Usda Forest Service FeppN448DFMarsh S-2F3AT · S/N 152347Built 2005 · Usda Forest Service FeppN449DFMarsh S-2F3AT · S/N 152838Built 2004 · Usda Forest Service Fepp
Back to Mcclellan, CA