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.

N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493 N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496 N17049101 Inc · Bejou, MNBuilt 1976 · S/N 17702497 N17050Findlow Jerry E · Glasser, NJBuilt 1976 · S/N 17702498 N17052Skypilot LLC DBA · Benbrook, TXBuilt 1976 · S/N 17702499 N17068Adamski Thomas R · Grantham, NHBuilt 1976 · S/N 17702501 N17091Martin Stanley B · Lockhart, TXBuilt 1976 · S/N 17702502 N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503 N17137Miller Scott · Albia, IABuilt 1976 · S/N 17702506 N1714210ds Ltd · Centreville, VABuilt 1976 · S/N 17702507 N17172Tohidi Karen A · North Las Vegas, NVBuilt 1976 · S/N 17702508 N17173Dunbar Michael C · Cedar Falls, IABuilt 1976 · S/N 17702509 N17177Dawn Patrol Flying Club · Northville, MIBuilt 1976 · S/N 17702510 N17186Dubreuil Jean Pierre · Skyland, NCBuilt 1976 · S/N 17702513 N17187Cloud Chasers Inc · Albert Lea, MNBuilt 1976 · S/N 17702514 N17189Mangold Property Management Inc · Monterey, CABuilt 1976 · S/N 17702516 N17204Estes Bruce E · Granite Bay, CABuilt 1976 · S/N 17702518 N17219Daniel Boone Flying Club Inc · Boonville, MOBuilt 1976 · S/N 17702519 N175MTMeyer David A · Broomall, PABuilt 1977 · S/N 17702662 N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730 N1774DDj Brandt LLC · Cedar City, UTS/N 17702028 N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284 N177AWFarni Edward C III · Billings, MTBuilt 1970 · S/N 17701516 N177BStocks Aviation And Machine Inc · Wilmington, DES/N 17702350 N177BAAnderson David J · Saint Johns, FLS/N 17701449 N177BCCraig William Richard · Vandalia, OHBuilt 1972 · S/N 17701803 N177BGAccurso Steven M · Marietta, GAS/N 17702449 N177BHAircraft Trade Group LLC · Scandia, MNS/N 17701411 N177BLMontgomery David · Oak Park, ILBuilt 1976 · S/N 17702425 N177BWRegistered aircraftBuilt 1972 · S/N 17701756 N177CFGregoire Surgical Inc · Springfield, ILBuilt 1971 · S/N 17701632 N177DBarger Randall G · Newport News, VABuilt 1973 · S/N 17702012 N177DAParry Thomas J · White Post, VABuilt 1977 · S/N 17702617 N177DHAhp LLC · Kirkland, WAS/N 17702001 N177EELiebeler Susan Trustee · Malibu, CABuilt 1976 · S/N 17702511 N177EJDouble A Flight Services LLC · Edinburg, TXBuilt 1971 · S/N 17701626 N177ETThorstad Aviation LLC · Alexandria, MNBuilt 1976 · S/N 17702378 N177FJInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 17702122 N177FRLandrum David W · Hot Springs, ARBuilt 1974 · S/N 17702135 N177GLRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1974 · S/N 17702177 N177GSAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701845 N177GTWoischke Robert B · Schaumburg, ILBuilt 1973 · S/N 17702052 N177GWMarquette County Flying Club · Marquette, MIBuilt 1976 · S/N 17702481 N177HWCentral Virginia Aviation Inc · Petersburg, VAS/N 17701482 N177JFIsr Aviation LLC · Wilmington, DEBuilt 1975 · S/N 17702259 N177JJJ P Jaeger Farms LLC · Imperial, NEBuilt 1975 · S/N 17702314 N177JKRutsch Kirk A · Lewes, DEBuilt 1972 · S/N 17701828 N177JLRisko Michael Robert · Sturgis, MIBuilt 1977 · S/N 17702713 N177JRIntelliray Inc · Decatur, INBuilt 1970 · S/N 17701481 N177KFBurnet Eddie S · Edmond, OKBuilt 1970 · S/N 17701563

Back to Cessna 177B