Skip to content

Registered aircraft · 537

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.

N6620EMccauley Billy R · Cliff, NMBuilt 1959 · S/N 56120 N6621ERoy Henry M · Carson, CABuilt 1959 · S/N 56121 N6624EKunzmann Robert · Prescott, AZS/N 56124 N6631EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56131 N6634EWinkles Ron M · Ardmore, OKBuilt 1959 · S/N 56134 N6640ELarkin Marion J · Salome, AZBuilt 1959 · S/N 56140 N6646ERegistration Pending · Elbert, CORegistration pendingBuilt 1959 · S/N 56146 N6648EEverest Builders LLC · Cheyenne, WYS/N 56148 N6651ESutton James Robert · Carson City, NVBuilt 1956 · S/N 56151 N6654EJackson Tal H · Spearman, TXS/N 56154 N6655EWard Doran · Glennallen, AKBuilt 1959 · S/N 56155 N6656EPhillips Robert B · Coshocton, OHS/N 56156 N6657ESasser Joshua J · Goldsboro, NCBuilt 1959 · S/N 56157 N6659ELeopardi Thomas P · Murray, UTS/N 56159 N6662EMalsby Julius C IV · Bend, ORBuilt 1959 · S/N 56162 N6666ERegistration Pending · Phoenix, AZRegistration pendingBuilt 1959 · S/N 56166 N6667EGunter Wayne E · Talkeetna, AKBuilt 1959 · S/N 56167 N6670EMacfadden Gary D · Condon, MTS/N 56170 N6671EAnderas Per R · Green Bay, WIBuilt 1959 · S/N 56171 N6672EKing Aubrey R · Salinas, CABuilt 1959 · S/N 56172 N6673EMiller Daniel F · Grain Valley, MOBuilt 1959 · S/N 56173 N6675ETornquist Robert John Jr · Turlock, CABuilt 1959 · S/N 56175 N6677EEmery Edward L · Marysville, WABuilt 1959 · S/N 56177 N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180 N6681EFoisy Douglas · Burleson, TXBuilt 1959 · S/N 56181 N6683EBergeson John S · Rhome, TXS/N 56183 N6684ERound Engine Aero · Nashville, MIS/N 56184 N6687EDriggers David J · Anchor Point, AKBuilt 1959 · S/N 56187 N6689EHeizler Mark W · Oswego, ILBuilt 1959 · S/N 56189 N6692EMarshall Jerry J Sr · Parker, AZBuilt 1959 · S/N 56192 N6697EMartin Jonathan · Trumann, ARBuilt 1959 · S/N 56197 N66987De Brouwer Isabelle Mc · Alpine, TXS/N 56198 N6699EWheeldon Chancy R · Jackson Hole, WYBuilt 1959 · S/N 56199 N6702ERegistration Pending · Danbury, CTRegistration pendingBuilt 1959 · S/N 56202 N6706EDalley Robert C · Waldron, INBuilt 1959 · S/N 56206 N6709EDixon Kevin S · Shady Shores, TXS/N 56209 N6711EGardner Terrence L · Pittsboro, NCS/N 56211 N6712EEdwards Joseph C · Austin, ARBuilt 1959 · S/N 56212 N6713ECendejas Agustin · Chino, CAS/N 56213 N6719EOleary Aviation Inc · Sibley, IABuilt 1959 · S/N 56219 N6720ESegerstrom Ricky G · Grandview, TXS/N 56220 N6721ESonoma Valley Aircraft Inc · Vineburg, CABuilt 1959 · S/N 56221 N6725ESocal Jet Services Inc · Long Beach, CABuilt 1959 · S/N 56225 N6728ELincoln Gene T · Delta, COBuilt 1959 · S/N 56228 N6731ELyon Joseph K · Pocatello, IDS/N 56231 N6735EPollock Patrick B · Temecula, CABuilt 1959 · S/N 56235 N6738EHaering Harold J Jr · Downers Grove, ILBuilt 1959 · S/N 56238 N68662Edwards Joseph C Trustee · Austin, ARBuilt 1958 · S/N 55543 N7000MWht LLC · Noonan, NDBuilt 1958 · S/N 55300 N7001MRush Michael J · Nashua, NHBuilt 1958 · S/N 55301

Back to Cessna 175