Registered aircraft · 20

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N160LSRemos REMOS G-3/600 · S/N 181Built 2006 · Clayton Randall L Trustee N21CQCcx-2000-0131 CCX-2000 · S/N CCX-2000-0131Built 2021 · N8ld LLC N21QUSchleicher ASK-21 · S/N 21272Utah Soaring Association N228BGBurkhart Grob G-103A TWIN II ACRO · S/N 33995-K-228Built 1985 · Utah Soaring Association Inc N264CPCirrus Design SR22 · S/N 3190Built 2008 · Hill David K N29AWCirrus Design SR22T · S/N 11072Built 2025 · Particle Airways LLC N32RRJeffery Palmer CCX-2300 · S/N CCX-2300-0112Built 2024 · Palmer Jeffery W N33223Powrachute PEGASUS · S/N A 139 PEGBuilt 2003 · Clayton Randall L N346JZZierenberg Terry R ZENITH 701 · S/N 001Zierenberg Terry R N397AMDiamond Aircraft Ind DA 40 · S/N 40.835Built 2007 · Diamond Star Da40 LLC N4446YBurkhart Grob G 103 TWIN II · S/N 3825Built 1983 · Utah Soaring Association N5285HCessna 172M · S/N 17265395Built 1975 · Child Cris N531JJCirrus Design SR22T · S/N 10374Built 2024 · Jbarz Aviation LLC N65332Pilatus B4-PC11 · S/N 164Built 1974 · Utah Soaring Association Inc N7813Grob-Werke Gmbh And TWIN ASTIR · S/N 3178Utah Soaring Assoc Inc N78ALAndrew-Alden VARIEZE · S/N AEA1Built 1980 · Andrew Larry G N792TWBurkhart Grob G103 TWIN ASTIR · S/N 3184Built 1978 · Utah Soaring Association Inc N8485WBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3290Built 1980 · Utah Soaring Association N9685HCessna 172M · S/N 17266313Boys Will Fly LLC N996JCChang Jae W RV-10 · S/N 40533Built 2011 · Ccc Properties LLC

Back to Mapleton, UT