Skip to content

Registered aircraft · 718

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

N5135QOlivas Frank · Fabens, TXBuilt 1965 · S/N 17252916 N5148FBonura Rocco F Jr · Perkinston, MSBuilt 1964 · S/N 17252980 N5154FGilstrap William D · Catoosa, OKBuilt 1965 · S/N 17253004 N5166FColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17253052 N5178FTurrentine Danny H · Wolfe City, TXBuilt 1965 · S/N 17253100 N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108 N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116 N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124 N519MPUpdike Jesse J · Kenai, AKS/N 17253042 N5202FUnited States Air Force (Owner) · Millington, TNBuilt 1965 · S/N 17253189 N5203FDale County Sheriffs Office · Ozark, ALBuilt 1965 · S/N 17253192 N5204FUnited States Air Force · Offutt Afb, NEBuilt 1965 · S/N 17253195 N5207FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253206 N5208FUnited States Air Force Owner · Beale Afb, CABuilt 1965 · S/N 17253209 N5215FUnited States Air Force · Rio Vista, CABuilt 1965 · S/N 17253233 N5220FUnited States Air Force · Eglin Afb, FLBuilt 1965 · S/N 17253250 N5224FPfeiffer Logan A · Boonville, MOBuilt 1965 · S/N 17253263 N5228FUnited States US Air Force · Dover Afb, DEBuilt 1965 · S/N 17253277 N5229FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253280 N522XSkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 17252411 N5231QMonti David G · Middleport, NYBuilt 1965 · S/N 17253288 N5232FGilbert Christopher J · Edmonds, WABuilt 1965 · S/N 17253291 N5234FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253297 N5235FUnited States Air Force · March Afb, CABuilt 1965 · S/N 17253301 N5237FGreer James F · Louisville, KYBuilt 1965 · S/N 17253308 N5239FDanner Charles L Sr · Oak Harbor, OHBuilt 1965 · S/N 17253314 N5241FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253322 N5249F3 Mad Wives Aviation LLC · Claremont, MNBuilt 1965 · S/N 17253346 N5261FTopken William F · Fallon, NVS/N 17253375 N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380 N5267FColeman Timothy James · Cornwall On Hudson, NYBuilt 1965 · S/N 17253390 N5268FVincennes University · Indianapolis, INBuilt 1965 · S/N 17253391 N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779 N5302RTrinque Robert L Trustee · Plymouth, MABuilt 1965 · S/N 17252823 N5304RSouthern Arkansas Univ Tech · Camden, ARFirst renewal noticeBuilt 1965 · S/N 17252826 N5305RWoodman Larry · Nottingham, NHBuilt 1965 · S/N 17252827 N5307RFabian Brian L · Corcoran, MNBuilt 1965 · S/N 17252829 N5319RSchuster Glen N · Sleepy Eye, MNBuilt 1965 · S/N 17252843 N5323ROld Grove Aviation LLC · Port Charlotte, FLBuilt 1965 · S/N 17252848 N5325RBardo Daniel J · Salem, OHBuilt 1965 · S/N 17252850 N5327RMcgrath John J · Littleton, COBuilt 1965 · S/N 17252852 N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855 N5331RHastings Peter D · Bar Harbor, MEBuilt 1965 · S/N 17252857 N5332RJohnson Michael Hans · Tuttle, NDBuilt 1965 · S/N 17252858 N5334RDasilva Jonathan L · Madera, CABuilt 1965 · S/N 17252861 N53350Conner Michael J · Scotts Valley, CABuilt 1965 · S/N 17252862 N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871 N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872 N5349RTroya Aviation LLC · Utica, NYBuilt 1965 · S/N 17252878 N5350RNorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N 17252879

Back to Cessna 172F