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.

N5623ABeskar Shawn P · Eagan, MNBuilt 1956 · S/N 28223 N5626AAero Gravity Media Inc · Delray Beach, FLBuilt 1956 · S/N 28226 N5627AKeiffer Robert P · Piney Flats, TNS/N 28227 N5628AMaldonado Alejandro · Minneapolis, MNBuilt 1956 · S/N 28228 N5630ABrockmeyer Cory · Auburn, ILS/N 28230 N5635ADecoteau Mitchel E · Yellville, ARBuilt 1956 · S/N 28235 N5636AFine Aviation LLC · Jefferson, ORBuilt 1956 · S/N 28236 N5637ASherman Frederick J · Tukwila, WABuilt 1956 · S/N 28237 N5638AHartigan Robert P · Rome, NYBuilt 1956 · S/N 28238 N5640ASanders David L · Powell, WYBuilt 1956 · S/N 28240 N5642AMoore Alton O III · Lago Vista, TXS/N 28242 N5643ARosansky Jeff S · Weldon Spring, MOBuilt 1956 · S/N 28243 N5645AAll Seasons Catering Inc · Shelter Isl, NYBuilt 1956 · S/N 28245 N5646AHeffron Jacob L · Little Falls, MNS/N 28246 N5648AMartin Rand E · Lake Stevens, WAS/N 28248 N5649AMinor Charles G · Medford, ORS/N 28249 N5652APatriot Aviation · Loomis, CABuilt 1956 · S/N 28252 N5658AEwartsville Flyers LLC · Pullman, WABuilt 1956 · S/N 28258 N5659AChaouki Rebecca · La Crosse, WIBuilt 1957 · S/N 28259 N5662AMccafferty John · East Jordan, MIBuilt 1956 · S/N 28262 N5664ASale Reported · Spirit Lake, IDSale reportedBuilt 1956 · S/N 28264 N5666ARonshausen Steven A · Circleville, OHBuilt 1956 · S/N 28266 N5669ABlanchette Charles · Payson, AZBuilt 1956 · S/N 28269 N5671AJarvis Peter S · Lebanon, CTBuilt 1956 · S/N 28271 N5674AStearns Edwin Ben Jr · Chandler, AZBuilt 1956 · S/N 28274 N5675AMarch David H Trustee · Lincoln, CABuilt 1956 · S/N 28275 N5676ALakes Area Aviation LLC · Little Falls, MNBuilt 1956 · S/N 28276 N5678ABailey David D · Twentynine Palms, CABuilt 1956 · S/N 28278 N5679ALeblanc Kenneth E · Franklinton, LABuilt 1956 · S/N 28279 N5680AMoore John W · Salome, AZBuilt 1956 · S/N 28280 N5681AKiesow Arthur W · Agua Dulce, CAS/N 28281 N5682ANewbury Arnold E · Phillips, WIBuilt 1956 · S/N 28282 N5684AGirard Richard J · Somerset, MABuilt 1956 · S/N 28284 N5688ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 28288 N5689AAffordable Aircraft LLC · Bellevue, MIS/N 28289 N5692AKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1956 · S/N 28292 N5696ACardinal Wings Inc · Faribault, MNBuilt 1956 · S/N 28296 N5697AHam Dana L · Claremore, OKBuilt 1956 · S/N 28297 N5698AGreer David S · Lubbock, TXBuilt 1956 · S/N 28298 N5699AOhlinger Judith A · Copley, OHBuilt 1956 · S/N 28299 N5701ACrews James E Sr · Lawton, OKBuilt 1956 · S/N 28301 N5704AN8372x LLC · Chelan, WAS/N 28304 N5708AEgmond Aircraft LLC · Lewes, DES/N 28308 N5714AWeddle William H · Winston, NMS/N 28314 N5715ASkinner Norman D · Osceola, IABuilt 1956 · S/N 28315 N5716ASaile Daniel K · Skiatook, OKBuilt 1956 · S/N 28316 N5719APinson Danny L · Grand Junction, COS/N 28319 N5723AAdamson Steven C · Jonesboro, GAS/N 28323 N5728AMcgiffen Christine L · Vincennes, INBuilt 1956 · S/N 28328 N5729AThomas Scott S · Wytheville, VABuilt 1956 · S/N 28329

Back to Cessna 172