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

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 = 'DANA POINT' 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 = 'DANA POINT'
  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 = 'DANA POINT'
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.

N107NANorth American T-28B · S/N 200-262Built 1955 · Banigan Bruce H II N1483CCessna T182T · S/N T18208419Built 2005 · Wang Helin N1549NBeech A36 · S/N E-2474Campbell Catherine D N16588Waco YKS-6 · S/N 4523Built 1936 · Whittlesey Leslie F N18906Lockheed 12A · S/N 1277Whittlesey Leslie Trustee N18TBCessna 182R · S/N 18267978Built 1981 · Carlson Herb Trustee N2437YCessna 172D · S/N 17249737Built 1962 · Russell John D N2565CCessna 170B · S/N 26209Registration revokedBuilt 1954 · Folgner Robert E N259PMPeter Macdonald VL-3TE-915 · S/N VL-3-541Built 2023 · Macdonald Peter D N29962Waco UPF-7 · S/N 5459Built 1940 · Whittlesey Leslie F N308RLCessna 210-5(205) · S/N 205-0110Aulisio Anthony III N36DTBeech A36 · S/N E-1496Built 1979 · O'Brien Edward J N423BBeech 35 · S/N D-1430Carlson Herb Trustee N53EWaco EGC-8 · S/N 5069Built 1938 · Whittlesey Leslie F N542AGRotorsport UK CAVALON · S/N RSUK-V00542Built 2023 · Spinning Feather LLC N5625CCessna 140 · S/N 15578Whittlesey Leslie F N6344CPiper PA-28-181 · S/N 28-7890364Built 1978 · Payne Ernest Charles N6398JPiper PA-28-180 · S/N 28-4813Built 1968 · Sanger Mark D N7331YPiper PA-30 · S/N 30-292Built 1964 · Neubert Erich S N81DPBoeing A75N1(PT17) · S/N 75-4479Built 1941 · Stearman Group Inc N874PWCessna 510 · S/N 510-0392Built 2011 · Blue Sky Mountain LLC N9163PPiper PA-24-260 · S/N 24-4651Built 1966 · Miller Richard Marc Trustee N919FACessna 414A · S/N 414A0628Fortnum Air LLC N9722ZBoeing E75 · S/N 75-5491Built 1944 · Campbell Jeffrey D N980QBeech P35 · S/N D-6852Built 1961 · Martinez Marcus

Back to Dana Point, CA