Fallbrook, CA
Registered aircraft · 80
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 = 'FALLBROOK' 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 = 'FALLBROOK' 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.
N582SWJason Carver REV X · S/N X1048N5853SBeech S35 · S/N D-7746N613EVEvektor-Aerotechnik SPORTSTAR · S/N 2006 0614N6140NBeech 95-B55 (T42A) · S/N TC-2428N654BCPiper PA-28-180 · S/N 28-5335N6802JPiper PA-28-151 · S/N 28-7615361N699USchweizer SGS 1-26B · S/N 317N735AVCessna 182Q · S/N 18265279N7714DPiper PA-22-150 · S/N 22-5388N771TWPoor STARDUSTER TOO SA300 · S/N 434N7730MMooney M22 · S/N 690005N789JMJohn D Mathews LANCAIR MK II · S/N 984-320-824SFBN8062TPiper PA-32R-301 · S/N 32R-8229027N825XPiper PA32-301XTC · S/N 3255043N8336XRobinson Helicopter R44 · S/N 0228N8584RBeech F33A · S/N CE-539N8607PPiper PA-24-400 · S/N 26-137N8857Bellanca 7GCAA · S/N 254-73N9056GAerostar International S-77A · S/N S77A-3020N905ENArbc Inc DBA Lindstrand 120A · S/N 5307N912JEVans RV-12 · S/N 120039N9422BCessna 175 · S/N 55222N94925Taylorcraft BC12-D · S/N 9325N95719Taylorcraft BC12-D · S/N 8019N9782YBeech 35-B33 · S/N CD-655N97AHBeech A36TC · S/N EA-107N980VPCessna 525 · S/N 525-0098N99134Ercoupe 415-C · S/N 1757N998SHHughes Helicopters HUGHES 369D · S/N 1100847DN999ZPCessna TR182 · S/N R18201771
Back to Fallbrook, CA