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.

N6883AOswego Joint Venture · Tchula, MSBuilt 1956 · S/N 28983 N6887ABradshaw Gary E · Warfordsburg, PABuilt 1956 · S/N 28987 N688WBaum Eldon L Jr · Wellsville, PABuilt 1956 · S/N 28695 N6893AFarris Lyle E · Faucett, MOBuilt 1956 · S/N 28993 N6894ASw Aero Training LLC · Rio Rancho, NMBuilt 1956 · S/N 28994 N6895ADettman Gary L · Spearfish, SDBuilt 1956 · S/N 28995 N6896ABuben Michael · Chandler, AZBuilt 1956 · S/N 28996 N6897AChancey Amy Victoria · Patterson, GABuilt 1956 · S/N 28997 N6898ADashiell Shawn T · Fairfield, WAS/N 28998 N6900ANorthwind Flying Club · Traverse City, MIBuilt 1956 · S/N 29000 N6901ASpence Stephen L · Anchorage, AKBuilt 1956 · S/N 29001 N6902ABasher Michael H · Morehead City, NCBuilt 1956 · S/N 29002 N6903AFisher Joe S · Smithville, MOBuilt 1956 · S/N 29003 N6908ACarreiro Alexander · Doral, FLBuilt 1956 · S/N 29008 N6910ACook Mike R · Rye, COBuilt 1956 · S/N 29010 N6911ABryson John C III · Bath, NYBuilt 1956 · S/N 29011 N6912AKinsey Craig Russell · Sidney, TXBuilt 1956 · S/N 29012 N6915ACraig Linda I · East Freetown, MABuilt 1956 · S/N 29015 N6916ABloyer Emery · Fennimore, WIBuilt 1956 · S/N 29016 N6918ALarson Gary W · Fort Worth, TXBuilt 1956 · S/N 29018 N6924AHuempener Gary R · Cato, WIBuilt 1956 · S/N 29024 N6926ATrident Aviation LLC · Kalispell, MTS/N 29026 N6927ASmith James C Jr · Fayetteville, GABuilt 1956 · S/N 29027 N6929AWadsworth Curtis D · Sierra Vista, AZBuilt 1956 · S/N 29029 N6930AStewart Donald M · Vulcan, MIBuilt 1956 · S/N 29030 N6932AAthey Jerry Jeff · Alvin, TXBuilt 1956 · S/N 29032 N6936AJordahl Amy L · Two Harbors, MNBuilt 1956 · S/N 29036 N6939AErtas Efe Y · Walnut Creek, CABuilt 1956 · S/N 29039 N6942AHaskell Thomas L · Summerville, SCBuilt 1956 · S/N 29042 N6948ASelf David J · Wagener, SCBuilt 1956 · S/N 29048 N6950AGallagher David R · Auburndale, FLBuilt 1956 · S/N 29050 N6952ABig Sky Adventures LLC · Nicholasville, KYBuilt 1956 · S/N 29052 N6954ALindroth Richard J · Eleanor, WVBuilt 1956 · S/N 29054 N6955AFortman James · Vancouver, WABuilt 1956 · S/N 29055 N6956AChristensen Curtis A · Lincoln, NEBuilt 1956 · S/N 29056 N6961ABontadellis Flying Service Ll · Polson, MTBuilt 1956 · S/N 29061 N6962ARogakis Christopher M · Spring Hill, KSBuilt 1956 · S/N 29062 N6963AFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1956 · S/N 29063 N6964AJackalope Aviation LLC · Bellingham, WAS/N 29064 N6970AAeropaws Aviation LLC · Front Royal, VABuilt 1956 · S/N 29070 N6973AAlbrecht Eric B · Grand Forks, NDBuilt 1956 · S/N 29073 N6975AAnderson David R · Sycamore, ILS/N 29075 N6978AMcbride Robert W · Mineola, TXBuilt 1956 · S/N 29078 N6979AButcher William J · Salem, OHS/N 17229079 N6985AImwalle John N · Batavia, OHBuilt 1956 · S/N 29085 N6986APoindexter Charles A Sr · West Point, MSBuilt 1956 · S/N 29086 N6988ARegistered aircraftBuilt 1956 · S/N 29088 N6993AHurta Jennifer · Cypress, TXBuilt 1956 · S/N 29093 N6994AMeador George D · Austin, TXBuilt 1956 · S/N 29094 N6997AAirpower Aviation Resources Inc · Newbury Park, CABuilt 1956 · S/N 29097

Back to Cessna 172