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.

N9278AHanna Mark W II · Pendleton, INBuilt 1950 · S/N 19371 N9282AWest Sheryl M · Champlin, MNBuilt 1949 · S/N 19043 N9286ASimon Theodore E · Richmond, MIBuilt 1949 · S/N 19048 N9291AEvans James · Tuolumne, CABuilt 1949 · S/N 19052 N9298AHenderson Larry V · Highland Village, TXBuilt 1949 · S/N 19059 N9507ALott William F Jr Trustee · Oklahoma City, OKBuilt 1949 · S/N 19068 N9512ACook Timothy L · Oklahoma City, OKBuilt 1950 · S/N 19381 N9516AHogan Robert P · North Pole, AKBuilt 1950 · S/N 19384 N9518AFinney Kevin Anthony · Hawthorne, FLBuilt 1949 · S/N 19079 N9521AWadsworth Harley · Albuquerque, NMBuilt 1949 · S/N 19082 N9524AHamel Ryan A · Klamath Falls, ORBuilt 1949 · S/N 19085 N9531ASpeirs Colin Jackson · San Luis Obispo, CABuilt 1949 · S/N 19092 N9532ASchiller Darryl L · Belton, TXBuilt 1949 · S/N 19093 N9533APeterson Kristofor J · Talkeetna, AKBuilt 1949 · S/N 19094 N9534AWren James T · Gilbert, AZBuilt 1949 · S/N 19095 N953HAEkstrom Benjamin G · Anchorage, AKBuilt 1950 · S/N 19444 N9540AAlder George A · Palmer, AKBuilt 1949 · S/N 19101 N9543ABest Alvin A · Anchorage, AKRegistration revokedBuilt 1949 · S/N 19104 N9544ADaugherty Lee H · Charleston, WVRegistration revokedBuilt 1949 · S/N 19105 N9545AJetl Aviation LLC · Southern Pines, NCBuilt 1950 · S/N 19388 N9546AStevens Scott D · Corsicana, TXS/N 19107 N9547AChristiansen Brent D · Mabton, WABuilt 1949 · S/N 19108 N9554ABagley James L · Pampa, TXBuilt 1950 · S/N 19390 N9559AGrace'S Wings LLC · Crystal Lake, ILFirst renewal noticeBuilt 1949 · S/N 19120 N9567AProflight 1 Inc · Midland, NCBuilt 1949 · S/N 19128 N9575AConway Sheila R · Seattle, WABuilt 1949 · S/N 19136 N9579ABolan Steve A · Concrete, WABuilt 1949 · S/N 19140 N9581ADean Jeffrey · Husum, WABuilt 1949 · S/N 19142 N9584APenca Stephen J · Arlington, TXBuilt 1949 · S/N 19145 N9588ADehaven James R · Frisco, TXBuilt 1949 · S/N 19149 N9589AVercoe Jeffrey B · Lincoln, MTBuilt 1949 · S/N 19150 N9590AOneill Mark B · Pinckney, MIBuilt 1949 · S/N 19151 N9592ACocheret De La Moriniere Jan · Fruitland Park, FLBuilt 1949 · S/N 19153 N9596AYoung William Gregory · Renton, WABuilt 1950 · S/N 19399 N9597AGladis Glen W · Locust Grove, GABuilt 1950 · S/N 19400 N9599ABaldwin Trevor K · Owasso, OKBuilt 1949 · S/N 19160 N9709AMckibbon Paul Lee · Millsap, TXBuilt 1949 · S/N 19170 N9713ARueckl Randall L · Hortonville, WIBuilt 1950 · S/N 19403 N9714AReinoehl Gregg A · Reelsville, INBuilt 1949 · S/N 19175 N9715AGarry L Lewis · Livingston, LABuilt 1949 · S/N 19176 N9727ACaughlin David Drew · Boise, IDBuilt 1950 · S/N 19404 N9728ADailey Brian A · Strongsville, OHBuilt 1950 · S/N 19405 N9729ABaker Benjamin D · Catasauqua, PABuilt 1949 · S/N 19190 N9731ANorbury Frank R · Scottsdale, AZBuilt 1949 · S/N 19192 N9732AMoremen Joshua · Sagle, IDBuilt 1949 · S/N 19193 N9734AGreen Theodore G II · Burlington, WIBuilt 1949 · S/N 19195 N9738ADemio Douglas · Westbrook, CTBuilt 1949 · S/N 19199 N9741AHelzer Michelle A · Canby, ORBuilt 1950 · S/N 19406 N9743AYokom James C · Wichita, KSBuilt 1950 · S/N 19204 N9744AKahrs Andrew J · Bainbridge Island, WAS/N 19205

Back to Cessna 170A