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.

N13612Harry Philip Scott · Asheville, NCBuilt 1976 · S/N 17702443 N1361CHuckaby William C Trustee · Loudon, TNBuilt 1977 · S/N 17702712 N13621Fowler Gerald · Springfield, MOBuilt 1976 · S/N 17702444 N13647Winn William D · Fallbrook, CABuilt 1976 · S/N 17702447 N13656Groth Abigail · Oxford, GAS/N 17702448 N13667Fuller Air Inc · Wilmington, DEBuilt 1976 · S/N 17702450 N13669Hypersonic Handler Inc · Essex, IABuilt 1976 · S/N 17702451 N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453 N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454 N13710Registered aircraftBuilt 1976 · S/N 17702456 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N1373CDoft Peter · San Diego, CAS/N 17702714 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466 N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467 N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468 N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469 N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715 N1377CCavok LLC · Wilmington, DES/N 17702716 N13804Henderson Jeannie · Colorado Springs, COS/N 17702470 N13819Avco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702471 N1381CEagle Sky Patrol Inc · Deadwood, SDBuilt 1977 · S/N 17702718 N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719 N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475 N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724 N1438CTony And Oats Great Adventure LLC · Danville, INBuilt 1977 · S/N 17702727 N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728 N1454CFreespirit Ventures LLC · Bear, DEBuilt 1977 · S/N 17702731 N1455CCaruso Anthony J · Southampton, NYS/N 17702732 N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735 N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737 N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739 N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038 N16019Brown Kenneth D · Port Murray, NJS/N 17702478 N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479 N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480 N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482 N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485 N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487 N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491

Back to Cessna 177B