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 = 'AMERICAN FORK' 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 = 'AMERICAN FORK'
  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 = 'AMERICAN FORK'
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.

N121FWWemmering Jeffrey Lynn S-7S · S/N 0907484Stillman David A N139PSDiamond Aircraft Ind DA 40 · S/N 40.518Built 2005 · In-Site Aviation LLC N1565NPiper J3C-65 · S/N 23098Built 1947 · Mastodon Aero LLC N227NHDiamond Aircraft Ind DA20-C1 · S/N C0117Mc Aviation LLC N312MXCessna 310J · S/N 310J0033Built 1965 · Rapid Imaging Solutions LLC N3200LCessna 310J · S/N 310J0200Built 1965 · Rapid Imaging Solutions LLC N353RDDehaven J E/Dehaven C R LANCAIR 360 DEHAVEN · S/N 794-320-636 FBBuilt 1995 · Gerlach Brett C N44764Piper PA-28-180 · S/N 28-7505008Built 1974 · Hess Alex N5464LGrumman American Avn. AA-5 · S/N AA5-0364First renewal noticeKelly Michael J N724JSkykits SAVANNAH VGW · S/N 09-06-51-837Built 2011 · Miller Chanson N764LELasalle Investments EPIC LT · S/N 054Built 2018 · Xlear Inc N8009KOertli Erwin LONG EZ · S/N 512Doxey William Mark N8202WPiper PA-28-180 · S/N 28-2331Built 1965 · N8202w LLC N928GPilatus PC-12/47E · S/N 2471Built 2025 · Nrs Leasing LLC N9475UCessna 150M · S/N 15078423Built 1976 · Gerlach Brett C N969RCFantasy Air Sro ALLEGRO 2007 · S/N 07-240Built 2007 · Allegro Aircraft Alliance LLC

Back to American Fork, UT