Registered aircraft · 23

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'CLAREMONT' ORDER BY g.n_number

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 = 'CLAREMONT'
  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 = 'CLAREMONT'
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.

N103BHDavid Lenart BEARHAWK COMPANION · S/N 3C-5C/6C-1613CBuilt 2021 · Beck Randy R N20124Cessna 177B · S/N 17702631Built 1977 · Cerven Bohuslav Bo N2617RCessna 182K · S/N 18258317Built 1967 · Fener Seth M N26XRolladen-Schneider LS-3 · S/N 3002Built 1977 · Cangahuala Laureano A N3823RCessna 172H · S/N 17255323Built 1966 · Electra-Vision Advertising Corp N4122HMooney M20J · S/N 24-0645Built 1978 · Beck Randy R N4355WBeech B24R · S/N MC-271Built 1974 · Frieson Steven B N44ABMooney M20F · S/N 22-1196Built 1975 · Anthony Ronald W N44RZLaister Sailplane Products LP-49 · S/N K-44Strengell Eric P N46302Cessna 172M · S/N 17264181Built 1974 · Jones Lehman M N4658GCessna 172N · S/N 17273284First renewal noticeGlobal Aviators Academy Inc N6151RCessna T210F · S/N T210-0051Built 1965 · Path Barney H DBA N6426VCessna 172RG · S/N 172RG0687Global Aviators Academy Inc N6817PPiper PA-24-180 · S/N 24-1950Plummer Seth N6832WPiper PA-28-140 · S/N 28-20973Litchfield Bobby Lee N69149Cessna 152 · S/N 15282514Built 1978 · Joyner Carol M N737SKCessna 172N · S/N 17269638Global Aviators Academy Inc N7642GCessna 172L · S/N 17259342Built 1970 · Air Petunia N82525Piper PA-28RT-201T · S/N 28R-8231068Built 1982 · Bravo Zulu Aero LLC N8435YPiper PA-30 · S/N 30-1595Global Aviators Academy Inc N854RBeech 35-33 · S/N CD-7Built 1959 · Wiencek Stephen John N9387VMooney M20F · S/N 700018Built 1969 · Pabst Erik R N9559ZRyan NAVION A · S/N NAV-4-1320Built 1948 · Kanakis Nicholas G

Back to Claremont, CA