Skip to content

Registered aircraft · 3,138

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

N1978NStansfield Jacob M · Kalispell, MTBuilt 1977 · S/N 17268953 N1989EInteriaires LLC · Redwood Falls, MNS/N 17271110 N198ARNielsen Jeffrey S · Ashland, ORBuilt 1979 · S/N 17273560 N1997EOlsen Grain & Livestock Inc · Whitewater, MTBuilt 1978 · S/N 17271114 N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570 N2003EHarman Dane P · Halifax, PABuilt 1978 · S/N 17271116 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118 N2019ECox Garry G · Coleman, TXS/N 17271120 N202NEJepsen William R Trustee · Enterprise, ORBuilt 1976 · S/N 17268104 N202PYEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 17271126 N2038EStevens Michael J Jr · Humble, TXBuilt 1978 · S/N 17271127 N203GTUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1979 · S/N 17272403 N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131 N2050ETcv Capital Holdings LLC · Riverton, UTBuilt 1978 · S/N 17271132 N2054EJamieson Mark S · Boulder, COBuilt 1978 · S/N 17271133 N2055EAerowood Aviation LLC · Monroe, NCBuilt 1978 · S/N 17271134 N2059EH & H Aviation Enterprises LLC · Fairfield, OHBuilt 1978 · S/N 17271137 N2060EBlackstone Aircraft LLC · Hartselle, ALS/N 17271138 N2061ECak4 LLC · Uniontown, OHBuilt 1978 · S/N 17271139 N2073EGreat Lakes Air Ventures LLC · Mason, MIBuilt 1978 · S/N 17271144 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331 N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155 N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156 N2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271159 N210SVBevis Richard L · Middletown, OHBuilt 1978 · S/N 17271361 N211AVN8191e LLC · Manassas, VABuilt 1979 · S/N 17272151 N211BAWojteczko Jason A · Derby, KSBuilt 1977 · S/N 17270071 N2128EFly For Fun LLC · Rockville, MDBuilt 1978 · S/N 17271165 N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380 N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830 N2150ELeuer Nicholas J · Emmetsburg, IABuilt 1978 · S/N 17271170 N215AFArmed Forces Aero Club · San Diego, CABuilt 1978 · S/N 17270844 N215FRJjg Aviation LLC · Miami, FLBuilt 1978 · S/N 17271822 N2161EBryn Terry P · Dazey, NDBuilt 1978 · S/N 17271172 N2165EMaravel Richard N · Trinity, FLBuilt 1978 · S/N 17271174 N2167ESittler Charles A · Tulsa, OKS/N 17271176 N2170EChamberlain Flying Club Inc · Chamberlain, SDBuilt 1978 · S/N 17271178 N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182 N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907 N2207ETeton Leasing LLC · Pocatello, IDBuilt 1978 · S/N 17271186 N2209EIngersoll George P · Lakewood, COBuilt 1978 · S/N 17271188

Back to Cessna 172N