Skip to content

Registered aircraft · 23

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

N159JMWyttenbach Joel N · Sauk City, WIBuilt 1963 · S/N P17257176 N188PLe Duc Richard Steven · Mazama, WABuilt 1963 · S/N P17257122 N8524XPedroza Everett W · Tehachapi, CABuilt 1962 · S/N P17257124 N8525XBradford John R · Sheridan, ARBuilt 1962 · S/N P17257125 N8527XMicheliche Robert · Federalsburg, MDS/N P17257127 N8528XWilson Andrew · Sault Sainte Marie, MIBuilt 1962 · S/N P17257128 N8529XWheeler Kevin M Trustee · Comstock Park, MIBuilt 1962 · S/N P17257129 N8533XApex Aviation LLC · Highlands Ranch, COBuilt 1962 · S/N P17257133 N8539XSale Reported · Holyoke, COSale reportedBuilt 1962 · S/N P17257139 N8540XN8540x LLC · Prescott, AZBuilt 1963 · S/N P17257140 N8541XHartman Matthew F · Billings, MTBuilt 1962 · S/N P17257141 N8542XMillennialytics LLC · Denver, COBuilt 1962 · S/N P17257142 N8544XValiair Limited Co Trustee · Casper, WYBuilt 1962 · S/N P17257144 N8546XSchneiderhan Edward F · Laurium, MIBuilt 1962 · S/N P17257146 N8548XHuston Kenneth Paul · New Carlisle, INBuilt 1962 · S/N P17257148 N8557XChauhan Jay S · Oakland, CABuilt 1962 · S/N P17257157 N8561XJ & K Flying LLC · Marengo, OHBuilt 1962 · S/N P17257161 N8571XRegistered aircraftBuilt 1963 · S/N P17257171 N8574XDiscover Aviation Center LLC · Elyria, OHBuilt 1963 · S/N P17257174 N8581XRegistered aircraftBuilt 1963 · S/N P17257181 N8585XMcpeck Connor T · Gettysburg, SDBuilt 1963 · S/N P17257185 N883CMDelone Charles · Sarasota, FLS/N P17257155 N99RTTennessee Museum Of Aviation Inc · Sevierville, TNBuilt 1962 · S/N P17257165

Back to Cessna P172D