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.

N9126ARehm William J · Bluffton, OHBuilt 1950 · S/N 19417 N9127ABehrens Gary K · Slidell, LABuilt 1949 · S/N 18886 N9128AAl-Banna Reyadh David · Huntingtown, MDFirst renewal noticeBuilt 1949 · S/N 18887 N9130AKelsey Keith R · Grants, NMBuilt 1949 · S/N 18889 N9131AMcmurray Patrick T · Brush Prairie, WABuilt 1949 · S/N 18890 N9133AMeyer Jeremy · Conway Springs, KSBuilt 1949 · S/N 18892 N9141ABarinaga Charles J · West Richland, WABuilt 1949 · S/N 18902 N9143ACacka David A · Klamath Falls, ORBuilt 1949 · S/N 18904 N9145AWomack Wilbur A Jr · Jackson, LABuilt 1949 · S/N 18906 N9146AHusser Marilyn G · Independence, ORS/N 18907 N9155AMaki Kevin L · Saginaw, MNBuilt 1950 · S/N 19354 N9156AStokes Jay M · Kingsland, TXBuilt 1949 · S/N 18917 N9160AAttitude Toys LLC · Wilmington, DEBuilt 1949 · S/N 18921 N9161ACabral Aviation LLC · Milton, WABuilt 1950 · S/N 19355 N9165AAdams Harry J · Montgomery, TXBuilt 1952 · S/N 19359 N9168AMatthews Jeff M · Conowingo, MDS/N 18929 N9170APasqualino Carolyn G · Ocala, FLS/N 19361 N9172AAndress Chad R · Casper, WYBuilt 1950 · S/N 19363 N9174AOutbound Aero LLC · Kiowa, COS/N 18935 N9177AErbey Jacob G · Hudson, WIBuilt 1950 · S/N 19364 N9186AGaylord Hangars LLC · Gaylord, MIBuilt 1949 · S/N 18947 N9187AKandarian Jordi · Cundiyo, NMBuilt 1949 · S/N 18948 N9189AHoulton Timbre Ross · Fairbanks, AKBuilt 1949 · S/N 18950 N9191ARupert Judson L · West Milton, PABuilt 1950 · S/N 19366 N9193ASchlafmann Jay R · Mercer, NDBuilt 1949 · S/N 18954 N9194AWeathered Brenton W · Poquoson, VABuilt 1949 · S/N 18955 N9197AAlmeida Gilbert M · Hilmar, CABuilt 1949 · S/N 18958 N9198AMorse Steven J · Gig Harbor, WAS/N 18959 N9202AWilson Alan Trustee · Waukesha, WIS/N 18963 N9204AConrad William A · Kaukauna, WIBuilt 1949 · S/N 18965 N9206ACurrie Andrew C · Oscoda, MIBuilt 1949 · S/N 18967 N9210ASmith Ted · Grant Park, ILBuilt 1949 · S/N 18971 N9212AMills Byron K · Harrison, ARBuilt 1949 · S/N 18973 N9220ABrown Douglas C · Daytona Beach, FLS/N 18981 N9222AMccully Kevin W · Payson, AZBuilt 1949 · S/N 18983 N9223ABrossard Adam · Olalla, WAS/N 18984 N9224AGauman Dylon M · Wasilla, AKBuilt 1950 · S/N 19369 N9225APeterson Scott W · Garfield, KSBuilt 1949 · S/N 18986 N9226ASchmidt James W · Dousman, WIS/N 18987 N9229APotter Gary W · Abilene, TXBuilt 1949 · S/N 18990 N9238ABryan Kirk J · Big Timber, MTBuilt 1949 · S/N 18999 N9242ARobinson William A · Franklin, TNBuilt 1949 · S/N 19003 N9244AKauffman Forrest J · Coolidge, AZBuilt 1949 · S/N 19005 N9249AZabowski Alan G · Belvidere, NJBuilt 1949 · S/N 19010 N9254AHattell George Curtis · Olympia, WABuilt 1949 · S/N 19015 N9261ACallahan Glenn P · Deridder, LABuilt 1949 · S/N 19022 N9266ADyrstad Mary S · Hampshire, ILBuilt 1949 · S/N 19027 N9269ABriggs Aviation LLC · Virginia Beach, VABuilt 1949 · S/N 19030 N9274AOshinuga Anthony · Valley Center, CAS/N 19035 N9277ATibor W Farkas · Georgetown, TXBuilt 1949 · S/N 19038

Back to Cessna 170A