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.

N1329VChadwick Garry Trustee · Cheyenne, WYBuilt 1976 · S/N R1722165 N1330VV1 Aeronautics LLC · Boise, IDBuilt 1976 · S/N R1722166 N1338V38 Victor LLC · Port Clinton, OHBuilt 1976 · S/N R1722172 N1348VBlake Joseph A · Jacksonville, FLBuilt 1976 · S/N R1722176 N1350VCranor John David III · Fort Collins, COBuilt 1976 · S/N R1722178 N1352VAdventist World Aviation · Wilson, NCBuilt 1976 · S/N R1722179 N13673Lande Michael D · Grand Marais, MNBuilt 1974 · S/N 17262932 N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186 N1413VMercury International LLC · Cheyenne, WYS/N R1722187 N1416VRegistered aircraftBuilt 1976 · S/N R1722188 N1437VBell John C · Wakefield, NHBuilt 1976 · S/N R1722190 N1448VGeisler Eric L · Eugene, ORBuilt 1976 · S/N R1722193 N1467VLumpkin Aviation LLC · Dahlonega, GABuilt 1976 · S/N R1722194 N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602 N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197 N150JBMyers Clifford A · Arbuckle, CABuilt 1977 · S/N R1722521 N1514VVanreeth James E · Washington Island, WIBuilt 1976 · S/N R1722198 N1521VBlack Hill Consulting LLC · Lake Havasu City, AZBuilt 1976 · S/N R1722199 N1530VThompson David Ray · Greenwood, SCBuilt 1976 · S/N R1722200 N1556VSquires Daniel Douglas · Wakefield, RIBuilt 1976 · S/N R1722201 N15FRScl Enterprises LLC · Waukesha, WIBuilt 1979 · S/N R1723280 N161KWKirtland Aero Club · Albuquerque, NMBuilt 1976 · S/N R1722002 N1623VHues Oulton A Jr · Norwood, MABuilt 1976 · S/N R1722206 N1698VStem Aviation Academy · Carlsbad, CABuilt 1976 · S/N R1722209 N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771 N1717VThorsness David A · Foley, MNS/N R1722210 N172CBRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1977 · S/N R1722290 N172CXBias Aviation LLC · Crossville, TNBuilt 1980 · S/N R1723373 N172DDMurphy Dylan James · Murphys, CAFirst renewal noticeBuilt 1977 · S/N R1722547 N172SPLuke Airlines LLC · Southgate, MIBuilt 1977 · S/N R172-2842 N172XPTrapp Thomas A · Salem, CTBuilt 1979 · S/N R1723088 N176EAHeath Mark R · Radisson, WIS/N R172-3440 N1781VAmbis Edward J · Ithaca, NYBuilt 1976 · S/N R1722212 N179XPLadonne Frank · Fort Collins, COBuilt 1979 · S/N R1723155 N1804VBuskas Blake Rodney · Whitefish, MTS/N R1722214 N1832VCerniglia Paul J · Monroe Township, NJBuilt 1976 · S/N R1722215 N1876VRedding Aero Enterprises Inc · Redding, CABuilt 1976 · S/N R1722217 N1880VKdn Aviation LLC · Annapolis, MDBuilt 1976 · S/N R1722218 N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066 N192CWBowen Jeffrey Charles · Frankston, TXBuilt 1979 · S/N R1723092 N193RJSale Reported · Henderson, NVSale reportedBuilt 1980 · S/N R1723315 N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221 N199PDCity Of Sacramento · Sacramento, CABuilt 1979 · S/N R1723127 N20492Crockett Richard S · Saint George, UTS/N R1722463 N210HKConway Jenna Marie Wells · Camarillo, CABuilt 1977 · S/N R1722481 N218HIverson Timothy A · Maple Grove, MNS/N R1722840 N2281Guzman Javier A · Sammamish, WABuilt 1979 · S/N R1723129 N228KYPapalote Ranches LLC · Missoula, MTBuilt 1978 · S/N R1722883 N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223 N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166

Back to Cessna R172K