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 = 'PLEASANT GROVE' 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 = 'PLEASANT GROVE'
  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 = 'PLEASANT GROVE'
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.

N1381BLuscombe 8E · S/N 6008James Dennis N210PECessna 210J · S/N 21059180Built 1969 · Van Dyke Gary D N2363Ross/Pitts S1 · S/N 1Built 1971 · Scheidel Bailey B N25070Piper J3C-65 · S/N 3641Built 1939 · Brill Bernard M N3022HForney 415-C · S/N 3647Scheidel Aaron J N321FRDJI AGRAS T40 · S/N 64TBL4A002006PVogt Jeffrey D N3235MPiper PA-12 · S/N 12-2028Built 1947 · Scheidel Jack A N35736Piper J3F-65 · S/N 6556Diamond J Farms N360SRSeabourn Scott R RV-6 · S/N 20997Registration pending, pending cancellationBuilt 1994 N4433PYakovlev YAK 52 · S/N 878201Vogt Jeffrey D N4596MPiper PA-11 · S/N 11-99Koshman Kyle A N465MSC Aerostar YAK-52W · S/N 9111310Vogt Jeffrey D N49733Boeing A75N1(PT17) · S/N 75-4276Vogt Jeffrey D N51826Van Dyke James C SA-750 · S/N 01VDBuilt 1980 · Van Dyke James C N520VACessna A185F · S/N 18503352Sale reported, pending cancellationBuilt 1977 N60191Cessna 150J · S/N 15070136Built 1968 · Vogt Jeffrey D N60653Cessna 150J · S/N 15070480Built 1969 · Russo Joseph M N63902Fairchild M-62C(PT-23A) · S/N 421-HOBuilt 1943 · Linear Farming Inc N6517PPiper PA-24-250 · S/N 24-1639Built 1959 · James Dennis N68813Cessna 152 · S/N 15282388Vogt Jeffrey D N72333Cessna 140 · S/N 9513Niegel Gregory S Jr N8079DPiper PA-18 · S/N 18-6062Built 1957 · Scheidel Ranches N842RSSLY Russell M AVID FLYER · S/N 1178DBuilt 1992 · Saare Jack A N84669Aeronca 7CCM · S/N 3380James Dennis N9448DPiper PA-18A 150 · S/N 18-6691Built 1958 · Linear Farming Inc

Back to Pleasant Grove, CA