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

N100GRRobertson George SKY SKEETER · S/N 1Nghiem Daniel N156BPBilly Payne STORCH · S/N B156Built 2019 · Nghiem Daniel N1574LCessna A150L · S/N A1500460Built 1973 · Nghiem Daniel N190AVSocata TB21 · S/N 2165Nghiem Daniel N222TACessna 150J · S/N 15069729Built 1968 · Deschene Michael R N25453Porterfield CP-65 · S/N 651Built 1940 · Yates Cecil R N38JEPilatus B4-PC11AF · S/N 176Pham Loc G N40YBBell 206B · S/N 2787Nghiem Daniel DBA N4123ZPiper PA-18-150 · S/N 18-8186Built 1965 · One2one LLC N435HPPiper PA46R-350T · S/N 4692035Built 2008 · One2one LLC N44314Piper PA-28-140 · S/N 28-7425403Built 1974 · Yates Cecil R N460FLPiper PA-28-140 · S/N 28-7125257Built 1971 · Hillenbrand Sean P N520LEYakovlev YAK 52 · S/N 9311707Built 1994 · Trinh Ruth N5860JCessna 182P · S/N 18263567Built 1975 · Mcclain Kevin D N59RVReps Francis M RV 3 · S/N RV21635Built 1995 · Nghiem Daniel N716LElmendorf Special 1 · S/N 1Built 1969 · Nghiem Daniel N74576Mooney M20B · S/N 1887Varnes Mark R N770Luscombe 8A · S/N 4037Built 1946 · Yates Cecil R N774MEClyatt William S FLY PRODUCTS FLASH B · S/N 2002342Masterson Michael D N80127Cessna 172M · S/N 17266388Built 1975 · J C Dalco Inc N818DNPavel Majzner FOKKER DR 1 · S/N 2013-01Built 2015 · Nghiem Daniel N85186Champion 7BCM · S/N 7AC-3918Built 1946 · Foley Ward N9859JCessna A150M · S/N A1500668Nghiem Daniel

Back to Westminster, CA