Skip to content

Registered aircraft · 536

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

N103DLDunwoody Duane E D · Savage, MNS/N 55913 N1059RDoyle Brian G · Windsor, MABuilt 1958 · S/N 55629 N1100SHagen Johnny D · Claremore, OKBuilt 1958 · S/N 55410 N1112HStrojny Andrew P III · Medina, OHS/N 56188 N1175Hamilton John G · Davenport, CABuilt 1958 · S/N 55185 N11VBuckner Eldon L · Baker City, ORBuilt 1959 · S/N 55819 N12NBFarrell Richard A · Dacono, COS/N 55815 N137SAAlen Sergio Raul · Davie, FLBuilt 1958 · S/N 55633 N141JAVan Ovost Jacqueline · Fort Pierce, FLBuilt 1958 · S/N 55224 N158DMKeppers Craig J · Anchorage, AKBuilt 1958 · S/N 55647 N160WBBeach Banners Inc · Jacksonville, FLBuilt 1958 · S/N 55238 N17559Barnhill Eric J · Seneca, SCBuilt 1959 · S/N 55863 N175ASpencer Rimmel L · Haskell, OKS/N 55544 N175AHAvonics LLC · Afton, WYS/N 56130 N175CBPr Aeronautics LLC · Buffalo, SDBuilt 1959 · S/N 56147 N175DHSegerstrom Ricky G Trustee · Grandview, TXBuilt 1959 · S/N 56280 N175FMark Kossler · Bozeman, MTBuilt 1958 · S/N 55494 N175FWWilfer Dennis · Fairbanks, AKBuilt 1958 · S/N 55020 N175GGoode Greg · Kalispell, MTBuilt 1959 · S/N 56030 N175JVDelta Charlie Aviation Services LLC · Culpeper, VABuilt 1959 · S/N 56222 N175MHall Nathan M · Palmer, AKBuilt 1958 · S/N 55282 N175PBurdick Rich · Montrose, COBuilt 1958 · S/N 55064 N175SHSmith Edward · Lecompton, KSBuilt 1958 · S/N 55233 N175SMWhitley Steven · Auke Bay, AKS/N 55167 N175TAAnderson Tracy E · Houston, TXBuilt 1958 · S/N 55079 N175TBSalyer Robert D · Nashville, TNS/N 55306 N175TGMoschetti Flight Outfitters LLC · Kingston, WABuilt 1958 · S/N 55081 N175THLa France Edward J · Ellensburg, WABuilt 1960 · S/N 56237 N175TTFarrell Dolliver T · Sterling, AKBuilt 1958 · S/N 55193 N175TWSalyer Robert O · Nashville, TNS/N 55360 N175UKChase Michael E Trustee · Montague, MIS/N 55829 N1959Smith Robert P · Lago Vista, TXBuilt 1959 · S/N 56114 N19JGImmeyer Daniel O · Redmond, WABuilt 1958 · S/N 55131 N19ZBBruton Kevin L · Roseburg, ORBuilt 1959 · S/N 55732 N24143Angel Aviation Inc · Peoria, AZS/N 55436 N28DPMachler Lance J · Murphys, CABuilt 1959 · S/N 55977 N30TGCarter Jesse E · Milford, OHBuilt 1958 · S/N 55679 N34CLBarrett Benjamin C · Gorham, MEBuilt 1958 · S/N 55363 N40184Stoots David A · Fairbanks, AKBuilt 1958 · S/N 55245 N406BNClover Crest II Inc · Key Largo, FLBuilt 1959 · S/N 56122 N416DCWeaver Eric W · Anchorage, AKBuilt 1959 · S/N 55940 N444REJenson Greg Ray · Pueblo, COS/N 55174 N470HDChandler Dennis · Castroville, TXBuilt 1958 · S/N 55288 N470JBLong James · Lyman, WYS/N 55041 N522JHMinor Steve A · Twain Harte, CAS/N 55902 N540DHoopes Kristopher · Davis, OKBuilt 1959 · S/N 55907 N54973Szymanski Tadeusz C · Fort Myers, FLS/N 55217 N58FAAlman Michael C · Fruitport, MIBuilt 1958 · S/N 55255 N59175Brown Charles A · Boise, IDBuilt 1959 · S/N 55932 N5HVOppegard Nicholas D · Eagle River, AKBuilt 1958 · S/N 55366

Back to Cessna 175