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.

N7284MColeman Douglas A · Hubbard, ORBuilt 1958 · S/N 55584 N7285MLefritz Richard A · Welches, ORFirst renewal noticeBuilt 1958 · S/N 55585 N7287MFrenzel Carl O · Midlothian, TXBuilt 1958 · S/N 55587 N7288MStraight Tail LLC · Boise, IDBuilt 1958 · S/N 55588 N7291MLee Brainard E · Everett, WABuilt 1958 · S/N 55591 N7295MLambert James · Fort Mohave, AZBuilt 1958 · S/N 55595 N7296MHurlburt Ronald V DBA · Durand, WIS/N 55596 N7297MVivion Michael T · Bozeman, MTBuilt 1958 · S/N 55597 N7299MJahnke Eric F · West Palm Beach, FLRevoked, canceledBuilt 1958 · S/N 55599 N7301MLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55601 N7302MKoenig Donald J · Las Animas, COBuilt 1958 · S/N 55602 N7303MHerbert Robert Leo · Ammon, IDBuilt 1958 · S/N 55603 N7309MDunn Louis Jr · Mooresville, NCS/N 55609 N7314MFrickel Daniel R · Atkinson, NEBuilt 1958 · S/N 55614 N7315MRolling Cole LLC · Kalispell, MTBuilt 1959 · S/N 55615 N7316MSteven Bryant · Boise, IDS/N 55616 N7318MOttis David J · Norfolk, NES/N 55618 N7319MCordes Hannah K · Winthrop, WABuilt 1958 · S/N 55619 N7321MWood Robert B · Woods Cross, UTBuilt 1958 · S/N 55621 N7322MDeasy Brendan W · Berlin, NHBuilt 1958 · S/N 55622 N7324MBehrends Brandon R · Duluth, MNBuilt 1958 · S/N 55624 N7326MCammack Steve · Round Rock, TXBuilt 1958 · S/N 55626 N7330MJorgenson Brian K · Sandpoint, IDBuilt 1958 · S/N 55630 N7332MNorthern Flyers LLC · Bemidji, MNS/N 55632 N7336MYates Christopher Lynn · Edmond, OKS/N 55636 N7337MRexwinkle Thomas L · S Coffeyville, OKBuilt 1958 · S/N 55637 N7341MSobczyk Scott R · Hartford, WIBuilt 1958 · S/N 55641 N7343MSheets Laura J · Follett, TXBuilt 1958 · S/N 55643 N7344MKiever Robert P Jr · Summerfield, FLBuilt 1958 · S/N 55644 N7348MCrosby Anthony Brian · Devine, TXBuilt 1958 · S/N 55648 N7350MPacific Valley Aviation Inc · Arbuckle, CABuilt 1958 · S/N 55650 N7351MLowder Grady L · Newport, NCBuilt 1958 · S/N 55651 N7352MHamilton Dirk E · Bryant, ARBuilt 1958 · S/N 55652 N7353MWow Construction Inc · Ingleside, TXS/N 55653 N7362MFallis James B III · Wichita, KSBuilt 1958 · S/N 55662 N7364MFrahm Lon R · Colby, KSBuilt 1958 · S/N 55664 N7365MDanieli Barry B · El Verano, CABuilt 1958 · S/N 55665 N7367MSandoz Rodney A · Chadron, NEBuilt 1958 · S/N 55667 N7368MHenning Timothy D · Prior Lake, MNBuilt 1958 · S/N 55668 N7369MLacey Joe S · Wilsonville, ALBuilt 1958 · S/N 55669 N7371MNagy Meserole Teresa A · Stevensville, MDBuilt 1958 · S/N 55671 N7372MZavala Marco A · Phoenix, AZBuilt 1958 · S/N 55672 N7373MFarwell Linda B · Leavenworth, KSBuilt 1959 · S/N 55673 N7374MHofstetter Michael T · Saint James, MOBuilt 1958 · S/N 55674 N7378MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55678 N7382MPansza Michaelangelo · Poteet, TXBuilt 1958 · S/N 55682 N7383MRegistered aircraftS/N 55683 N7385MMorgan Jeffrey E · Peebles, OHS/N 55685 N7387MHanderson Ronald J · Sitka, AKBuilt 1958 · S/N 55687 N7388MLange Marc B · Spokane Valley, WABuilt 1958 · S/N 55688

Back to Cessna 175