Skip to content

Registered aircraft · 245

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

N7038TNostdahl Robert W · Bottineau, NDBuilt 1961 · S/N 56331 N7040EPegasus Royalty Group LLC · Bozeman, MTBuilt 1960 · S/N 56540 N7041EDykstra Wayne A · Pipestone, MNS/N 56541 N7042EBennett Cass · Oxnard, CABuilt 1960 · S/N 56542 N7043ETri State Airmotive LLC · Berryville, ARS/N 56543 N7047EWhitley Steven · Auke Bay, AKBuilt 1960 · S/N 56547 N7048EHarrison Donald R · Lake Havasu City, AZBuilt 1960 · S/N 56548 N7051EKuskie Charles R · Chadron, NEBuilt 1960 · S/N 56551 N7052ESchmidt Jerry D · Spur, TXBuilt 1959 · S/N 56552 N7055EKleinschmidt Eric W · Livermore, CABuilt 1960 · S/N 56555 N7056EBabbitt Paul A · Rohnert Park, CABuilt 1960 · S/N 56556 N7057EKoser Michael D · Asheboro, NCBuilt 1960 · S/N 56557 N7059EPennell Zackaria S · Canyon Lake, TXS/N 56559 N7060EBrenner Valerian · Port Saint Lucie, FLBuilt 1960 · S/N 56560 N7064EBolognese Joseph · Las Vegas, NVS/N 56564 N7066EBarnes Stephen W · Mustang, OKBuilt 1960 · S/N 56566 N7067E5 Am Equipment LLC · Casper, WYBuilt 1960 · S/N 56567 N7068EMarino Farms LLC · Macon, MOS/N 56568 N7069EPinnell John T · Bakersfield, CAS/N 56569 N7070EKuchn Todd S · Wabasso, MNBuilt 1960 · S/N 56570 N7071EPlumstead Lawrence P · Seminole, FLS/N 56571 N7073EWestrum Durl T · Norwalk, IAS/N 56573 N7080EHamdan Isam · Tulsa, OKBuilt 1960 · S/N 56580 N7081EMedley Matthew C · Shelbyville, INBuilt 1960 · S/N 56581 N7084EKnight Darrell K · Temple, TXBuilt 1960 · S/N 56584 N7085EArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 56585 N7093ERollins James A Trustee · Laconia, NHBuilt 1960 · S/N 56593 N7098EHucul Kenneth G · Phoenix, AZBuilt 1960 · S/N 56598 N7904TRoarty Eugene H · Poquoson, VABuilt 1960 · S/N 56604 N7905TEarnshaw John F Jr · Cheyenne, WYBuilt 1960 · S/N 56605 N7907TKdrd Holdings LLC · Texas City, TXS/N 56607 N7908TGausman Ryan O · Thorp, WABuilt 1960 · S/N 56608 N7913TBorsheim Richard R · Red Lodge, MTBuilt 1960 · S/N 56613 N7916TJohnson Colton M · Katy, TXBuilt 1960 · S/N 56616 N7917TAndersen Dana K · Scappoose, ORBuilt 1960 · S/N 56617 N7918TStrand Michael · Conroe, TXBuilt 1960 · S/N 56618 N7922TMeadow Mountain Logistics LLC · Snowmass Village, COBuilt 1960 · S/N 56622 N7923TPop Ciprian S · Reno, NVBuilt 1960 · S/N 56623 N7927TEaton Danny E II · Trinity, NCBuilt 1960 · S/N 56627 N7929TFirst State Ag Air Inc · Viola, DEBuilt 1960 · S/N 56629 N7931TArnold Terry L · Stanley, NMBuilt 1960 · S/N 56631 N7933TGaetz Johnathan · Gurnee, ILBuilt 1960 · S/N 56633 N7937TTailwind Aviation Inc · Wasilla, AKBuilt 1960 · S/N 56637 N7939THarris Kenneth L · Greeley, COS/N 56639 N7941TGoerger Allan E · Barney, NDS/N 56641 N7942TLinebaugh Ricky L · Dover, PABuilt 1960 · S/N 56642 N7946TWright Anthony · Tallahassee, FLS/N 56646 N7947THarris Billy M · Waco, TXBuilt 1960 · S/N 56647 N7948TJolley Jonas D · Woodstock, GABuilt 1960 · S/N 56648 N7949TMacleod Brian D · Maumee, OHBuilt 1960 · S/N 56649

Back to Cessna 175A