OpenAirDocs.org
Fremont, CA

Registered aircraft · 40

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

N12258Beech A45 · S/N G-722Built 1955 · Bacon Otis BlakeN1956GGeorge A Murillo GLASTAR · S/N 5642Murillo George AN19CABeech A36 · S/N E-2877Built 1994 · Poulton Bruce AN219SVInnowings Aerospace PKOK · S/N 0001Built 2019 · Sathish MurugaiahN220DJFox Leonard A GILES G-200 · S/N G2001018Built 1997 · Pirkin Ilya IN254EKCessna 172S · S/N 172S11119Built 2011 · Bellers Aviation IncN2559YCessna 172D · S/N 17249859A & D Precision Machining IncN270MRCessna T210M · S/N 21061660Built 1976 · Furtado William J III DBAN3010VCessna 150M · S/N 15076349Murillo George AN3057UCessna 172E · S/N 17250657Built 1963 · Desousa RaphaelN36232Taylorcraft BF12-65 · S/N 3189Built 1941 · Krueger David ON390MECessna 182S · S/N 18280862Built 2000 · Mccabe EugeneN39646Piper PA-28R-201T · S/N 28R-7803358Built 1978 · Icpc Craft LLCN413CKCessna 680 · S/N 680-0064Built 2006 · Air Wolf LLCN43VMPiper PA46-500TP · S/N 46-97005Built 2000 · N43vm LLCN4453CCessna 195B · S/N 16038Built 1953 · Kesinger Steven WN45115Cessna 150M · S/N 15076740Jiang JunN4525ZGulfstream American AA-5B · S/N AA5B-1125Built 1979 · Padilla JesseN4540Beech A36 · S/N E-299Built 1971 · Mathis Mark LN4542DBeech G35 · S/N D-4680Mathis Mark LN469HPPiper PA-46-310P · S/N 46-8508109Built 1985 · Trussell DavidN46JPPatillo James R QUICKIE Q-200 · S/N 2468Built 1999 · Patillo James RN5276PCessna 172S · S/N 172S11010Built 2009 · Bellers Aviation IncN55CXCcx-2300-0005 CCX-2300 · S/N CCX-2300-0005Built 2020 · Magnum Equipment Leasing IncN611GCErcoupe 415-C · S/N 611Ippolito JosephN63207Cessna 150M · S/N 15077175Built 1975 · Two Star Maritime LLCN6440Schleicher ASW27-18 · S/N 29050Built 2009 · Alford Patrick RN64FBTextron B300 · S/N FL-1238Built 2020 · Fremont BankN66085Cessna 172S · S/N 172S9768Built 2004 · Bellers Aviation IncN67651Cessna 152 · S/N 15281963Built 1978 · Salomonsson MatsN7144DPiper PA-22-150 · S/N 22-5007Built 1957 · Richardson James GN7560DCessna 172N · S/N 17272922Built 1979 · Jiang JunN77JBBeech D55 · S/N TE-563Built 1968 · Silmi AmjadN808SESarah M Banks RV-12 · S/N 120549Built 2017 · Sutherland John SN819EKCessna S550 · S/N S550-0009Built 1984 · Maisaka LLCN850SWPilatus PC-12/47E · S/N 2036Built 2020 · Flyco LLCN8795GCessna 150F · S/N 15062895Built 1966 · Desousa RaphaelN8861WPiper PA-28-235 · S/N 28-10416Built 1964 · Francavilla CharlesN888FSCessna 180K · S/N 18053163Built 1980 · Boock Thomas AN901SSIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 254Built 2008 · Two Star Maritime LLC
Back to Fremont, CA