Manhattan Beach, CA
Registered aircraft · 25
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 = 'MANHATTAN BEACH' 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 = 'MANHATTAN BEACH' 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.
N1008KAmerican General Acft AG5B · S/N 10168N1058DCessna 190 · S/N 7670N106WSCessna R172E · S/N R172-0107N119DADiamond Aircraft Ind DA 62 · S/N 62.C029N189PWCirrus Design SR22T · S/N 1964N1915JRhon Williams EARLY BIRD JENNY · S/N 661N1954MCessna 182P · S/N 18264500N2028ABeech V35A · S/N D-9026N218JSCirrus Design SR20 · S/N 8551N228SKBombardier BD-700-1A10 · S/N 9643N3172FCessna A150L · S/N A1500407N3205VBeech A36 · S/N E-2899N4113HMooney M20J · S/N 24-0628N421SDKarim Kanfoudi SLING TSI · S/N 422SKN4300NCessna 140 · S/N 13771N4470SBeech V35B · S/N D-9778N543GLBombardier BD-700-1A10 · S/N 9543N5565XBeech F33A · S/N CE-1485N614HMSmith AEROSTAR 601P · S/N 61P-0306-080N657KStickelmaier John F RV-9A · S/N 92251N69AAASH Arnold L RUTAN LONG EZ · S/N 436N718SGCirrus Design SR22T · S/N 11313N7209TCessna 172A · S/N 46809N769WTBeechcraft G36 · S/N E-4046N9479GCessna TU206E · S/N U20601679
Back to Manhattan Beach, CA