Santa Barbara, CA
Registered aircraft · 157
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 = 'SANTA BARBARA' 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 = 'SANTA BARBARA' 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.
N102CTFlight Design CTSW · S/N 05-12-05N103SJCessna 206H · S/N 20608101N110RPCompagnie Daher TBM 700 · S/N 1504N114CMPiper PA-18-150 · S/N 18-7709146N115STSweeney Thomas F STROJNIK S2A · S/N 029N117BTextron 525B · S/N 525B0561N124CBCirrus Design SR22T · S/N 1415N124LTPilatus PC-12/47E · S/N 1889N127EZGruno Richard W VARIEZE · S/N 331N129SBNorth Wing APACHE · S/N 410137N1429ECessna 172N · S/N 17270996N1562BBeech F33A · S/N CE-1362N1563WBeech V35B · S/N D-9370N1566KBeech 58 · S/N TH-1549N158WDWilliam M Oprendek CARBON CUB CCK-1865 · S/N CCK-1865-0109N159SZPezetel SZD-48-1JANTAR STD 2 · S/N B-1053N1672RCessna R182 · S/N R18200507N176BGSchempp-Hirth VENTUS C · S/N 550N178SBMitsubishi MU-2B-40 · S/N 435 S.A.N182SHCessna TR182 · S/N R182-01348N18456Beech A36 · S/N E-1131N1850WBell OH-58A · S/N 71-20787N188RMacy Frank E RV8 · S/N 81458N18FDSiai-Marchetti SF260 · S/N 287N20151Cessna 177B · S/N 17702637N2020GCessna 182A · S/N 51320N205KSBell UH-1H · S/N 9526N20617Textron T206H · S/N T20609522N206SBCessna 206H · S/N 20608167N211WPDiamond Aircraft Ind DA 40 · S/N 40.922N2136PPiper PA-28RT-201T · S/N 28R-7931064N2140DMooney M20S · S/N 30-0044N2159PCessna T206H · S/N T20608432N220NYCessna 172M · S/N 17263763N226SBCirrus Design SR22T · S/N 8549N22805Iai GULFSTREAM G280 · S/N 2184N22963Cessna 150H · S/N 15068646N231MNMooney M20K · S/N 25-0717N234HKCirrus Design SR22 · S/N 1746N2372GCessna 182B · S/N 51672N2419RCessna 182S · S/N 18280927N241DGPiper PA 46-350P · S/N 4636489N2567WMooney M20C · S/N 3271N26SECirrus Design SF50 · S/N 0304N275MGCirrus Design SR20 · S/N 9932N28683Grumman American Avn. AA-5B · S/N AA5B0755N298DCRobinson Helicopter R44 II · S/N 13936N300DLPiper PA-32-300 · S/N 32-7840200N3063RPiper PA-28R-200 · S/N 28R-35624N310ADCessna T310R · S/N 310R0538
Back to Santa Barbara, CA