OpenAirDocs.org
Merced, CA

Registered aircraft · 37

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N109MHAgusta A109E · S/N 11026Built 1998 · Gateway Air Center IncN132NBeech B200 · S/N BB-1053Flying Cowboys LLCN134SFPiper PA-28-140 · S/N 28-20994Built 1965 · Reid Brian SN15LNBombardier CL-600-2B16 · S/N 5509Built 2001 · Neal Air LLCN206BGBell 206B · S/N 861Built 1972 · Merced County Sherrifs OfficeN209SWWoods Steven W SONEX WAIEX · S/N W0128Built 2013 · Rudd William A TrusteeN2221Cessna 182C · S/N 52538Built 1960 · Conley James AndrewN23LWCirrus Design SR22 · S/N 1450Built 2005 · Gateway Air Center IncN26364Lesher BJ-1B DUSTER · S/N 186Built 1980 · Eason Richard EN3321EAeronca 7AC · S/N 7AC-6770Built 1947 · Gudgel Daniel RN341TBSocata TB-20 TRINIDAD · S/N 1696Wil Aviate LLCN38071Beech F33A · S/N CE-935Built 1980 · Carter Donald P TrusteeN3972GCessna U206C · S/N U206-0972Built 1967 · County Of Merced Sheriff'S DeptN5178CBeech B35 · S/N D-2460Built 1950 · Reid Brian SN527TCBeech B36TC · S/N EA-527Built 1991 · Leonardo Paul A IIIN5344YPiper PA-23-250 · S/N 27-2418Built 1963 · Merced County Mosquito Abatement DistrictN585FKDJI AGRAS T100 · S/N 1581F8ZLC25B3002DW52Kahlon Agriculture Co IncN585GKDJI AGRAS T100 · S/N 1581F8ZLC25AU0025E62Kahlon Agriculture Company IncN58JDBeech 58TC · S/N TK-19Built 1977 · Grossman Kenneth RN5900NRockwell International 114A · S/N 14513Built 1979 · Mackin Marvin LN6230XKolb MARK III · S/N M3-025Built 2001 · Deane George IN630DCLeading Edge Aerial Tech PV100X · S/N 10032Merced County Mosquito Abatement DistrictN6437BCessna 172 · S/N 29637Built 1956 · Brown Michael WN6511KRepublic RC-3 · S/N 777Built 1947 · Gateway Air Center IncN6860CCessna 441 · S/N 4410304Built 1982 · Gateway Air Center IncN7031VRobinson Helicopter R44 II · S/N 13616Built 2013 · Warren W Wainwright IncN7304FPiper PA-28-140 · S/N 28-25216Reid Brian SN731MRCessna A188B · S/N 18803005TMerced County Mosquito Abatement DistrictN756GLCessna TR182 · S/N R18201073Built 1979 · Lawrence Cyril LeonardN7582Schweizer SGS 1-26D · S/N 472Built 1970 · Walker Richard AN758CBCessna R172K · S/N R1722979Registration pendingBuilt 1978N7868XCessna 172B · S/N 17248368Reid Brian SN8604JCessna 150G · S/N 15066504Built 1967 · Pouncey WayneN8621QBeech S35 · S/N D-7645Built 1964 · Grossman Kenneth RandellN890SBLippert Barry M RV-9A · S/N 91095Built 2009 · Eason Richard EN911SSBell UH-1H · S/N 73-21773Merced County Sheriffs OfficeN926CWCirrus Design SR22T · S/N 2324Built 2021 · Valley Flyway LLC
Back to Merced, CA