San Rafael, CA
Registered aircraft · 53
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 = 'SAN RAFAEL' 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 = 'SAN RAFAEL' 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.
N1223BCessna 425 · S/N 425-0201N122PRDassault FALCON 2000 · S/N 57N124ATSmith Noah E QUICKIE Q-2 · S/N 2178N129DGCessna 525B · S/N 525B0269N133DVCanadair CT-33 · S/N 133610N133HHCanadair CT-33 · S/N 133452N146AGCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 416N153KCSeamax Aircraft Ltda SEAMAX M-22 · S/N 153N18861Beech C23 · S/N M-1953N199MTRans S-19LS · S/N 05080004LSN20LTMaule M-7-260 · S/N 26015CN21JDNorth American SNJ-5 · S/N 90996N248LFCirrus Design SR22T · S/N 2128N260MTSiai-Marchetti F.260 · S/N 3-80N26KBAir Creation CLIPPER 912 · S/N T03088N2AKCirrus Design SF50 · S/N 0581N303JDPilatus PC-12/45 · S/N 303N305AFCessna/Inland Valley Avia 305 C · S/N 305AFN317DBucker BU-133 · S/N 45N32503Piper J3C-65 · S/N 5398N3649RPiper PA-28-180 · S/N 28-5746N373Piper PA-30 · S/N 30-1374N3749JCessna 150G · S/N 15065049First renewal noticeN3754NBeech 35 · S/N D-973N3796MPiper PA-28R-201T · S/N 28R-7803194N3HVMiller F P/Weitman D GLASAIR III SH-3R · S/N 3103N400VBPiper PA-42-1000 · S/N 42-5527002N4042ABeech V35B · S/N D-9102N415XTPilatus PC-12/47E · S/N 2144N488MAAnderson Mike PHOENIX X1A · S/N RB-01-4-88N49ERCirrus Design SR20 · S/N 10013N5017DCessna 182A · S/N 51117N5145NBoeing B75N1 · S/N 75-7474N5468PPiper PA-24-250 · S/N 24-525N57471Taylorcraft TG-6 · S/N 6090N5753FPiper PA-28-140 · S/N 28-25056N5804ZPiper PA-22-108 · S/N 22-9657N6140FCessna A150L · S/N A1500425N6304RPiper PA-28-140 · S/N 28-21469N6731UMooney M20C · S/N 2463N741FLPiper PA-28-140 · S/N 28-7225578N7439ACessna 172 · S/N 29539N759BUCessna 182Q · S/N 18265870N76747Beech A36TC · S/N EA-41N7766NPiper PA-28-180 · S/N 28-5212N777WTPeter Eisele AL18 · S/N AL-337N78024Globe GC-1B · S/N 2024N7826TLouie Kenneth G STOL CH701 · S/N 7-6513N883TFCirrus Design SR22 · S/N 4609N892XRDJI MAVIC 2 ZOOM · S/N 0M6CH69 R0A0WPS
Back to San Rafael, CA