San Pedro, CA
Registered aircraft · 38
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 PEDRO' 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 PEDRO' 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.
N11112Vans RV-12 · S/N 120188N123PXHans Koenigsmann SLING TSI · S/N 232SKN19610Cessna 172L · S/N 17260608N210DDCessna 210L · S/N 21061464N2170CCessna 177B · S/N 17702745N2491LCessna 172H · S/N 17255691N30140Waco UPF-7 · S/N 5537N313ADFouga CM 170 MAGISTER · S/N 470N31444Beech F33A · S/N CE-1277N315MBFouga CM 170 MAGISTER · S/N 498N315VBFouga CM 170 MAGISTER · S/N 197N33ZYNanchang China CJ-6A · S/N 4532014N3437HErcoupe 415-C · S/N 4062N3443BBeech D35 · S/N D-3681N353FMFouga CM 170 MAGISTER · S/N 353N354EAPipistrel D O O VIRUS SW 128 · S/N VSW128F0105N355FFouga CM 170 MAGISTER · S/N 355N363FFouga CM 170 MAGISTER · S/N 363N37DLSchleicher ASW-20C · S/N 20802N390EZOwen William D LONG-EZ · S/N 1390N39613Piper PA-32-300 · S/N 32-7840170N433FGFouga CM 170 MAGISTER · S/N 433N561VMFouga FOUGA CM 170 · S/N 561N610FMFouga CM 170R MAGISTER · S/N FM30N65288Beech A36 · S/N E-2062N6576QAlon A2 · S/N A-76N67657Cessna 152 · S/N 15281965N74323Grumman American Avn. AA-5B · S/N AA5B-0201N74649Grumman American Avn. AA-5B · S/N AA5B-0322N751PJMorane-Saulnier MS760 · S/N 51N760FBMorane-Saulnier MS760 · S/N 1069N76MWCessna 140 · S/N 8633N77UKAlexander Schleicher ASH 31 MI · S/N 31088N8312GCessna 150F · S/N 15062412N83GPMikoyan Gurevich MIG 15UTI · S/N 2562N858DFDiamond Aircraft Ind DA20-A1 · S/N 10147N9243WWolfe Seth WOLFE PITTS · S/N 001N94645Cessna 182Q · S/N 18266472
Back to San Pedro, CA