Skip to content

Registered aircraft · 722

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

N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N1234SGale Jeremy C · Clear Lake, WIS/N 17254335 N123PYDotson Daniel · Holly Springs, MSBuilt 1966 · S/N 17254641 N1251Miltz Karl W · Black River, MIS/N 17254758 N1300TVarnado Calvin M · Palmer, AKBuilt 1965 · S/N 17253731 N1305FShlapak Jeffrey M · Peachtree City, GABuilt 1966 · S/N 17254800 N1307GPray Aviation Inc · Augusta, KSBuilt 1966 · S/N 17254120 N1310FHumphries Aviation LLC · Maysville, KYBuilt 1966 · S/N 17254805 N1312FBill Stephan · Ellenville, NYBuilt 1966 · S/N 17254807 N1314FLee James Christopher · Concord, GABuilt 1966 · S/N 17254809 N1315FApsey Bradley D · Deckerville, MIBuilt 1966 · S/N 17254810 N1324FWyllie Ashton R J Trustee · Thornton, NHBuilt 1966 · S/N 17254819 N1326FRegistration Pending · Heber Springs, ARRegistration pendingBuilt 1966 · S/N 17254821 N1327FSwepston Nicole S · Jackson, OHS/N 17254822 N1328FSaindon Christopher M · Orlando, FLBuilt 1966 · S/N 17254823 N1331FKing James H · Barneveld, NYBuilt 1966 · S/N 17254826 N1334FHamilton Alathea L · Frankfort, KYBuilt 1966 · S/N 17254829 N1336FNelson David E · Windsor, VABuilt 1966 · S/N 17254831 N1338FVogel Auto Repair LLC · Palmer, NEBuilt 1966 · S/N 17254833 N1339FFriedlander Edward R · Hattiesburg, MSBuilt 1966 · S/N 17254834 N1341FDix Justin T · South Boston, VABuilt 1966 · S/N 17254836 N1342FFriedman Peter Michael · Pleasant Hill, CABuilt 1966 · S/N 17254837 N1347FSprague Lee G · Augusta, GABuilt 1966 · S/N 17254842 N1348FRau Bodo A · Aliso Viejo, CABuilt 1966 · S/N 17254843 N1349FTran Holm Viet · Henderson, NVS/N 17254844 N1350FButler Kendall L · Gatesville, TXBuilt 1966 · S/N 17254845 N1352FDtm Enterprises Inc · Bronson, MIBuilt 1966 · S/N 17254847 N1361FWorld Media Corp · Hialeah, FLBuilt 1966 · S/N 17254856 N1364FLewis David N · Carmel, INBuilt 1966 · S/N 17254859 N1365FHouse Conrad B · Hernando, MSS/N 17254860 N1366FBenton Joseph C · Hinckley, MNBuilt 1966 · S/N 17254861 N1367FMoehn Dennis H · Oshkosh, WIBuilt 1966 · S/N 17254862 N1369FHoudelife Aviation LLC · Bixby, OKBuilt 1966 · S/N 17254864 N1371FJones Michael Robert · Glen Rose, TXS/N 17254866 N1374FHegge Luke T · Pine City, MNBuilt 1966 · S/N 17254869 N1376FWerderich George A · Bartlett, ILBuilt 1966 · S/N 17254871 N1377FMartinelli James · Madras, ORBuilt 1966 · S/N 17254872 N1382FCloud 9 Aviation LLC · Scenery Hill, PABuilt 1966 · S/N 17254877 N1385FRautio Ian · Intl Falls, MNS/N 17254880 N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882 N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N144PWAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 17254019 N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062 N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217 N16KNIgwt Holding LLC · Richardson, TXBuilt 1965 · S/N 17253986 N170ATVan Anda Aviation LLC · Apopka, FLBuilt 1966 · S/N 17254850 N172BNRedtail Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254846 N172BXBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254216

Back to Cessna 172G