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.

N1205CNorthern Aire Flying Club Ltd · Black Creek, WIBuilt 1977 · S/N 17702686 N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385 N123DSDenton Farms LLC · Williamsburg, MIBuilt 1975 · S/N 17702373 N1246CTriplett Michael D · Eastsound, WAS/N 17702689 N124KAJohnson Michael Scott · Edgewood, TXBuilt 1974 · S/N 17702181 N1255CHaslett Lisa L · Vinita, OKBuilt 1977 · S/N 17702691 N1256CC177 Heavy LLC · Colfax, NCS/N 17702692 N125JDLeppien John C · Alma, MIBuilt 1974 · S/N 17702130 N1269CNovember 1269 Charlie LLC · East Montpelier, VTBuilt 1979 · S/N 17702693 N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386 N127826350 LLC · Yorklyn, DES/N 17702387 N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N13019Plumer Eric · The Plains, VABuilt 1975 · S/N 17702395 N13061Kelly Thomas E · Tequesta, FLFirst renewal noticeBuilt 1975 · S/N 17702396 N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397 N13108Registered aircraftBuilt 1976 · S/N 17702398 N13128Huffman David L · Corsicana, TXBuilt 1976 · S/N 17702400 N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402 N13282Cook Thomas H · Harbor Springs, MIBuilt 1976 · S/N 17702406 N13285Royalty Flight Solutions LLC · West Babylon, NYBuilt 1976 · S/N 17702407 N132SMBartholet John C · Columbus, GABuilt 1973 · S/N 17702045 N13305Harbin Michael Wade · Monahans, TXBuilt 1976 · S/N 17702409 N13307Burden Richard M Trustee · Woodway, TXBuilt 1976 · S/N 17702410 N13314Egan Richard G · Tallahassee, FLBuilt 1976 · S/N 17702412 N13342Aog Hawaii LLC · Paia, HIBuilt 1976 · S/N 17702414 N13362Edwards Samuel T · Mustang, OKBuilt 1976 · S/N 17702415 N13379Gittleson Vernon H · Franklin Grove, ILBuilt 1976 · S/N 17702416 N13411Leiss Todd J · Merritt Island, FLBuilt 1976 · S/N 17702419 N13430Mjr Assoc LLC · Bend, ORBuilt 1976 · S/N 17702420 N13454Parry Matthew J · Oxnard, CABuilt 1976 · S/N 17702423 N1345CBeck Elwood M Jr · Athens, GAS/N 17702706 N13468Wanner Kevin M · Morristown, NJBuilt 1976 · S/N 17702424 N13484Aero-Flite Corp · Murfreesboro, TNBuilt 1976 · S/N 17702426 N13493Pelaez Gilberto · Chatsworth, CABuilt 1976 · S/N 17702427 N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430 N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431 N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708 N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433 N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709 N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434 N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437 N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438 N1357CSummit Concepts Inc · Wilmington, DES/N 17702710 N13596Gary Rollin F · Dallas, TXS/N 17702440 N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441 N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711

Back to Cessna 177B