Skip to content

Registered aircraft · 98

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

N106WSMarriott Ed · Manhattan Beach, CAS/N R172-0107 N122JHValentine Terence S · Glennallen, AKBuilt 1966 · S/N R-172-0086 N13030Miller Tim D · Seymour, MOBuilt 1967 · S/N R1720239 N137CBEdmiston Brandon L · Murray, KYBuilt 1967 · S/N R1720146 N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143 N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120 N14460Ajkj Aviation LLC · Erie, COS/N R1720121 N146ACUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R1720147 N15178Gill Robert S · Woodinville, WABuilt 1966 · S/N R172-0179 N15194Mcgrath Kevin M · Cloquet, MNBuilt 1967 · S/N R172-0195 N15CSBartlett Branden S · Chugiak, AKBuilt 1974 · S/N R172-GC-3 N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058 N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137 N200PSMerren R Todd DBA · Montgomery, ALBuilt 1967 · S/N 67-15030 N220FBCulbertson William Theodore · Helena, MTBuilt 1967 · S/N R172-0221 N23777Erb Ralph J · Mebane, NCS/N R1720096 N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092 N23XGUsda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720163 N2427Boomer Aviation Inc · Fort Walton Beach, FLBuilt 1967 · S/N R172-0235 N242WSRowe William S · Argyle, TXBuilt 1967 · S/N R172-0243 N318Liberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N R172-0006 N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N33503Sueltenfuss Tyler G · Boerne, TXBuilt 1967 · S/N R-172-0242 N33512Kennedy John D · Clinton Twp, MIBuilt 1966 · S/N R172-0099 N38009Harada Susan K · Salt Lake City, UTBuilt 1967 · S/N R172-0026 N38014Friend Richard A · Pollock, IDS/N R172-0013 N3FRValiair Limited Company Trustee · Casper, WYS/N R172-0237 N40098Fall River County Emergency Management · Hot Springs, SDBuilt 1966 · S/N R172-0134 N401NKLoya Christopher Nmi · Houston, TXS/N R172-0229 N411TABenz Christopher · Seattle, WABuilt 1968 · S/N R172-0196 N43860Friends Of Army Aviation · Ozark, ALS/N R172-0124 N48237Yoder Airways LLC · Fayetteville, GABuilt 1967 · S/N R172-0171 N48322Stroemsvik Kristian · Strasburg, VAS/N R172-0213 N49885Lilja Daniel R · Plains, MTBuilt 1971 · S/N R1720156 N5072GRuffaire LLC · Midland, TXS/N R1720205 N51608Commonwealth Of Kentucky · Frankfort, KYBuilt 1967 · S/N R1720255 N5272EEcolift Corp · San Juan, PRS/N R1720178 N52HPHeritage Aviation Management LLC · Headland, ALBuilt 1967 · S/N R1720079 N5336GHyatt Mark A · Colorado Springs, COBuilt 1967 · S/N R172-0154 N5384Penhorwood Joshua M · Shubuta, MSBuilt 1967 · S/N R172-0238 N542ADJohnson Thomas F · Buckeye, AZS/N R1720234 N6051UVigil Gabriel M · Mora, NMS/N R172-0183 N609KYMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0225 N62217Wieken Peter J · Mount Joy, PABuilt 1968 · S/N R1720085 N6226Lewis Jay C · Spanaway, WABuilt 1967 · S/N R172-0227 N64408Dematteis James A · Erie, PABuilt 1966 · S/N R1720104 N65025Killian Larry D · Hampton, ARS/N R172-0123 N65195Sciortino Warren A III · Crested Butte, COBuilt 1966 · S/N R1720021 N669GAWilson Victor A · New Albany, OHS/N R172-0200 N6741TCavanaugh Flight Museum · Denison, TXBuilt 1966 · S/N R-172-0127

Back to Cessna R172E