Skip to content

Registered aircraft · 1,805

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

N4204FStephani Timothy M · White Lake, WIS/N 46104 N4205FMunoz Randy · Aledo, TXBuilt 1958 · S/N 46105 N4210FOsterhouse Daniel E · Mattawan, MIBuilt 1958 · S/N 46110 N4215FBoss Brothers Aviation LLC · Buffalo, MOBuilt 1958 · S/N 46115 N4218FPerry Michael C · Edgewater, FLS/N 46118 N4219FHazellief Quillie J Jr · Okeechobee, FLBuilt 1958 · S/N 46119 N4220FLeubner Karl T · Marietta, NYS/N 46120 N4222FBelford Zackery U · Elizabethtown, ILBuilt 1958 · S/N 46122 N4228FLangland Llewellyn D · Sarona, WIBuilt 1958 · S/N 46128 N4229FRoss Sam M · Pioneer, LABuilt 1958 · S/N 46129 N4230FBiffle Sam E · Midland, TXBuilt 1958 · S/N 46130 N4231FYancey Emron A · Sterling, AKS/N 46131 N4233FSilverman James R · Superior, MTS/N 46133 N4235FCastle Nial K III · Bonner Springs, KSBuilt 1958 · S/N 46135 N4237FScherr Steven J · Mandan, NDBuilt 1958 · S/N 46137 N4239FDitmars William R · Redding, CABuilt 1958 · S/N 46139 N4241FPankhurst Terrell K · Lauderdale, MSBuilt 1958 · S/N 46141 N4242FChronis Marc D · Pembroke, NHBuilt 1958 · S/N 46142 N4243FEagle Glen Veterinary Services Inc · Corona, CAS/N 46143 N4248FWilcox Ross P · Newark, DEBuilt 1958 · S/N 46148 N4254FRed Baron LLC · Davis City, IABuilt 1958 · S/N 46154 N4259FGuynes Ronald A · Two Rivers, WIBuilt 1958 · S/N 46159 N4260FAyers Frank E · Coulee Dam, WABuilt 1958 · S/N 46160 N4261FPeri Richard A · Burgess, VABuilt 1958 · S/N 46161 N4262FHayton James B · Sedro Woolley, WABuilt 1958 · S/N 46162 N4265FRedding Steven R · Skiatook, OKBuilt 1958 · S/N 46165 N4266FCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1958 · S/N 46166 N4267FValenzuela Kevin · Totowa, NJBuilt 1958 · S/N 46167 N4269FPerkey Gilbert J Jr · Eagle Rock, VAS/N 46169 N4271FStevens George C · Lake Leelanau, MIBuilt 1958 · S/N 46171 N4272FCayton John C · Cameron, MOS/N 46172 N4273FVan Wychen James G · Warrens, WIBuilt 1958 · S/N 46173 N4274FAppalachian Bible College Inc · Mount Hope, WVS/N 46174 N4275FG & M Associates LLC · Quitman, GAS/N 46175 N4277FMilitary And Civilian Aviation Heritage Foundation · Benton, PABuilt 1958 · S/N 46177 N4281FFour Winds Aviation LLC · Stigler, OKS/N 46181 N4282FThomas Christopher D · Pacific Palisades, CABuilt 1958 · S/N 46182 N4283FMckee Jay R · Dixon, WYS/N 46183 N4284FNolen Collin · Newman Lake, WABuilt 1958 · S/N 46184 N4290FRussi Kent S · Caldwell, IDBuilt 1958 · S/N 46190 N4296FMargraf Todd R · Miamisburg, OHBuilt 1958 · S/N 46196 N4298FGunn Sean · Colorado Springs, COBuilt 1958 · S/N 46198 N4299FRomano Louis A · Middletown, NJBuilt 1958 · S/N 46199 N4390VNamtvedt Erik · Wasilla, AKBuilt 1956 · S/N 28741 N44200Cessna172 LLC · Holliday, TXBuilt 1956 · S/N 28127 N4442FRegistration Pending · Sulphur, LARegistration pendingBuilt 1958 · S/N 46144 N44919Irvin Thomas D · Ripley, TNBuilt 1959 · S/N 46634 N44RCPeterson Matthew W · Ethel, LABuilt 1957 · S/N 29593 N4711CN4711c Inc · Stillwater, MNBuilt 1958 · S/N 36623 N487MTGilmore Bobby Keith · Swifton, ARBuilt 1958 · S/N 46040

Back to Cessna 172