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 = 'UT' AND g.registrant_city = 'BLUFFDALE' 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 = 'UT' AND g.registrant_city = 'BLUFFDALE'
  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 = 'UT' AND g.registrant_city = 'BLUFFDALE'
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.

N138DDBell Helicopter Textron 206L-1 · S/N 45199Built 1979 · Dalton Aviation LLC N205MEMooney M20J · S/N 24-3161Built 1990 · Sf Imports LLC N2227WPiper PA-34-200T · S/N 34-7970171Built 1979 · Ab Christenson Holdings LLC N2877YCessna 182E · S/N 18253877Built 1962 · Brumback Recreation LLC N2919UPiper PA-28RT-201 · S/N 28R-7918220Built 1979 · Frix Richardd N3067YCessna 182E · S/N 18254067Registration pendingBuilt 1962 N313RRichard R Nason SLING TSI · S/N 321SKBuilt 2022 · N313r LLC N3735TBeech A36 · S/N E-1764Built 1980 · Garner Brian J N665RCessna 310B · S/N 35755Built 1958 · Nelson Todd J N6816NMooney M20C · S/N 680112Built 1968 · Hollis Leo D Jr N72296Cessna 140 · S/N 9473Built 1946 · Bennee Shane R N727DGCessna 180 · S/N 31710Built 1955 · Marsh David G N75776Cessna 172N · S/N 17267942Built 1976 · Frix Richard D N818LMCirrus Design SR22T · S/N 1778Built 2018 · Top Flight Holdings LLC N84657Cessna 172K · S/N 17258565Built 1969 · Myler Mitchell N86363Aeronca 11AC · S/N 11AC-170Built 1946 · Brumback Recreation LLC

Back to Bluffdale, UT