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.

N667PBButzin Paxton E · Wild Rose, WIBuilt 1951 · S/N 20116 N7071FPadgett Troy A · Midway, TXS/N 20240 N708HKKliner Henry J · Wilmot, SDBuilt 1950 · S/N 19742 N711DCDufford Michael W · Alpine, CABuilt 1951 · S/N 20144 N711DRAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1949 · S/N 19171 N729HPorter Wade R · Durham, CABuilt 1949 · S/N 19044 N747ZFriesen Joshua D · Wallace, NEBuilt 1951 · S/N 19922 N75875Schumacher Matthew · Wenatchee, WAS/N 18877 N787AGGrenie Arles A · Richland Center, WIS/N 19122 N7AIntabyte LLC · Portland, ORBuilt 1949 · S/N 18837 N8931TAircraft Partner Holdings Inc Trustee · BerlinBuilt 1950 · S/N 19431 N9004AStuckert Robert D · Scottdale, PABuilt 1949 · S/N 18759 N9005AFerraro Donald M · Bangor, PABuilt 1949 · S/N 18894 N9007AWeiszmann Erik · Bedford, NHBuilt 1949 · S/N 18762 N9011AWilmsen Paul R · Millington, ILBuilt 1949 · S/N 18766 N9018AGodbold Robert L · Apex, NCBuilt 1949 · S/N 18773 N9024AHarbick Joshua W · Bend, ORBuilt 1949 · S/N 18779 N9026AMoyer Michael · Duarte, CABuilt 1949 · S/N 18781 N9027ABrowning Charles R · Fond Du Lac, WIBuilt 1949 · S/N 18782 N9030ALimbach Cynthia S · Verona, ILBuilt 1949 · S/N 18785 N9031AKiesling Michael J · Omro, WIBuilt 1949 · S/N 18786 N9032AProag Services Inc · Mahnomen, MNBuilt 1949 · S/N 18787 N9033AEverson David · Redding, CABuilt 1949 · S/N 18788 N9048AGrady Keith L · Phoenix, AZBuilt 1949 · S/N 18807 N9053AN292ac Flyers LLC · Brandon, MSBuilt 1949 · S/N 18812 N9056AGreenough Wade E · Kasilof, AKS/N 18815 N9059AKown William B · Hamilton, ALS/N 18818 N9062ASale Reported · Wasilla, AKSale reportedBuilt 1949 · S/N 18821 N9068ALucas Terry L · Oakdale, CABuilt 1949 · S/N 18827 N9070AKerr Colleen A · Waukesha, WIBuilt 1949 · S/N 18829 N9075AKingdom Air Corps · Sutton, AKBuilt 1949 · S/N 18834 N9076AList Oliver · Wasilla, AKBuilt 1949 · S/N 18835 N9077ADay Jeffrey R · Haslet, TXBuilt 1949 · S/N 18836 N9079AMandere Mark Edward · Spokane Valley, WABuilt 1949 · S/N 18838 N9083AStorch Shaidon P · Deer Park, WAS/N 18842 N9086ATaylor Scott G · Draper, UTBuilt 1949 · S/N 18845 N9088ACox-Kuss Sarah Ann · Colorado City, TXBuilt 1949 · S/N 18847 N9097AWard Daniel Wayne · Boonville, NCS/N 18856 N9098AWestphal Keith H · Mazomanie, WIBuilt 1949 · S/N 18857 N9100ARettzo Bernard J · Chandler, AZBuilt 1949 · S/N 18859 N9105AHerr Andrew A · River Ridge, LABuilt 1949 · S/N 18864 N9106ARegistered aircraftBuilt 1949 · S/N 18865 N9108AHendrickson Larry L · Chester, MTBuilt 1949 · S/N 18867 N9109ADra Classic Aircraft LLC · Gravette, ARBuilt 1949 · S/N 18868 N9110ASmith Sidney R · Rllng Hls Est, CABuilt 1949 · S/N 18869 N9114AHayes Sean M · Kodiak, AKBuilt 1949 · S/N 18873 N9119ATorraca Peter · New York, NYBuilt 1958 · S/N 19349 N91221Marvin Ray · Tomahawk, WIS/N 19034/2 N9123ASale Reported · Draper, UTSale reportedBuilt 1956 · S/N 18882 N9124AWest Kevin B · San Antonio, TXBuilt 1949 · S/N 18883

Back to Cessna 170A