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.

N24616N24616 LLC · Manassas, VABuilt 1999 · S/N 17280830 N24619Atp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 17280831 N2462TEagle East Aviation Inc · North Andover, MABuilt 2000 · S/N 17280834 N2465QChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 17281271 N2465UProtzair LLC · Aiken, SCBuilt 2005 · S/N 17281272 N24671Mustang Sally Aviation LLC · Signal Hill, CABuilt 2000 · S/N 17280925 N2473GFly For Fun Aircraft LLC · Baltimore, MDBuilt 2001 · S/N 17281019 N24748Delta State University · Cleveland, MSBuilt 2001 · S/N 17281051 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N24780San Diego Flight Training International Inc · San Diego, CABuilt 2001 · S/N 17281028 N24783Elite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 17281029 N249FSAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2005 · S/N 17281249 N24AFAbove & Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280439 N259GFPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280259 N259RAReynolds Darryl G · Wills Point, TXBuilt 1998 · S/N 17280444 N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559 N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436 N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568 N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570 N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572 N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573 N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578 N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730 N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599 N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600 N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601 N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542 N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569 N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565 N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643 N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258 N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551 N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586 N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587 N2772Lewis University · Romeoville, ILBuilt 2005 · S/N 17281252 N2830PSandpiper Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280593 N28811B D Aviation LLC · Sauget, ILBuilt 2004 · S/N 17281232 N297TCMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1997 · S/N 17280016 N298MCJ C B Aircraft Sales And Leasing · Princeton, NJBuilt 1997 · S/N 17280303 N29AFDale Michael · Murrieta, CABuilt 1998 · S/N 17280456 N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135 N302CFEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 17281137 N30YPBmf Jax LLC · Jacksonville, FLBuilt 2012 · S/N 17281600 N30YRInn Flying Club Inc · Gaithersburg, MDBuilt 1997 · S/N 17280043 N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489 N315TPN315tp LLC · Stuart, FLBuilt 1999 · S/N 172-80809 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N330JEWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280299 N332SPMh Aviation LLC · Foster City, CABuilt 2020 · S/N 17281118 N346CPPinnacle Aviation Services Inc · Encinitas, CABuilt 1998 · S/N 17280346

Back to Cessna 172R