Folsom, CA
Registered aircraft · 39
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 = 'FOLSOM' 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 = 'FOLSOM' 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.
N132WWCirrus Design SR22T · S/N 8608N135MFEurocopter Deutschland EC 135 P2+ · S/N 0623N1806LBeech A36 · S/N E-836N2371APiper PA-22-135 · S/N 22-734N34387Meyers Industries 200B · S/N 269N345CMCessna T182T · S/N T18209016N3745VCessna 140 · S/N 15022N3856BBeech F35 · S/N D-4122N393VRVashon RANGER R7 · S/N 10250N49YXTeel Wayne D WAIEX · S/N W0049N5278WPiper PA-28-160 · S/N 28-326N539CDCirrus Design SR22 · S/N 1127N5490WPiper PA-28-160 · S/N 28-575N5565BCessna 182 · S/N 33565N57WACessna 421C · S/N 421C0451N622TTAgee John Milton RV 6A · S/N 1N6504NBellanca 14-13-3 · S/N 1621N665CWCirrus Design SR22 · S/N 2116N7093VMooney M20F · S/N 22-1421N739EZCessna 172N · S/N 17270497N73GTAviat A-1C-180 · S/N 3072N744CDCirrus Design SR22 · S/N 0024N754WAPiper PA 46-350P · S/N 4636754N7601WPiper PA-28-180 · S/N 28-1560N7683TCessna 172A · S/N 47283N7971VCessna 180H · S/N 18051871N8060XAeronca 7DC · S/N 7DC-132N85BLDova DV-1 SKYLARK · S/N 06/06N916EXWelch Emmet E/Stolnacke Carl E RANS S-7S · S/N 0507464N91RZAircraft Mfg & Development CH 2000 · S/N 20-1014N92187Cessna 182N · S/N 18260079N933QBeech N35 · S/N D-6827N9351LAmerican AA-1A · S/N AA1A-0051N961KSGrumman American Avn. AA-5 · S/N AA5-0363N965SCessna 182M · S/N 18259638N968BGCirrus Design SR22 · S/N 0968N968CDCirrus Design SR22 · S/N 1829N97784Cessna 182Q · S/N 18267191N982DWCessna 750 · S/N 750-0279
Back to Folsom, CA