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.

N6673ASearson Jason C · Newton, NCBuilt 1956 · S/N 28773 N6674AThomas Craig S · Salem, ORBuilt 1956 · S/N 28774 N6681ACarignan Armand R · Hooksett, NHBuilt 1956 · S/N 28781 N6684ASchumacher Leroy H · Beach City, OHBuilt 1956 · S/N 28784 N6688APouncey Robert · Proctor, ARS/N 28788 N6689AMaley Christopher L · Otsego, MIBuilt 1956 · S/N 28789 N6694ADenslow Carl W · Barto, PABuilt 1956 · S/N 28794 N6695AStewart Guy C · Stevens Point, WIFirst renewal noticeBuilt 1956 · S/N 28795 N6697AHart David L · Oxnard, CABuilt 1956 · S/N 28797 N6699AAdderley Allan M · Hernando, FLBuilt 1956 · S/N 28799 N6701AClarke Christopher E · Cincinnati, OHBuilt 1956 · S/N 28848 N6702AWitte Troy A · West Plains, MOBuilt 1956 · S/N 28802 N6703AMankovich Douglas P · Punxsutawney, PABuilt 1956 · S/N 28803 N6704AKaspar Matthew L · Neenah, WIBuilt 1956 · S/N 28804 N6706ALouden Bruce H · Kalispell, MTBuilt 1956 · S/N 28806 N6709AEvanoff Aaron · Fowlerville, MIFirst renewal noticeS/N 28809 N6711AAero Club Valkaria LLC · Malabar, FLBuilt 1956 · S/N 28811 N6714APelcher Devin · Ormond Beach, FLBuilt 1956 · S/N 28814 N6717AHeffron Jacob L · Little Falls, MNBuilt 1956 · S/N 28817 N6718AWolfe Quest M · Phoenix, AZBuilt 1956 · S/N 28818 N6719ASantana Maria De La Luz · Hemet, CAS/N 28819 N671VHRobert And Andrea Van Hofwegen LLC · Buckeye, AZBuilt 1956 · S/N 29459 N6720AFremgen Stephen M · Carrollton, TXBuilt 1956 · S/N 28820 N6721ARogers Jeffery D · Franklin, WIS/N 28821 N6724AGodin George A · Franklin, VTBuilt 1956 · S/N 28824 N6729AO Tuel Maxcy Bryant · Mooresville, NCBuilt 1956 · S/N 28829 N6732AHurst Construction Co · Denton, TXS/N 28832 N6733AJaed Gerald E · Yankeetown, FLS/N 28833 N6735AHinkle Robert J · Caldwell, IDBuilt 1956 · S/N 28835 N6736AFogleman Brian L · Stonewall, LABuilt 1956 · S/N 28836 N6737AEdmiston Dave L · Clifton, TXBuilt 1956 · S/N 28837 N6738ABufford David T · Union Springs, ALFirst renewal noticeBuilt 1956 · S/N 28838 N6740AWillis John Y · Pine Mountain, GABuilt 1956 · S/N 28840 N6742ABouton Vern H · Fairbanks, AKBuilt 1956 · S/N 28842 N6743AChenier Mark S · Goldsboro, NCS/N 28843 N6744ALa Rue Carl A · Cambridge, OHBuilt 1956 · S/N 28844 N6747AMatt Brit A · Sioux Falls, SDFirst renewal noticeBuilt 1956 · S/N 28847 N6749AOwens Wilbur · Rch Palos Vrd, CAS/N 28849 N6750AC & B Aerial Transport Inc · Wilmington, DEBuilt 1956 · S/N 28850 N6752AGray Shane Charles · Interlochen, MIS/N 28852 N6753AWickard Mark A · Bridgeport, NEBuilt 1956 · S/N 28853 N6755ASteffes Dennis J · Hershey, NES/N 28855 N6757AN7742e LLC · Lewes, DES/N 28857 N6759ACross Billy G · Glen Allan, MSBuilt 1956 · S/N 28859 N6761ASkeen Steven L · Enterprise, ALBuilt 1956 · S/N 28861 N6765ANiehues Reid B · Eola, TXBuilt 1956 · S/N 28865 N6766ADenton Michael W · Clarksville, VABuilt 1956 · S/N 28866 N6770AHele David A · Birchwood, WIBuilt 1956 · S/N 28870 N6775AField Eaton Fredrick F · Tigard, ORBuilt 1956 · S/N 28875 N6777AScheithauer Christopher P · Cement City, MIBuilt 1956 · S/N 28877

Back to Cessna 172