Skip to content

Registered aircraft · 683

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

N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075 N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709 N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552 N102HWDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281058 N102MUTraining Planes LLC · Tampa, FLBuilt 1997 · S/N 17280285 N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238 N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553 N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298 N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534 N104LULynn University Inc · Boca Raton, FLBuilt 1998 · S/N 17280625 N104PFLewis University · Romeoville, ILBuilt 1998 · S/N 17280313 N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431 N106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2001 · S/N 17281055 N107AFKummer Michael · Floyd'S Knobs, INBuilt 2001 · S/N 17281056 N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991 N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985 N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913 N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401 N1157RFlying Nam LLC · Sheridan, WYBuilt 1998 · S/N 17280627 N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819 N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820 N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821 N118ETL & W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280019 N118FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281198 N118KSKent State University · Stow, OHBuilt 1999 · S/N 17280822 N119KSKent State University · Stow, OHBuilt 1999 · S/N 17280823 N121UCEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280420 N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176 N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189 N133VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281190 N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191 N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192 N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193 N137MACivil Aviation Inc · Waukesha, WIBuilt 1997 · S/N 17280146 N137VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281194 N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503 N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185 N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255 N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805 N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256 N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816 N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752 N167SJAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280167 N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188 N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404 N17274University Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280353 N17297Barrier William · Pensacola, FLBuilt 1997 · S/N 17280140 N172BFLewis University · Romeoville, ILBuilt 1997 · S/N 17280175

Back to Cessna 172R