Skip to content

Registered aircraft · 843

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

N177KZBolinger Randy S · Roanoke, INBuilt 1976 · S/N 17702580 N177LJArnold James · Killeen, TXBuilt 1976 · S/N 17702565 N177LSChav LLC · Pomona, KSBuilt 1977 · S/N 17702620 N177MGEngberg James C · Brimfield, MABuilt 1976 · S/N 17702561 N177MPJones John K Jr · Shingletown, CABuilt 1976 · S/N 17702422 N177MSGilardi James D · Davis, CABuilt 1969 · S/N 17701436 N177PCJanney Tyson D · Fredericksburg, VAS/N 17701472 N177PLGunder Taylor · York, PABuilt 1976 · S/N 17702609 N177PMSale Reported · Cheyenne, WYSale reportedBuilt 1976 · S/N 17702442 N177PWJones Bertha Ann Yates · Clinton, OKBuilt 1975 · S/N 17702311 N177QFloyd Randy · Madison, ALBuilt 1974 · S/N 17702218 N177RCChase Bruce R · New Albany, PABuilt 1973 · S/N 17701895 N177RDMoulton Diana L · Pine Mountain Club, CAS/N 17701565 N177SHAdams Richard D · Kalamazoo, MIBuilt 1975 · S/N 17702294 N177SMFree State Flying Club Inc · College Park, MDBuilt 1974 · S/N 17702124 N177SVDlg Aviation LLC · Lena, WIBuilt 1970 · S/N 17701494 N177TJCobb Joseph Jr · Medina, OHBuilt 1976 · S/N 17702593 N177TPSavinsky Martin W · Erie, COBuilt 1975 · S/N 17702280 N177TSAero Cardinalis Inc · Midlothian, TXBuilt 1975 · S/N 17702295 N177UKValiair Lc Trustee · Casper, WYS/N 17702472 N177VTSeelig Richard W · Amherst, MABuilt 1973 · S/N 17701997 N177WMFarley Glen · Marysville, OHBuilt 1973 · S/N 17702011 N177XCColeman Timothy R · Morgantown, KYBuilt 1970 · S/N 17701538 N177XSWilson Kent M · Roanoke, VABuilt 1971 · S/N 17701669 N178DRH&H Trucking Inc · Clarkdale, AZBuilt 1970 · S/N 17701575 N18026Registered aircraftBuilt 1976 · S/N 17702525 N18038Overton Asset Group LLC · St Marys, IABuilt 1976 · S/N 17702526 N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N18226Filler Joseph J · Wyoming, PABuilt 1976 · S/N 17702537 N18510Moore Jack B · Irvine, CABuilt 1976 · S/N 17702539 N18518Sale Reported · Waterbury, CTSale reportedBuilt 1976 · S/N 17702540 N18523Km50 Ventures LLC · Pensacola, FLBuilt 1976 · S/N 17702541 N18529Briers Scott Kevin · Conroe, TXBuilt 1977 · S/N 17702542 N18576Cardinal-Bird LLC · Melbourne, FLBuilt 1976 · S/N 17702543 N18602Poston James M · Hixson, TNBuilt 1976 · S/N 17702544 N18643Registered aircraftN-number assigned, not yet registeredS/N 17702545 N18694Hughes Randall L · Post Falls, IDBuilt 1976 · S/N 17702547 N18720Bailey Bryan M · New Waverly, TXBuilt 1976 · S/N 17702548 N18725Ayers Francis H Jr · Palm Coast, FLBuilt 1976 · S/N 17702549 N18738Cardinal Flyers Inc · Northborough, MABuilt 1976 · S/N 17702552 N18739Monaco Michael · New Windsor, NYFirst renewal noticeBuilt 1976 · S/N 17702553 N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556 N19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557 N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559 N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563 N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564 N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566 N19387Debo Group Inc · Uniontown, OHBuilt 1976 · S/N 17702567

Back to Cessna 177B