Skip to content

Registered aircraft · 617

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 ('2072412')
  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 ('2072412')
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.

N7822UKelly John K · Summerfield, NCS/N 17251822 N789SSummit Aircraft LLC · Seattle, WABuilt 1963 · S/N 17250862 N7FKRed Rock Aviation LLC · Las Vegas, NVBuilt 1964 · S/N 17251777 N806JTR&L Aviation LLC · Kansas, OKBuilt 1964 · S/N 17251200 N817TStone Michael A · Winston Salem, NCS/N 17250644 N820NR120 Volantes LLC · Cleveland, MSS/N 17250936 N823PWSpradley Jeff D · White Springs, FLBuilt 1964 · S/N 17250896 N8385UClow Streeter M · Mansfield, OHFirst renewal noticeBuilt 1964 · S/N 17252285 N8501KStephenson Joe D Jr · Sand Springs, OKS/N 17250723 N850YDudley Benjamin H · Wasilla, AKBuilt 1964 · S/N 17251784 N8818TEngel Samina · San Diego, CABuilt 1964 · S/N 17251521 N8BAHoffman Schuyler · Brighton, COBuilt 1964 · S/N 17251805 N900SCCordle Christopher T · Howard, OHBuilt 1964 · S/N 17251349 N928HPeterson Michael A · White Salmon, WABuilt 1964 · S/N 17251734 N98188Usda Forest Service Fepp · Columbia, SCS/N R1720077 N99TSLorenzen Carl A · Blair, NEBuilt 1963 · S/N 17250870 N9VUBoyer Daniel E · Brockton, MABuilt 1964 · S/N 17251361

Back to Cessna 172E