OpenAirDocs.org
Tustin, CA

Registered aircraft · 29

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

N1082JCessna T206H · S/N T20608775Wild Bills Aviation IncN1534GCessna 421B · S/N 421B0630Rugger Investment Group LLCN204LPBeech F33A · S/N CE-1262Built 1988 · Steffenhagen Julian L Jr TrusteeN209WCubcrafters CC11-160 · S/N CC11-00300Built 2014 · Goldenwest Diamond CorpN23152Cirrus Design SR20 · S/N 9189Built 2023 · Wasserman Air LLCN232JTMooney M20J · S/N 24-0727Built 1978 · Blezek Kent DN2353FCubcrafters CC11-160 · S/N CC11-00202Built 2012 · Wild Bills AviationN29188Cessna TU206C · S/N U206-1153Built 1968 · Rugger Investment Group LLCN29RAAmerican AA-1A · S/N AA1A-0108Built 1971 · Duenner MatthiasN321EFElliott Stetson F LONG-EZ · S/N 1900Rengel Richard JN321RDPilatus P3-03 · S/N 321Built 1956 · O'Conner Willard VN333ZZAviat A-1C-200 · S/N 3333Built 2019 · Wild Bills Aviation IncN3472GCessna 310R · S/N 310R0846Built 1976 · Losko Patrick JN380JETextron 525C · S/N 525C0380Built 2022 · Goldenwest Diamond CorpN383USAviat A-1C-200 · S/N 3091Built 2010 · Wild Bills Air Charters IncN41KGCirrus Design SR22T · S/N 10472Built 2025 · Sl Aviation Pro LLCN4218LCessna 172G · S/N 17254287Built 1966 · Wengs Enterprises IncN458RFTextron 525B · S/N 525B0907Built 2026 · Magnus Avis LLCN59LVPiper PA-24-250 · S/N 24-1229Built 1959 · Greek John WN61PTCessna U206G · S/N U20604538Built 1978 · Wings Of Faith Ministries IncN6803UMooney M20C · S/N 2518Built 1963 · Lau TimN688WGCessna 310B · S/N 35613Built 1957 · Debritton Daniel RN70595Cessna TU206F · S/N U20602085Built 1973 · Lung Aerial Group IncN714BWHawker Beechcraft HAWKER 900XP · S/N HA-0016Built 2007 · Wlc LLCN714RMTextron 680A · S/N 680A0265Built 2021 · Raj Consulting LLCN71WLAviat A-1B · S/N 2031Built 1999 · Wild Bill'S Aviation IncN773CVCirrus Design SR22 · S/N 4644Built 2018 · Rengel & Co Architects IncN7MNAviat A-1C-200 · S/N 3383Built 2021 · Big Foot Flying Machines LLCN827NMCessna 510 · S/N 510-0294Built 2010 · White Knuckle Endeavors LLC
Back to Tustin, CA