Skip to content

Registered aircraft · 1,026

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

N102LAIowa Lakes Community College · Estherville, IAS/N 17259038 N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828 N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670 N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672 N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673 N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674 N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678 N1179MBartholomew Thomas C · Stanwood, WABuilt 1969 · S/N 17258679 N1180MFlying Weaners Inc · Jacksonville, FLBuilt 1969 · S/N 17258680 N1181MChin David · San Jose, CABuilt 1969 · S/N 17258681 N1182MHilton David T · Brooksville, FLBuilt 1969 · S/N 17258682 N1185MOwen Steve · White City, ORBuilt 1969 · S/N 17258685 N1187MMorgan Donald F · Reno, NVBuilt 1970 · S/N 17258687 N1188MTrim Tab LLC · Fort Collins, COBuilt 1969 · S/N 17258688 N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690 N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691 N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692 N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693 N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694 N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698 N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308 N1222LBoland Charles R · Blairsville, GABuilt 1969 · S/N 17258385 N123FCCurtis James · Abilene, KSBuilt 1970 · S/N 17259182 N124RCEc Aviation Inc · Stockbridge, GABuilt 1970 · S/N 17258537 N126KWersinger Duncan · Rochester, NYBuilt 1968 · S/N 17257392 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N169AJNolan Davis Dds LLC · Juneau, AKBuilt 1969 · S/N 17257981 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N172ADRust Michael David · Rush City, MNBuilt 1969 · S/N 17258365 N172BACarrolls Auto And Aircraft Sales LLC · Muncie, INS/N 17259091 N172BTBroderick Edward P · Halifax, MABuilt 1970 · S/N 17258936 N172CJAlsworth Caleb J · Port Alsworth, AKBuilt 1968 · S/N 17257173 N172ESAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258019 N172FMStern Jason C · Roscoe, ILBuilt 1969 · S/N 17258008 N172GCDairy Air Inc · Wyoming, PABuilt 1968 · S/N 17257234 N172HLStankiewicz Adam · Merrimack, NHBuilt 1970 · S/N 17259079 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724 N172KPBitzan Joseph D · Charlotte, NCBuilt 1968 · S/N 17257218 N172MFRhody Skyhawk Flying Club LLC · Middletown, DES/N 17258001 N172NSWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17257968 N172PFMillard Richard A · Waverly, TNBuilt 1969 · S/N 17258891 N172QWRiese Jennifer P · Auburn, ALBuilt 1969 · S/N 17257999 N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302 N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428 N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939 N172ZMoss Mark A · El Dorado, CABuilt 1969 · S/N 17258726

Back to Cessna 172K