Registered aircraft · 16

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N102DFDiamond Aircraft Ind DA20-A1 · S/N 10029Le Garrett P N160XPSikorsky EH-60A · S/N 85-24470Built 1985 · Grayman Group LLC N208KKKevin M Kimball MONSTER ELITE · S/N E571Built 2021 · Thomas Randall Darren N280HRMussen Gary L HARMON ROCKET II · S/N 32Built 1995 · Mussen Gary L N32210Stinson 10A · S/N 7859Built 1954 · Steiner Hans L N372DGPiper PA 46-350P · S/N 4636372Built 2005 · Wild Air LLC N4370FPiper PA-32-300 · S/N 32-7640114Built 1976 · Rmr Inc N6215SCessna 150G · S/N 15067015Built 1967 · Smith Clifford W III N6654TCessna 150A · S/N 15059054Built 1960 · Thomas Randall Darren N71WSSmith D Wayne CORNELL-26 · S/N 26Mello Matthew D N7965ECessna 150 · S/N 17765Langton Kathy A N8353FHughes Helicopters HUGHES 369D · S/N 1260062DBuilt 1977 · Royal Helicopter Services LLC N865HSHughes 369HS · S/N 1060865SBuilt 1977 · Royal Helicopter Services LLC N89906Cessna 140 · S/N 8951Built 1946 · Beery Ray M N926ESHughes 369HS · S/N 940641SBuilt 1974 · Royal Helicopter Services LLC N944BTPilatus PC-12/45 · S/N 468Built 2002 · Global Aircraft Services LLC

Back to Exeter, CA