Skip to content

Registered aircraft · 617

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

N3992SZero Dark Thirty LLC · Winder, GABuilt 1964 · S/N 17251192 N3994SAugustus Aircraft LLC · Whitefish, MTBuilt 1964 · S/N 17251194 N3996SNavarro Herbert R · Flagstaff, AZBuilt 1964 · S/N 17251196 N3997SJazc LLC · Doniphan, NEBuilt 1964 · S/N 17251197 N3PVAtkinson Russell M · Concord, CAS/N 17251739 N405JMGibson William · Aberdeen, MSS/N 17251766 N435DRFriday Michael A · Noble, OKS/N 17250666 N44RPCook Aviation Services LLC · Fargo, NDS/N 17250833 N460GPage Robert · Santaquin, UTBuilt 1964 · S/N 17251567 N48317Rhoden Gregory L · Sarasota, FLBuilt 1967 · S/N R172-0051 N489ECRobertson James T · Forest Lake, MNBuilt 1964 · S/N 17251278 N4RKMeyer Richard D · Clanton, ALBuilt 1964 · S/N 17251797 N515LXJones Johnny V · Crab Orchard, KYS/N 17250603 N5302THoak Edward C · Hummelstown, PABuilt 1964 · S/N 17251202 N5304TR Gerald Hough III · Mount Morris, ILBuilt 1964 · S/N 17251204 N5305TMccall Freddie W · Brewton, ALBuilt 1964 · S/N 17251205 N5308TAvventura LLC · San Marcos, CAFirst renewal noticeBuilt 1964 · S/N 17251208 N5313TDingman James B · Spencerville, INS/N 17251213 N5314TWynot Aviation LLC · Riverton, WYBuilt 1964 · S/N 17251214 N5315TLocal Flight Adventures LLC · Morgantown, WVBuilt 1964 · S/N 17251215 N5316THavre Flying Club Inc · Havre, MTBuilt 1964 · S/N 17251216 N5319TWilliams Robert F · New Cumberland, WVBuilt 1964 · S/N 17251219 N5320TSand Benjamin R · Alta, IABuilt 1964 · S/N 17251220 N5321TSleep Michael D · Olathe, KSBuilt 1965 · S/N 17251221 N5322TChase 13 LLC · Wilmington, DES/N 17251222 N5323TKnueven Timothy P · Brownsboro, ALS/N 17251223 N5327TMurphy Shane T · Bird Creek, AKBuilt 1964 · S/N 17251227 N5328TDiem James L · Kiel, WIBuilt 1964 · S/N 17251228 N5329TShort Kenneth L · Setauket, NYBuilt 1964 · S/N 17251229 N5330TMilne Sales And Services LLC · Lake Geneva, WIBuilt 1964 · S/N 17251230 N5334TBarker Charles W Jr · Collinsville, OKBuilt 1964 · S/N 17251234 N5338TKidd Cody M · Martinsville, OHS/N 17251238 N5340TRundell Lanny · Winnsboro, LABuilt 1964 · S/N 17251240 N5345TBerrong Jimmy L Sr · Dahlonega, GABuilt 1964 · S/N 17251245 N5346TTiffany Shawn M · Herington, KSBuilt 1964 · S/N 17251246 N5352TFord Howard J · Salt Lake City, UTBuilt 1964 · S/N 17251252 N5353TRegistration Pending · Covington, GARegistration pendingBuilt 1964 · S/N 17251253 N5356TVan Natta Richard C · Lusby, MDBuilt 1964 · S/N 17251256 N5359TJanssen Glenn L · Lakewood, COBuilt 1964 · S/N 17251259 N5360TCurran Ronald J · Olympia, WAS/N 17251260 N5361TDick Ronald J · Fort Wayne, INBuilt 1964 · S/N 17251261 N5364TKato Matt J · Fairbanks, AKBuilt 1964 · S/N 17251264 N5365TLaperle Aviation LLC · Colebrook, NHBuilt 1964 · S/N 17251265 N5366TTbl Aviation LLC · Springfield, ORBuilt 1964 · S/N 17251266 N5367TJulian Farm LLC · Hudson Oaks, TXBuilt 1964 · S/N 17251267 N5377TAllen James W · Lakewood Ranch, FLBuilt 1964 · S/N 17251277 N5379TBerry Kevin R · Bowie, TXBuilt 1964 · S/N 17251279 N5380TEdwards Air LLC · Raleigh, NCBuilt 1964 · S/N 17251280 N5383TMeyers Morgan J · Twin Falls, IDS/N 17251283 N5384TJohnson William R · Virginia Beach, VABuilt 1964 · S/N 17251284

Back to Cessna 172E