Registered aircraft · 16

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 = 'MOUNT SHASTA' 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 = 'MOUNT SHASTA'
  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 = 'MOUNT SHASTA'
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.

N143JHAeropro CZ EUROFOX LSA · S/N 21106Built 2006 · Hinojosa David M N17NTValentin TAIFUN 17E · S/N 1046Ireland Robert C N21711Cessna 172M · S/N 17263992Williams Roger P III Trustee N22PMBerkshire Mfg. CONCEPT 70 · S/N 9Ireland Robert C N2575GCessna 182B · S/N 51875Built 1959 · Altes Matt N36VURaytheon A36 · S/N E-3449Built 2002 · Thomas Gary F N476MSCessna 150M · S/N 15077515Brooks Duane T Trustee N5752BCessna 182 · S/N 33752Built 1956 · Wallace Thad Joseph N6084EBeech K35 · S/N D-6097Built 1959 · Margart Geoffrey W N6370WPiper PA-28-140 · S/N 28-20431Built 1964 · Peterson Lawrence T N661DDCessna 150H · S/N 15067508Hanisko Thomas F N7128ECessna 182B · S/N 52128First renewal noticeBuilt 1959 · Schlumpberger Charles P N75513Cessna 172N · S/N 17267773Built 1976 · Baird David J N8000KStinson 108-2 · S/N 108-3000Gudgel Shannon L N989JBBigham Jack L MONTANA COYOTE · S/N 9810Built 1998 · Altes Matthew C N994JBCessna T182T · S/N T18208680Built 2007 · Eddy Peter J

Back to Mount Shasta, CA