Skip to content

Registered aircraft · 857

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

N3996QLuther Turner S · Perry, FLBuilt 1971 · S/N 17260096 N3997QMurray Edward K · Fallbrook, CABuilt 1971 · S/N 17260097 N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442 N411DKSwaz Aviation LLC · Mesa, AZS/N 17260703 N4201QReeve Ryan · Hurricane, UTBuilt 1971 · S/N 17260101 N4202QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260102 N4203QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260103 N4206QOsmonovich Michael · Kent, WABuilt 1971 · S/N 17260106 N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N4218QSavant John D · Kinder, LAS/N 17260118 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N4221QRegistered aircraftBuilt 1971 · S/N 17260121 N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122 N4224QPressley Aviation LLC · New London, NCBuilt 1971 · S/N 17260124 N4225QBraddock Karrol L · Globe, AZBuilt 1971 · S/N 17260125 N4227QSchoenfeld Paul E · Midvale, UTBuilt 1971 · S/N 17260127 N4228QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260128 N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130 N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133 N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134 N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138 N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139 N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140 N4242QRegistered aircraftS/N 17260142 N4244QCox Danny · Peachtree City, GABuilt 1971 · S/N 17260144 N4246QJkg LLC · Murfreesboro, TNBuilt 1971 · S/N 17260146 N4247QSchmitt Michael C · Alva, FLS/N 17260147 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N4250QTice Evan L · Seattle, WABuilt 1971 · S/N 17260150 N4253QFrog Av LLC · Brownstown, INBuilt 1971 · S/N 17260153 N4256QBurnham Cessna N4256q LLC · Carr, COBuilt 1971 · S/N 17260156 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022 N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170 N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173 N4274QLjn Aircraft LLC · Jamestown, NYBuilt 1971 · S/N 17260174 N4276QOjdrovich George · Steamboat Springs, COBuilt 1971 · S/N 17260176 N4277QRawlins William David Sr · Martinez, GABuilt 1971 · S/N 17260177 N4281QMcdonald Air Services LLC · Saint Johns, MIBuilt 1971 · S/N 17260181 N4282QShirley Walter Allen · Bullhead City, AZBuilt 1971 · S/N 17260182 N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185 N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187

Back to Cessna 172L