Skip to content

Registered aircraft · 1,805

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

N291YASherman Jason Bradley · Indianola, IABuilt 1956 · S/N 28164 N318RAllen Timothy J · East Kingston, NHBuilt 1958 · S/N 36999 N318SCMooney Frank X · Friendswood, TXBuilt 1957 · S/N 36261 N31FCInternational Air Services Inc Trustee · Carson City, NVS/N 46140 N3245GDougherty Robert E · Mosheim, TNBuilt 1956 · S/N 28326 N335JCAlexander Melodie A · Lees Summit, MOBuilt 1956 · S/N 28785 N344CPBlain Robert · West Richland, WABuilt 1956 · S/N 28713 N358TACrow Edward N · Silverdale, WABuilt 1959 · S/N 46666 N361RHDerdak Stephen · San Antonio, TXBuilt 1956 · S/N 29013 N361XSorley Steven J · Roy, UTBuilt 1957 · S/N 36238 N36645Kaufmann Chad · Lewiston, IDBuilt 1958 · S/N 36645 N3672GAcosta De La Torre Armando A · El Paso, TXS/N 29549 N371LMMiller Leo S · Chelan, WABuilt 1958 · S/N 36805 N37718Cole Rayce S · Palmer, AKS/N 46597 N3864LDelvalle Dean · Schertz, TXBuilt 1965 · S/N 17254033 N388TCDopson Joel A · Ooltewah, TNBuilt 1956 · S/N 29601 N3900FNolen Parker · Manson, WABuilt 1958 · S/N 36800 N3901FCda Maine LLC · Winthrop, MEBuilt 1958 · S/N 36801 N3902FMagaw David N · Sacramento, CABuilt 1958 · S/N 36802 N3903FSlattery Gordon C · Chippewa Falls, WIBuilt 1958 · S/N 36803 N3904FPedersen Blake A · Clackamas, ORBuilt 1958 · S/N 36804 N3907FTaylor William Bc · Quincy, CABuilt 1958 · S/N 36807 N3911FSpencer Jeffrey D · Rushsylvania, OHBuilt 1958 · S/N 36811 N3913FTailwinds Inc · Lancaster, PABuilt 1958 · S/N 36813 N3915FBennett Brandon Scott · Fort Worth, TXBuilt 1958 · S/N 36815 N3917FMurphy Michael A · Anchorage, AKBuilt 1958 · S/N 36817 N3919FKonkol Roger E · Lumberton, NCBuilt 1958 · S/N 36819 N3925FDoles Joseph E · Columbia, MOBuilt 1958 · S/N 36825 N3926FColwill Renee · Sequim, WABuilt 1958 · S/N 36826 N3928FDeno Rick A · Battle Creek, MIBuilt 1958 · S/N 36828 N3931FStade Joel T · Iowa Park, TXS/N 36831 N3934FGreat Wave Aviation LLC · Hood River, ORBuilt 1958 · S/N 36834 N3936F36fox Aviation LLC · Branchburg, NJBuilt 1958 · S/N 36836 N3942FTaylor Brian · Bullhead City, AZBuilt 1958 · S/N 36842 N3946FMatson William J · Wasilla, AKBuilt 1958 · S/N 36846 N3947FStubbs Scott F · Tucson, AZBuilt 1958 · S/N 36847 N3949FReed Systems Ltd · Ellenville, NYBuilt 1958 · S/N 36849 N3950FSeifert Justin R · Minot, NDBuilt 1958 · S/N 36850 N3953FRegistration Pending · Plainfield, NJRegistration pendingBuilt 1958 · S/N 36853 N3954FGossom J Burk · Friday Harbor, WABuilt 1958 · S/N 36854 N3955FSpringfield Flying Service LLC · Columbia, CABuilt 1958 · S/N 36855 N3958FRegistration Pending · Harwich, MARegistration pendingS/N 36858 N3960FDurossette Darryl · Eugene, ORBuilt 1958 · S/N 36860 N3961FBaldwin Stephen · Olalla, WAS/N 36861 N3964FJennings Larry J · Wnfield, IABuilt 1958 · S/N 36864 N3965FOverton Asset Group LLC · St Marys, IABuilt 1958 · S/N 36865 N3966FConaway Jeran L · Albany, ORBuilt 1958 · S/N 36866 N3968FAurigema Andrew N · Oak Hill, FLBuilt 1958 · S/N 36868 N3975FSeventy Five Foxtrot LLC · Wilmington, DEFirst renewal noticeBuilt 1958 · S/N 36875 N3979FAppleby Jack E · Atwood, ILBuilt 1958 · S/N 36879

Back to Cessna 172