Tracy, CA
Registered aircraft · 64
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 = 'TRACY' 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.
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 = 'TRACY' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N103VKCessna 172S · S/N 172S8532N1042WBradford Steven W WHITTMAN W-10 · S/N 96-1042N110GGPiper PA-34-220T · S/N 3449486N1191MCessna 172K · S/N 17258691N142STFlight Design CTSW · S/N 05-03-02N1590WCessna 172R · S/N 17281256N169MECessna 172S · S/N 172S8449N195TJJennings Richard A RV-6 · S/N 24563N2183LBeech A36 · S/N E-969N24296Cessna 152 · S/N 15280201N24764Cessna 152 · S/N 15280362N2914UCessna 172D · S/N 17250514N2935CCessna 180 · S/N 30835N2ZZChampion 7ECA · S/N 98N30028Piper PA-34-220T · S/N 34-48019N30756Piper J3C-65 · S/N 5091N3851TPiper PA-28R-180 · S/N 28R-30173N399HPPresley Denny G RV-8A · S/N 81311N411SVPiper PA-34-200 · S/N 347250348N421ERCessna 172S · S/N 172S9679N4947GCessna 172N · S/N 17273494N5093QCessna 152 · S/N 15285073N5096GCessna 172N · S/N 17273545N514HRBeech A36TC · S/N EA-70N5220LPiper PA-28-180 · S/N 28-4513N525UCDJI AGRAS T50 · S/N 1581F6BUB24CJ001RGP8N5369HCessna 152 · S/N 15284094N5421XRockwell International S-2R · S/N 2020RN549LLLudwig Larry E NORTH STAR · S/N 686-1N6081NBeech B23 · S/N M-1174N614JDPiper PA-30 · S/N 30-1517N63042Cessna 150M · S/N 15077058N6367QCessna 152 · S/N 15285236N6375JPiper PA-28-180 · S/N 28-4788N6378EAerostar International RAVEN S49A · S/N S49A-3117N64VHAmerican Champion 8KCAB · S/N 743-95N6620RCessna 172RG · S/N 172RG0217N6704QGrumman Acft ENG Cor-Schweizer G-164B · S/N 220BN67495Cessna 152 · S/N 15281866N689CSRobinson Helicopter R44 II · S/N 14799N704THCessna 150M · S/N 15078857N70892Cessna 182M · S/N 18259410N7193KBuckeye DREAM MACHINE · S/N 4904N733GVCessna 172N · S/N 17268292N733ZGCessna 172N · S/N 17268674N750BZWilliam F Broughton CH750 CRUZER · S/N C75-10924N757ZTCessna 152 · S/N 15280140N75VJCirrus Design SR22 · S/N 8848N767DPMooney M20E · S/N 188N777CEBeech V35B · S/N D-10019
Back to Tracy, CA