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.

N450DFMarsh S-2F3AT · S/N 152341Built 2005 · Usda Forest Service FeppN451DFSikorsky S-70I · S/N 705337Built 2022 · California Dept Of Forestry & Fire ProtectionN452DFSikorsky S-70I · S/N 705354Registration pending, pending cancellationBuilt 2024N453DFSikorsky S-70I · S/N 705355Registration pending, pending cancellationBuilt 2024N454DFSikorsky S-70I · S/N 705356Built 2024 · California Dept Of Forestry & Fire ProtectionN455DFRockwell OV-10D · S/N 155492Usda Forest Service FeppN456DFRockwell OV-10D · S/N 155481Usda Forest Service FeppN457DFBeech 58 · S/N TH-1354Built 1982 · Usda Forest Service FeppN458DFGrumman S-2G · S/N 0341018Usda Forest Service - FeppN459DFRaytheon A200CT · S/N BP-027State Of CaliforniaN460DCTextron T206H · S/N T20609660Built 2021 · Dyncorp International IncN460DFLockheed C-130H · S/N 4996California Dept Of Forestry And Fire ProtectionN461DFRaytheon A200CT · S/N BP-029Built 1981 · State Of CaliforniaN462DFLockheed C-130H · S/N 5034California Dept Of Forestry And Fire ProtectionN463DFRaytheon A200CT · S/N BP-024Built 1981 · State Of California - Cal FireN464DFLockheed C-130H · S/N 5002California Dept Of Forestry And Fire ProtectionN465DFLockheed C-130H · S/N 5035California Dept Of Forestry And Fire ProtectionN46751Ryan Aeronautical ST3KR · S/N 2176Built 1942 · Aerospace Museum Of California FoundationN468DCTextron T206H · S/N T20609661Built 2021 · Dyncorp International IncN468DFLockheed C-130H · S/N 5107California Dept Of Forestry And Fire ProtectionN469DFRockwell OV-10D · S/N 155395Usda Forest Service FeppN470DFRockwell OV-10D · S/N 155502Usda Forest Service FeppN473DFRockwell OV-10D · S/N 155406Usda Forest Service FeppN476DFSikorsky S-70I · S/N 704083Built 2020 · California Department Of Forestry & FireN477DFSikorsky S-70I · S/N 704088Built 2020 · California Dept Of Forestry And Fire ProtectionN478DFSikorsky S-70I · S/N 704110Built 2020 · California Dept Of Forestry & Fire ProtectionN479DFSikorsky S-70I · S/N 704111Built 2021 · California Dept Of Forestry & Fire ProtectionN480DFSikorsky S-70I · S/N 704081Built 2019 · California Dept Of Forestry And Fire ProtectionN482DFSikorsky S-70I · S/N 704082Built 2020 · California Dept Of Forestry And Fire ProtectionN483DFSikorsky S-70I · S/N 704030Built 2018 · California Dept Of Forestry & Fire ProtectionN484DFSikorsky S-70I · S/N 704046Built 2019 · California Dept Of Forestry & Fire ProtectionN485DFSikorsky S-70I · S/N 704033Built 2018 · California Dept Of Forestry & Fire ProtectionN486DFSikorsky S-70I · S/N 704048California Dept Of Forestry & Fire ProtectionN487DFSikorsky S-70I · S/N 704051California Depart Of Forestry & Fire ProtectionN488DFBell UH-1H · S/N 69-15239Usda Forest Service FeppN489DFBell EH-1X · S/N 12224Usda Forest Service FeppN490DFBell UH-1H · S/N 70-15765Usda Forest Service FeppN492DFSikorsky S-70I · S/N 704112Built 2021 · California Dept Of Forestry & Fire ProtectionN493DFBell EH-1H · S/N 12001Usda Forest Service FeppN494DFBell EH-1X · S/N 11303Usda Forest Service FeppN495DFBell EH-1H · S/N 12218Usda Forest Service FeppN496DFBell EH-1H · S/N 69-15676Usda Forest Service FeppN497DFBell EH-1H · S/N 11533Usda Forest Service FeppN498DFBell UH-1H · S/N 69-15865Usda Forest Service FeppN499DFBell UH-1H · S/N 71-20022Usda Forest Service FeppN567DFLockheed C-130H · S/N 5005California Dept Of Forestry And Fire ProtectionN59GPPeriera George GP-4 · S/N 1First renewal noticeBuilt 1984 · Aerospace Museum Of CaliforniaN610SFAmerican Eurocopter AS350B3 · S/N 7278Built 2011 · Reach Air Medical Services LLCN61RXAirbus Helicopters AS350B3 · S/N 8262Built 2016 · Reach Air Medical Services LLCN68RXAirbus Helicopters AS350B3 · S/N 8483Built 2018 · Reach Air Medical Services LLC
Back to Mcclellan, CA