Skip to content

Registered aircraft · 722

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 ('2072420')
  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 ('2072420')
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.

N107PSLadies In Aviation LLC · Mocksville, NCBuilt 1965 · S/N 17253618 N1102FGrant County State Bank · Carson, NDBuilt 1966 · S/N 17254697 N1104FMiller Jonathan A · Apo, APBuilt 1966 · S/N 17254699 N1105FGibbard Donald R · Walla Walla, WABuilt 1966 · S/N 17254700 N1107FMedic Choppers LLC · Springdale, ARS/N 17254702 N1108FAom Aircraft LLC · Wilmington, DES/N 17254703 N1110FSallade William L · Coudersport, PABuilt 1966 · S/N 17254705 N1114FRegistration Pending · Florence, SCRegistration pendingBuilt 1966 · S/N 17254709 N111HSMacav Flight Training LLC · Abilene, TXBuilt 1965 · S/N 17253989 N1120DCompher Charles D · Berryville, VABuilt 1966 · S/N 17254131 N1120FHaidle Wayne M · Bismarck, NDBuilt 1966 · S/N 17254715 N1122FDollosso Frank G · Lakeport, CABuilt 1966 · S/N 17254717 N1125FAeropark LLC · Michigan City, INBuilt 1966 · S/N 17254720 N1127FPricemeyer Aviation LLC · St Pete Beach, FLS/N 17254722 N1128FLockridge James · Adairsville, GAS/N 17254723 N1129FKoch Bradley D · Billings, MTBuilt 1966 · S/N 17254724 N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725 N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1137FSale Reported · New Hudson, MISale reported, canceledBuilt 1966 · S/N 17254732 N1139FGifford Kenneth A · Appleton, WIBuilt 1966 · S/N 17254734 N1142FHart James A · Arlington, VABuilt 1966 · S/N 17254737 N1143FWilson Dan · Saginaw, TXS/N 17254738 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N1155FDejesus Rodolfo B · Murfreesboro, TNBuilt 1966 · S/N 17254750 N1157FKiss George C · Bangor, PAS/N 17254752 N1158FAmerican Pride Aviation LLC · Newport Beach, CABuilt 1966 · S/N 17254753 N1159FRodimel Troy R · Greenwood, INS/N 17254754 N1160FOcala Aviation Services Inc · Ocala, FLS/N 17254755 N1161FBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254756 N1166FMortensen Alex · Burley, IDBuilt 1966 · S/N 17254761 N1167FRegistration Pending · Cotter, ARRegistration pendingBuilt 1966 · S/N 17254762 N1168FAnderson Jeffrey A · Runaway Bay, TXBuilt 1966 · S/N 17254763 N1169FJensen Richard · Cayucos, CABuilt 1966 · S/N 17254764 N1170FHowerton Kurt · Groveland, CABuilt 1966 · S/N 17254765 N1171FBlohm Paul J. · Tiffin, OHS/N 17254766 N1172FLincoln Meagan C · Kotzebue, AKBuilt 1966 · S/N 17254767 N1172GSkranak James Robert · St Maries, IDBuilt 1966 · S/N 17254094 N1173FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254768 N1177FSeaman Kenny James · Edgewood, TXBuilt 1966 · S/N 17254772 N1178FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254773 N1183FHopfinger Carl J · Pittsford, NYBuilt 1966 · S/N 17254778 N1184FSkydotcom LLC · Inver Grove Hghts, MNBuilt 1966 · S/N 17254779 N1186FLaclef Zebulon S · Leon, KSBuilt 1966 · S/N 17254781 N1188FHumphrey Rex B · Bonney Lake, WABuilt 1966 · S/N 17254783 N1190FDonnelly Patrick J · Tupper Lake, NYBuilt 1966 · S/N 17254785 N1191FStopa Gary · Florida, NYBuilt 1966 · S/N 17254786

Back to Cessna 172G