Skip to content

Registered aircraft · 653

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

N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226 N2684VReims Rocket LLC · Tempe, AZBuilt 1976 · S/N R1722227 N2704VVorderbruggen Gary J · Garden Valley, CABuilt 1976 · S/N R1722228 N276NYFogarty Richard · Mandeville, LAS/N R1722393 N28DWDavid E Glaser LLC · Peyton, COBuilt 1976 · S/N R1722118 N2925VCortese Thomas J · Sedona, AZBuilt 1977 · S/N R1722234 N2949VKingdom Power And Glory LLC · Colorado Springs, COBuilt 1977 · S/N R1722235 N296BWAmerican Driveaway LLC · Cowden, ILBuilt 1977 · S/N R1722379 N3134VShelley Cameron M · Reno, NVS/N R1722240 N3139VArrow Trading Inc · Coconut Creek, FLBuilt 1977 · S/N R1722241 N315PKGardisser Dennis R · Lonoke, ARBuilt 1977 · S/N R1722742 N3199VDs Victor LLC · Elburn, ILBuilt 1977 · S/N R1722242 N3239VMccue Michael R · Missoula, MTBuilt 1977 · S/N R1722243 N327JKRudolph Rudi · Cordova, TNBuilt 1976 · S/N R1722003 N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245 N3315VWirth Nicholas · Lake Geneva, WIBuilt 1977 · S/N R1722248 N3318VArledge Roone Jr · Lakewood Ranch, FLBuilt 1977 · S/N R1722249 N333CTJrm Wings LLC · Farmington, UTBuilt 1977 · S/N R1722655 N3366VMason Dave Q · San Marcos, CABuilt 1977 · S/N R1722251 N336GMGlasser Dean · Boswell, PAS/N R1722336 N3520VHarrell Erick C · Sedona, AZBuilt 1977 · S/N R1722256 N3549VSmith Jacques F · Anchorage, AKS/N R1722257 N356PLBongiorni Robert W · Burgettstown, PABuilt 1978 · S/N R1722987 N3573VShaules Daniel J · Billings, MTBuilt 1977 · S/N R1722258 N359RCWingsleasing LLC · Wichita, KSBuilt 1977 · S/N R1722427 N3712VImperium Solutions LLC · Cheyenne, WYBuilt 1977 · S/N R1722261 N3806VShirey Donnie W · Collinsville, OKBuilt 1977 · S/N R1722263 N3814VCert Works LLC · Bennett, COBuilt 1977 · S/N R1722264 N3817VFloener Michael A · Colville, WABuilt 1977 · S/N R1722265 N3870VMercury International LLC · Cheyenne, WYBuilt 1977 · S/N R1722266 N3928VThompson Edmond P · Langley, WABuilt 1977 · S/N R1722267 N3990VReding Aviation LLC · Midland Park, NJBuilt 1977 · S/N R1722268 N400SJLockeby Aviation LLC · Norman, ARBuilt 1978 · S/N R1722876 N4096VWtw Air LLC · Houston, TXBuilt 1977 · S/N R1722272 N4277BHale Barbara M · Oxnard, CABuilt 1977 · S/N R1722556 N44LWWilson Lorraine · Richmond, TXBuilt 1979 · S/N R1723106 N44XPFurnace Joel Ray · Golden, COBuilt 1977 · S/N R1722584 N456CRMcevoy Richard D Trustee · Anchorage, AKBuilt 1977 · S/N R1722756 N45ADLen Timothy Allen · Deland, FLBuilt 1977 · S/N R1722550 N45GVRedd Aviation LLC · Springville, UTBuilt 1976 · S/N R1722204 N4635KFinley Robert O · Dubois, WYBuilt 1976 · S/N R1722001 N4653KEastern Aviation Publishing Inc · Center Harbor, NHBuilt 1976 · S/N R1722004 N4714KJld Air LLC · North Hampton, NHBuilt 1976 · S/N R1722016 N4718KMayes John · Carson City, NVS/N R1722017 N488RAWest Bottoms Properties Inc · Iola, KSBuilt 1977 · S/N R1722539 N5048VLoewen Wielhelm · Presidio, TXBuilt 1977 · S/N R1722274 N5118VGoldmark Charles J · Okanogan, WABuilt 1977 · S/N R1722278 N5157VHarwig Robert P · Longville, MNBuilt 1977 · S/N R1722279 N5205VMcketta Charles W · Moscow, IDBuilt 1977 · S/N R1722283 N5231VGibson John V Jr · Yardley, PABuilt 1977 · S/N R1722284

Back to Cessna R172K