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.

N35193Mccormack Duncan M · Sunfield, MIS/N 17702257 N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260 N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261 N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263 N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267 N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268 N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270 N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271 N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272 N35225Nguyen Ricky L · Honolulu, HIS/N 17702275 N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283 N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278 N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286 N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288 N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289 N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293 N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296 N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297 N35273Weltmer Aaron Reece · Rocklin, CABuilt 1975 · S/N 17702303 N35278Sparks Tommy R · Palestine, ILBuilt 1975 · S/N 17702305 N35281Freebird Wings LLC · Creswell, ORBuilt 1975 · S/N 17702306 N35284Flying Redbirds LLC · Wentzville, MOBuilt 1975 · S/N 17702307 N35287White James E · Eminence, KYBuilt 1975 · S/N 17702308 N352964 Point Transportation LLC · Excelsior Springs, MOS/N 17702312 N36213N36213 Aircraft Ownership LLC · The Woodlands, TXBuilt 1975 · S/N 17702240 N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N371LSatellite Flying Club Inc · East Patchogue, NYBuilt 1970 · S/N 17701488 N3765SKennedy Patrick M · Great Barrington, MABuilt 1971 · S/N 17701629 N400HA15 Corp · Lansing, MIBuilt 1970 · S/N 17701484 N405DTSkiles Carl A · Leander, TXS/N 17702389 N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536 N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320 N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475 N416WTHigh Desert Flight Instruction LLC · Albuquerque, NMBuilt 1975 · S/N 17702355 N418CCRedfield James A · Simi Valley, CABuilt 1976 · S/N 17702464 N424SCThread Head Quilting LLC · Anchorage, AKBuilt 1975 · S/N 17702367 N429BASchmidt John M · Palm Coast, FLS/N 17702654 N472JSTaylor Kirk B · Houston, TXS/N 17701730 N478TCRotschafer Randall P · Omaha, NEBuilt 1975 · S/N 17702388 N47CTSweetwater Flyers LLC · Emporia, KSBuilt 1972 · S/N 17701769 N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493 N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318 N49XMMclean Michael D · Modesto, CABuilt 1972 · S/N 17701736 N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087 N514TCChildress Anthony H · Frisco, TXBuilt 1973 · S/N 17701995 N5377CAnderson Robert C · Zanesfield, OHBuilt 1977 · S/N 17702623 N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981 N548ECRaney James R · Tucson, AZBuilt 1976 · S/N 17702505 N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344 N567BBBeers Suzanne M · Colorado Springs, COBuilt 1973 · S/N 17701880

Back to Cessna 177B