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.

N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315 N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317 N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319 N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321 N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324 N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004 N1101CHampton Brock W · Wichita, KSBuilt 1977 · S/N 17702673 N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674 N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675 N110PFUniversity Of Detroit Flying Club Inc · Livonia, MIS/N 17702629 N11103Hennigan Shellie · Jonesboro, LAS/N 17702325 N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327 N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329 N11271No Coop Cardinal LLC · Sonoma, CABuilt 1975 · S/N 17702330 N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598 N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332 N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333 N11378Registered aircraftBuilt 1975 · S/N 17702335 N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338 N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340 N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342 N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343 N11564Ajw Management LLC · Scottsdale, AZBuilt 1975 · S/N 17702347 N11566Monterrosa Frank J · Lincoln, CABuilt 1975 · S/N 17702348 N11585Registered aircraftS/N 17702349 N11596Tagart Charles · Senoia, GAS/N 17702352 N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354 N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357 N11625Oil Region Aviators LLC · Titusville, PABuilt 1975 · S/N 17702360 N1162CReemts Randy G · Alexandria, MNBuilt 1977 · S/N 17702678 N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361 N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362 N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679 N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365 N11771Boss Gary W · Bronston, KYBuilt 1975 · S/N 17702366 N1178COliveira Frank Jr · Pawtucket, RIBuilt 1977 · S/N 17702680 N11799Borba Steven D · Woodland, CABuilt 1975 · S/N 17702369 N11823Redbird LLC · Denver, COBuilt 1975 · S/N 17702370 N11825Cardinal Rule LLC · Bryan, TXS/N 17702371 N11828Schmitz John J · Jefferson City, MOBuilt 1975 · S/N 17702372 N1183CZahorchak Jeffrey G · Harrisburg, PABuilt 1977 · S/N 17702681 N1184576 Cessna LLC · Punta Gorda, FLBuilt 1975 · S/N 17702377 N1185CSturtevant Roger C Jr · The Villages, FLS/N 17702682 N1187CNc Aviator LLC · Fuquay Varina, NCBuilt 1977 · S/N 17702683 N11907Housatonic Flying Club Inc · Danbury, CTBuilt 1975 · S/N 17702380 N1191CZerfas Gary B · Rockwall, TXBuilt 1977 · S/N 17702684 N11937Rdt Aviation LLC · Trumbull, CTS/N 17702381 N11950Plenkers Russell A · Molino, FLBuilt 1975 · S/N 17702382 N11968Good Guys Finish First Inc · Colorado Springs, COS/N 17702383 N1203CMirzaei-Nejad Hamid · Lake Stevens, WAS/N 17702685

Back to Cessna 177B