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.

N1745DStuczynski Jason S · Justin, TXBuilt 1951 · S/N 20188 N1748DWilliams Bobby G · Simi Valley, CABuilt 1951 · S/N 20191 N1753DKlein John T · Austin, ARBuilt 1951 · S/N 20196 N1755DMh Air Ventures LLC · Spokane, WABuilt 1951 · S/N 20198 N1756DBoote Ronald H · Los Olivos, CABuilt 1951 · S/N 20199 N1757DGossett Harold D Jr · Granbury, TXBuilt 1951 · S/N 20200 N1759DInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N 20202 N1773DReeves Stephen E · Palm Harbor, FLBuilt 1951 · S/N 20216 N1776DRobbins Flight Training LLC · Bakersfield, CABuilt 1951 · S/N 20219 N1779DSchrag Jeremy M · Garden Plain, KSBuilt 1951 · S/N 20222 N1787DKissel Patrick J · Anchorage, AKBuilt 1951 · S/N 20230 N1793DThompson Joshua L · Delta Junction, AKBuilt 1951 · S/N 20235 N1796DRacoon Aviation LLC · San Antonio, TXBuilt 1951 · S/N 20238 N1797DBb Tacos And More Inc · Kalispell, MTBuilt 1951 · S/N 20239 N179MMDe Schweinitz Christian R · Anchorage, AKS/N 19423 N180HPorter Jeff S · Aguila, AZBuilt 1951 · S/N 19944 N210SBLofshult John C · Sloan, IAS/N 18799 N2222WJohnson Linzy A · Lake Stevens, WABuilt 1951 · S/N 19960 N239CSEversmeyer Larry D · Oklahoma City, OKBuilt 1950 · S/N 19555 N23ADBoyd Kirby · Fort Worth, TXBuilt 1951 · S/N 20063 N2530PKingsley Kiman J · Miller, MOBuilt 1950 · S/N 19775 N2646Sliger David W · Floral City, FLBuilt 1950 · S/N 19379 N2NMMayberry Harold M · Bryant, ILBuilt 1949 · S/N 18831 N2SSFlying M Aircraft LLC · Kuna, IDBuilt 1952 · S/N 19980 N3034JFlitton Mark S · Enterprise, ALFirst renewal noticeBuilt 1949 · S/N 18774 N3443DMiller Charles T · Bynum, TXBuilt 1951 · S/N 20102 N3843VKown W B · Hamilton, ALBuilt 1949 · S/N 18730 N3846VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1949 · S/N 18733 N3849VPaulas Daniel · Petaluma, CAS/N 18736 N3850VFlorida Air Tours Inc · Merritt Island, FLBuilt 1949 · S/N 18737 N3851VTexas Air Corps · Bullard, TXBuilt 1949 · S/N 18738 N3855VKeiths Aviation Training LLC · Altus, OKS/N 18742 N3857VSrv Air Service LLC · Stockton, NJBuilt 1949 · S/N 18744 N3861VVan Zant Mark · Zionsville, INBuilt 1949 · S/N 18748 N3867VMurat Armand · Granger, INBuilt 1949 · S/N 18754 N4154DBriggs John M · Vancouver, WABuilt 1951 · S/N 20037 N41RMK & M Aviation LLC · West Liberty, KYBuilt 1951 · S/N 19808 N456WFStevenson William Gary · Creswell, ORBuilt 1949 · S/N 18903 N4654VWay Robert L II · Morristown, AZFirst renewal noticeBuilt 1953 · S/N 19630 N49ECLovelady David D · Canton, TXBuilt 1949 · S/N 18852 N4QLumpkins Robert W · Laconia, NHBuilt 1949 · S/N 18778 N515NAikens Susan R · Delta Junction, AKBuilt 1951 · S/N 19987 N5405CRegistered aircraftBuilt 1950 · S/N 19439 N5406CGugel Joseph J · Wasilla, AKBuilt 1950 · S/N 19440 N5414CPeachey Daryl J · Belleville, PABuilt 1950 · S/N 19448 N5415CAom Aircraft LLC · Wilmington, DES/N 19449 N5416CHarper Jason Prentis · Oak Grove, LABuilt 1950 · S/N 19450 N5422CBelleau James R · Greeley, COBuilt 1950 · S/N 19456 N5429CHenrikson Peter R · Fort Worth, TXBuilt 1950 · S/N 19463 N5430CWilson William J · Aniak, AKBuilt 1950 · S/N 19560

Back to Cessna 170A