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.

N7154MTandberg Eric · Kent, WABuilt 1958 · S/N 55454 N7155MEverhart Leon J · Gould City, MIBuilt 1958 · S/N 55455 N7156MKeddie Mark V · North Huntingdon, PABuilt 1958 · S/N 55456 N7160MSchlesinger Bradley S · Denver, COBuilt 1958 · S/N 55460 N7165MKofoed Keith L · Moses Lake, WAS/N 55465 N7168MWindh Steven R · Reedley, CABuilt 1958 · S/N 55468 N7173MCronin Larry D · Mountain Home, IDBuilt 1958 · S/N 55473 N7177MErnst Thaine S · Fallon, NVBuilt 1958 · S/N 55477 N7178MCiolkosz Ryan · Anchorage, AKBuilt 1958 · S/N 55478 N7181MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55481 N7182MThayer Stephen Claude · High Point, NCBuilt 1958 · S/N 55482 N7183MSnavely Deborah B · Lake Placid, FLBuilt 1958 · S/N 55483 N7188MFilter Keith Jr · Lake Havasu City, AZS/N 55488 N7190MDiener John M · Stephenville, TXBuilt 1958 · S/N 55490 N7195MFussy Bernie P · Bowlus, MNBuilt 1958 · S/N 55495 N7197MKansas Soaring Association · Wichita, KSBuilt 1958 · S/N 55497 N7209MColman Aviation LLC · Pocatello, IDBuilt 1958 · S/N 55509 N7210MHensman Bruce E · Steamboat Springs, COBuilt 1958 · S/N 55510 N7211MGasvoda Richard S · Fairfield, MTBuilt 1958 · S/N 55511 N7212MWarhus Donn M · Palmer, AKBuilt 1958 · S/N 55512 N7214MOldenkamp Timothy J · Palmer, AKS/N 55514 N7216MStanton Andrew J · Platte City, MOBuilt 1958 · S/N 55516 N7218MFord Ethan G · Anchorage, AKS/N 55518 N7219MBrincefield Leland L · Waconia, MNBuilt 1958 · S/N 55519 N721JMWalton Frederick W · Upper Sandusky, OHBuilt 1959 · S/N 56038 N7221MStartin Evan A · Colfax, WABuilt 1958 · S/N 55521 N7223MMoosehead Enterprises LLC · Estero, FLBuilt 1958 · S/N 55523 N7227MRegistration Pending · Billings, MTRegistration pending, pending cancellationBuilt 1958 · S/N 55527 N7228MBarton Chris · Bedford, WYBuilt 1958 · S/N 55528 N7230MSpring-Air LLC · De Graff, OHBuilt 1958 · S/N 55530 N7233MGunderson David A · Box Elder, SDBuilt 1958 · S/N 55533 N7236MWright Steven William · Bend, ORFirst renewal noticeBuilt 1958 · S/N 55536 N7238MHubler Bruce F · Caldwell, IDBuilt 1958 · S/N 55538 N7239MPierce Steven P · Towanda, KSBuilt 1958 · S/N 55539 N7241MLabarre Ben A · Hayward, WIBuilt 1958 · S/N 55541 N7247MChristopher James R · College Park, GABuilt 1958 · S/N 55547 N7249MNewell Norman I Jr · Palm City, FLBuilt 1958 · S/N 55549 N724RTBrown Robert · Wayne, OKS/N 56160 N7251MSkoglun Jon E · Cashmere, WABuilt 1958 · S/N 55551 N7252MFoxglove Melanie Ann · Captain Cook, HIS/N 55552 N7254MPa Prospect Corp · Columbus, MTBuilt 1958 · S/N 55554 N7255MLdg Aviation LLC · Carefree, AZBuilt 1958 · S/N 55555 N7257MParker Charles B · North Pole, AKBuilt 1958 · S/N 55557 N7258MJj Flyers LLC · Corinth, MSBuilt 1958 · S/N 55558 N7259MRosario Ted · Salome, AZBuilt 1958 · S/N 55559 N7263MGolan Shachar Yaacov · Farmington Hills, MIBuilt 1958 · S/N 55563 N7267MLeasa Marc · Fond Du Lac, WIBuilt 1958 · S/N 55567 N7274MPearson Russell · Fairfield, MTS/N 55574 N7276MMcneil Larry D · Portal, AZBuilt 1958 · S/N 55576 N7282MDom Michael R · Kingman, AZRegistration expired, pending cancellationBuilt 1958 · S/N 55582

Back to Cessna 175