Skip to content

Registered aircraft · 3,572

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

N13618Janzen Royce D · Henderson, NEBuilt 1974 · S/N 17262886 N13619Cougoule Cynthia · Hollister, CABuilt 1974 · S/N 17262887 N13623Cloer Mark Flynt Sr · Madison, MSBuilt 1974 · S/N 17262890 N13633Zanley William · Fraser, MIBuilt 1974 · S/N 17262894 N13635Hartnett Richard James · Preston, CTBuilt 1974 · S/N 17262896 N13639Bishop Services LLC · Ellisville, MSS/N 17262900 N13644Kelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17262904 N13645Pigg Brian S · Morris, ILBuilt 1974 · S/N 17262905 N13646Menfi Joseph · Hopedale, MABuilt 1974 · S/N 17262906 N1364UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267035 N13658Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1974 · S/N 17262918 N13659Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17262919 N1365UDiaz Efrain F Ortiz · Toa Baja, PRBuilt 1976 · S/N 17267036 N13660Fly Right LLC · Ridgefield, CTBuilt 1974 · S/N 17262920 N13662Grutza Robert J · Maysville, KYBuilt 1974 · S/N 17262922 N13668Red-Tailed Hawks Aviation Academy · Mukilteo, WABuilt 1974 · S/N 17262927 N1366UAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1976 · S/N 17267037 N13672Cape Aerial Tours DBA · Chatham, MABuilt 1974 · S/N 17262931 N13674Bentley Robert H · Lockport, ILBuilt 1974 · S/N 17262933 N13675Valz Thomas M · Cleveland, OKBuilt 1974 · S/N 17262934 N13680Macvicar Angus C · Nantucket, MABuilt 1974 · S/N 17262937 N13682Moynihan Quinn A · Apple Valley, MNBuilt 1974 · S/N 17262939 N13683American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262940 N13684Matyas Martin M · Helena, OHS/N 17262941 N13685Lee Valley Inc · Tekamah, NEBuilt 1974 · S/N 17262942 N13686T Craft Aero Club Inc · Nampa, IDBuilt 1974 · S/N 17262943 N1368URed Baron Flyers · Caledonia, MNBuilt 1976 · S/N 17267039 N13692American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262946 N13693Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17262947 N13696Johnson Mildred J Executor · Boerne, TXBuilt 1974 · S/N 17262950 N13698Park Avenue Group Inc · Stuart, FLBuilt 1974 · S/N 17262952 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13748Ries Farms LLC · Hastings, MNS/N 17262989

Back to Cessna 172M