Skip to content

Registered aircraft · 363

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.

N1661YRegistration Pending · Cowpens, SCRegistration pendingBuilt 1962 · S/N 17249361 N1664YOleary Joseph · Richmond, VTBuilt 1962 · S/N 17249364 N1670YMarshall Gregory A · Sauk Rapids, MNBuilt 1962 · S/N 17249370 N1671YDavid Dahl · Shevlin, MNBuilt 1962 · S/N 17249371 N1672YSmith David W · Texarkana, TXBuilt 1962 · S/N 17249372 N1673YLentz Gregory · Green Forest, ARBuilt 1962 · S/N 17249373 N1676YGray Bryan · Colorado City, TXBuilt 1962 · S/N 17249376 N1682YStorby Steven R · Osceola, WIBuilt 1962 · S/N 17249382 N1683YKnutson Daniel T · Lodi, WIBuilt 1962 · S/N 17249383 N1684YKoenig William J · Benedict, MDS/N 17249384 N1686YBrissel John M · El Paso, TXBuilt 1962 · S/N 17249386 N1692YSeaplanes R Fun Inc · Wilmington, DEBuilt 1962 · S/N 17249392 N1696YAkinde Oluwatoyin Adenike · Brooklyn Park, MNBuilt 1962 · S/N 17249396 N1697YKoerner Matthew · Garfield, NJBuilt 1962 · S/N 17249397 N172APocock Milne David · Cal Nev Ari, NVBuilt 1961 · S/N 172-48797 N172JHHaugen Jim · Maiden Rock, WIBuilt 1962 · S/N 17248803 N172MPPasswater Michael E · Upland, CABuilt 1961 · S/N 17248976 N172RSSchwartz Nathan S · Indianapolis, INBuilt 1961 · S/N 17248893 N172VWVanwagnen Brian J · Jackson, MIBuilt 1961 · S/N 17249058 N172WHSholund Stuart H · Elgin, ORBuilt 1961 · S/N 17249101 N1803YOfficial Stripes LLC · New Braunfels, TXBuilt 1962 · S/N 17249403 N1804YSnader Douglas E · West Linn, ORBuilt 1962 · S/N 17249404 N1806YMadcity Aviation LLC · Madisonville, KYBuilt 1962 · S/N 17249406 N1808YHardy Russell L · Rimrock, AZBuilt 1962 · S/N 17249408 N1810YLussier Lisa · Greene, RIFirst renewal noticeBuilt 1962 · S/N 17249410 N1812YHopkins Mark W · Emporia, KSBuilt 1962 · S/N 17249412 N1816YNicholas Thomas M II · Enid, OKBuilt 1962 · S/N 17249416 N1821YKinney James R · Vermillion, SDBuilt 1962 · S/N 17249421 N1825YRound Engine Aero · Nashville, MIS/N 17249425 N1826YSwensen James A · Lake Point, UTBuilt 1962 · S/N 17249426 N1828YPaulk Tracy · Fitzgerald, GABuilt 1962 · S/N 17249428 N1830YKrug Kenneth C · Horton, KSBuilt 1962 · S/N 17249430 N1841YSegroves Chris · Clarkston, WAS/N 17249441 N1845YAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1962 · S/N 17249445 N1846YMuldoon Anthony P · Howell, MIS/N 17249446 N1847YN1847y LLC · Queensbury, NYFirst renewal noticeBuilt 1962 · S/N 17249447 N1851YEscapule Dustin L III · Florence, AZBuilt 1962 · S/N 17249451 N1852YMinot Light Aviaiton LLC · Rockland, MABuilt 1962 · S/N 17249452 N1853YHurd Roger Mark · Bow, WABuilt 1962 · S/N 17249453 N1854YMikowski Charles A · Sparta, MIS/N 17249454 N1857YKnudson Wayne L · Larimore, NDBuilt 1962 · S/N 17249457 N1858YBlaich George F IV · Poplar Bluff, MOBuilt 1962 · S/N 17249458 N1860YPeterson Jerad · Oshkosh, NES/N 17249460 N1862YVakalis Kevin A · Chugiak, AKBuilt 1962 · S/N 17249462 N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464 N1872YKamp Implement Co · Belgrade, MTBuilt 1962 · S/N 17249472 N1873YTullier Mary A · Talihina, OKS/N 17249473 N1874YCouncil Melvin · Squaw Valley, CABuilt 1962 · S/N 17249474 N1875YBrotheridge Bryan R · Merritt Island, FLBuilt 1962 · S/N 17249475 N1881YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249481

Back to Cessna 172C