Registered aircraft · 18

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 = 'LOS BANOS' 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 = 'LOS BANOS'
  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 = 'LOS BANOS'
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.

N19301Aeronca K · S/N K-169Whitehurst Joel A Jr N200HRBell 206B · S/N 815Built 1972 · Sutter Air Inc N2057LBeech C23 · S/N M-1861Built 1976 · Wilson Michael Joseph N250LCessna TR182 · S/N R18200936Built 1979 · Menefee Scott A N41206Piper PA-28-151 · S/N 28-7415137Built 1974 · Dalforno Ronald L N423CCPiper PA-28R-201T · S/N 28R-7803368Built 1978 · Allen Stephen David N4498FPiper PA-32R-300 · S/N 32R-7680453Built 1976 · Sapit Corp N489ERCessna 172N · S/N 17272083Built 1978 · Menefee Scott A N5169PPiper PA-24 · S/N 24-187Stockdale Alexander Ian N5212NCessna 182Q · S/N 18267574Built 1980 · R C Sherwood Grain Co N7304WAnthony R Whitehurst MK IV HEAVY HAULER · S/N 4385XWhitehurst Joel A Jr N74EPRobinson Helicopter R44 · S/N 2301Built 2013 · Cantrell Grady DBA N7520MCessna 175 · S/N 55820Built 1959 · Whitehurst Funeral Chapels Inc N761DPCessna T210M · S/N 21062176Built 1977 · Sunset Cattle Co LLC N761FKCessna T210M · S/N 21062220Built 1977 · Sunset Cattle Co LLC N78317Globe GC-1B · S/N 2317Built 1946 · Silveria Frank R N914GHRobinson Helicopter R44 II · S/N 10232Built 2004 · Cantrell Grady DBA N9343XCessna 182E · S/N 18253743Built 1962 · Young Charles T

Back to Los Banos, CA