Skip to content

Registered aircraft · 718

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2072414')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072414')
ORDER BY 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.

N8862UChase Tim W · Kearney, MOBuilt 1965 · S/N 17252777 N8863UBoatman Robert G · Great Falls, MTBuilt 1965 · S/N 17252778 N8865URegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 17252780 N8867UHoffman Robert E · Blossvale, NYBuilt 1965 · S/N 17252782 N8868UMuller Robert J · River Falls, WIBuilt 1965 · S/N 17252784 N8871UWichmann William C · Owasso, OKBuilt 1965 · S/N 17252787 N8873UOlafsen George F · Greeneville, TNBuilt 1965 · S/N 17252789 N8877USmith Stephen A · Aloha, ORBuilt 1965 · S/N 17252794 N8888URomano Michael A · Fresno, CABuilt 1965 · S/N 17252807 N8889UJennings Chadwick B · Reno, NVBuilt 1965 · S/N 17252808 N8891UMcdonald Brince R · Lonoke, ARS/N 17252810 N8899UYoon Kerry D · Franklin, TNBuilt 1965 · S/N 17252820 N9114ZLarson Richard W · Sioux Falls, SDBuilt 1965 · S/N 17252869 N917ZXD & S Flyers LLC · Portage, MIS/N 17253276 N92CCCanadian Co Sheriffs Office · El Reno, OKBuilt 1965 · S/N 17253144 N933PAerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17252361 N93PSVanderflute Scott L · Lakewood, WAS/N 17251979 N93TPBagley Corydon S · Holladay, UTBuilt 1965 · S/N 17252041

Back to Cessna 172F