Skip to content

Registered aircraft · 362

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

N115MBChalet Suzanne Aviation Inc · Lake Wales, FLS/N 17248936 N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841 N1300YMammucari Leonard E · West Chester, PAS/N 17249000 N1302YDorning Patrick J · Ft Lauderdale, FLBuilt 1961 · S/N 17249002 N1303YDay Patrick J · Bloomer, WIS/N 17249003 N1304YLyon Samantha J · Milton, FLS/N 17249004 N1305YGraupmann John S · Arlington, WABuilt 1961 · S/N 17249005 N1306YOklahoma Flight Academy LLC · Owasso, OKBuilt 1961 · S/N 17249006 N1307YOrange County Flight Center Inc · Santa Ana, CABuilt 1961 · S/N 17249007 N1308YBrewer Lester A · Magna, UTS/N 17249008 N1309YC747 LLC · Wilmington, DEBuilt 1961 · S/N 17249009 N1312YPierce Larry Jay · Brigham City, UTBuilt 1961 · S/N 17249012 N1313YSullivan Shawn M · The Dalles, ORBuilt 1962 · S/N 17249013 N1319YWinston William F · Lake Stevens, WABuilt 1961 · S/N 17249019 N1320YStc Aviation Inc · Saint Cloud, MNBuilt 1962 · S/N 17249020 N1321YDean Brandon Louis · Elm Mott, TXBuilt 1961 · S/N 17249021 N1324YRuoff Timothy D · Topeka, KSBuilt 1961 · S/N 17249024 N1326YPine Barbara J · Tok, AKBuilt 1961 · S/N 17249026 N1327YHangar 20 Flying Club LLC · Climax, MIBuilt 1961 · S/N 17249027 N1330YDgj Tex LLC DBA · Cleburne, TXBuilt 1961 · S/N 17249030 N1331YS & J 172 LLC · Florence, SCBuilt 1961 · S/N 17249031 N1334YCarranza Oscar Eusebio · San Bruno, CAS/N 17249034 N1337YGaipa Aircraft Inc · Saint Joseph, MIBuilt 1961 · S/N 17249037 N1338YRegistered aircraftBuilt 1961 · S/N 17249038 N1339YMiller Henry C · Mckinney, TXS/N 17249039 N1340YStephens Christopher L · Kelso, WAS/N 17249040 N1341YLong Gary A · Lewisport, KYBuilt 1962 · S/N 17249041 N1345YFlying Horse LLC · Missoula, MTBuilt 1961 · S/N 17249045 N1348YCoughlin Patrick J · Nashua, NHBuilt 1961 · S/N 17249048 N1349YSheehan Michael F · Avalon, CABuilt 1961 · S/N 17249049 N1350YI Buy U Fly LLC · Prescott Valley, AZBuilt 1961 · S/N 17249050 N1351YSumrall Richard C · Village Mills, TXBuilt 1961 · S/N 17249051 N1352YGarza James · Palm Beach Gardens, FLBuilt 1961 · S/N 17249052 N1357YHouse Robert L · Cleveland, GABuilt 1962 · S/N 17249057 N1361YFeathered Flyers LLC · Louisville, KYS/N 17249061 N1362YKansas State University · Salina, KSBuilt 1961 · S/N 17249062 N1363YDrobnis Adam R · Dickson, TNBuilt 1961 · S/N 17249063 N1366YTulsa Turbine & Recip Inc · Tulsa, OKBuilt 1961 · S/N 17249066 N1369YMadden James D · Sharpsburg, GABuilt 1961 · S/N 17249069 N1371YFlightsuit Farmer LLC · Imperial, NEBuilt 1961 · S/N 17249071 N1374YBowden Richard P · Lenexa, KSBuilt 1961 · S/N 17249074 N1385YCaracci Sam V Jr · Galesburg, ILS/N 17249085 N1387YBi-County Ambulance Service Inc · Yuba City, CABuilt 1961 · S/N 17249087 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102

Back to Cessna 172C