Skip to content

Registered aircraft · 513

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

N1020UNorth Central Aircraft Sales · Tioga, NDS/N 18783 N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128 N112RPTaylor Chad A · Enid, OKBuilt 1950 · S/N 19422 N11575Pyle Howard H · Cornelius, ORBuilt 1950 · S/N 19540 N1208DMusgrove James F · Burien, WABuilt 1955 · S/N 19762 N1212DN1212d LLC · Boise, IDS/N 19766 N1215DMytth Spray Solutions Inc · Easley, SCBuilt 1950 · S/N 19769 N1221DJamison Tim · Oklahoma City, OKBuilt 1951 · S/N 19982 N1224DByrer Jesse A · Monrovia, INBuilt 1951 · S/N 20114 N1227DWhite Michael D · Willow Springs, MOBuilt 1950 · S/N 19781 N1228DBell Stephen R · Carleton, MIBuilt 1950 · S/N 19782 N1231DNeel Aviation LLC · Lakeland, FLBuilt 1950 · S/N 19785 N1235DStates Douglas S · Geneseo, ILBuilt 1951 · S/N 20118 N1240DBaeder Mark A · Mesa, AZBuilt 1950 · S/N 19794 N1242DPrice John C · Bennington, KSBuilt 1949 · S/N 18734 N1244DBackcountry Aviation LLC · Ankeny, IAS/N 19798 N1245DChism Jerry · Austin, ARBuilt 1950 · S/N 19799 N1247DWroe Daniel C · Denton, MDS/N 20119 N1250DSmith Christopher R · Manvel, TXBuilt 1951 · S/N 20122 N1256DYoung Robert J · Conroe, TXBuilt 1950 · S/N 19810 N1257DKendrick Ross M · Sycamore, GABuilt 1951 · S/N 19811 N1258DInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N 19812 N1259DBrown Nicholas J · West Valley City, UTBuilt 1950 · S/N 19813 N1261DEpstein Neal R · Medway, MABuilt 1950 · S/N 19815 N1262DBohanan Robert C · Denali Park, AKBuilt 1950 · S/N 19816 N1263DSellers Kevin D · Baytown, TXBuilt 1950 · S/N 19822 N1264DReason Cole · Yakima, WABuilt 1951 · S/N 19840 N1265DWiseth Devin · Grand Rapids, MNBuilt 1951 · S/N 19841 N1266DA T Enterprises Ltd · Three Forks, MTBuilt 1950 · S/N 19842 N1273DJones William J · Villa Grove, ILBuilt 1951 · S/N 19849 N1276DLehr Denis J · Sacramento, CABuilt 1951 · S/N 20124 N1277DEllison Phillip · Castle Hayne, NCBuilt 1951 · S/N 19853 N1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 19857 N1286DPolicani Desmond M · Tacoma, WABuilt 1951 · S/N 19862 N1288DConner Brent F · Medford, ORBuilt 1951 · S/N 19861 N1289DAeronautical Technical Service Inc · Collierville, TNS/N 19865 N1292DKlaerner John D · San Antonio, TXBuilt 1951 · S/N 19868 N1293DAlder George A · Palmer, AKBuilt 1951 · S/N 19869 N1295DBlessum Jay A · Minot, NDBuilt 1950 · S/N 19871 N1297DPerk LLC · Glendale, AZBuilt 1951 · S/N 19873 N1298DGlaser Gerald A · Sebastopol, CABuilt 1951 · S/N 19874 N1303DTail Dragn Tn LLC · Adams, TNBuilt 1951 · S/N 19879 N1304DGardners Guns & Mfg LLC · Elk City, OKBuilt 1951 · S/N 19880 N1309DOld Buzzard Aviation Inc · Middleburg, FLBuilt 1951 · S/N 19885 N1311DAntkowiak Colton C · Chugiak, AKBuilt 1951 · S/N 19887 N1313DPlowman Benjamin · Raleigh, NCBuilt 1951 · S/N 19889 N13149Dughman Tim A · Willow, AKBuilt 1952 · S/N 19356 N1314DBartels Lance R · Freetown, INBuilt 1951 · S/N 19890 N1317DBaer Monte Wayne · Ronan, MTS/N 19893 N1318DBott Christopher L · Pilot Point, TXBuilt 1951 · S/N 19894

Back to Cessna 170A