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.

N7159AWilgar Aero LLC · Palestine, ARBuilt 1956 · S/N 29259 N7160AStainaker Le Roy R · Cleveland, TXBuilt 1956 · S/N 29260 N7161AVicari David · Crown Point, INBuilt 1956 · S/N 29261 N7164AKiever Robert P Jr · Summerland Key, FLBuilt 1956 · S/N 29264 N7166AHuseth William Greg · Pooler, GABuilt 1956 · S/N 29266 N7167ATucker Tim · Hopkinsville, KYBuilt 1956 · S/N 29267 N7173ADuke Billy L · Ormond Beach, FLBuilt 1956 · S/N 29273 N7176ASwierk Joshua J · Valdez, AKS/N 29276 N717RCDmac Aircraft LLC · Savannah, GAS/N 36346 N7181AWarmkessel James R · Felton, CABuilt 1956 · S/N 29281 N7182AEdm Flying Inc · Nevada, MOBuilt 1956 · S/N 29282 N7183AElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1956 · S/N 29283 N7184AGarrison Randy L · Queen City, TXBuilt 1956 · S/N 29284 N7186AValiair Lc Trustee · Casper, WYBuilt 1956 · S/N 29286 N7187AHannah David W · Richmond, TXBuilt 1956 · S/N 29287 N7189APierson Janice R Trustee · Scio, ORBuilt 1956 · S/N 29289 N7194AGuillermo A Pliego M · Corpus Christi, TXS/N 29294 N7196AL-Bird LLC · Hood River, ORBuilt 1956 · S/N 29296 N71TDDunn William F · Del Norte, COBuilt 1957 · S/N 29706 N7200AMcdaniel Neil R · Wray, COBuilt 1956 · S/N 29300 N7201ACarleson Jesse R · Wasilla, AKFirst renewal noticeBuilt 1956 · S/N 29301 N7203AJohnson Lawrence F · Anchorage, AKBuilt 1956 · S/N 29303 N7204TGaponoff Mark A · Mercer Island, WAFirst renewal noticeBuilt 1960 · S/N 46804 N7206ABerle William M · White Hills, AZS/N 29306 N7211ATravis Michael B · Camano Island, WABuilt 1956 · S/N 29311 N7211THargrove Nicholas A · Lago Vista, TXBuilt 1959 · S/N 46811 N7212ABlane Steven C · Rockville, INBuilt 1956 · S/N 29312 N7217AMcguires Flying Service LLC · Obion, TNBuilt 1956 · S/N 29317 N7218AGurdak Paul J · Bristol, VTBuilt 1956 · S/N 29318 N721MWelch James D · Holdenville, OKBuilt 1957 · S/N 29879 N7222AChamberlain C Douglas · Bellefontaine, OHBuilt 1956 · S/N 29322 N7223ASather Evan · Hayward, CAS/N 29323 N7225AFouts Philip W · Caldwell, IDBuilt 1956 · S/N 29325 N7227ANewman Christan C · Niota, TNBuilt 1956 · S/N 29327 N7228APaine Jered J · Cashmere, WAFirst renewal noticeBuilt 1956 · S/N 29328 N7229ASale Reported · Belleville, ILSale reported, pending cancellationBuilt 1956 · S/N 29329 N7232ABakunova Eugenia S · Cordova, AKBuilt 1956 · S/N 29332 N7234AMoore Thomas K · Pleasant View, UTBuilt 1956 · S/N 29334 N7239AEasley Daniel W · Wasilla, AKBuilt 1956 · S/N 29339 N723LAGregg James H · Parkton, NCBuilt 1958 · S/N 36930 N7240AIrwin Timothy L · Cottonwood, AZBuilt 1956 · S/N 29340 N7241AGibbs Geoffrey M · Holland, TXS/N 29341 N7245AStoup Kyle W · Foss, OKBuilt 1956 · S/N 29345 N7248AMoore Greg J · Bakersfield, CAS/N 29348 N7251AHoward F Bret · Albany, OHBuilt 1956 · S/N 29351 N7252ABarbaro Aaron J · Marcellus, NYBuilt 1956 · S/N 29352 N7254AStiffey Jason J · Port Orchard, WAS/N 29354 N7255ANunziato Anthony J · Tewksbury, MABuilt 1956 · S/N 29355 N7257AJones William Shane · Griffin, GABuilt 1956 · S/N 29357 N7258ANguyen Anthony V · Keyser, WVBuilt 1956 · S/N 29358

Back to Cessna 172