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.

N7259AHalladay Roy · Erie, COS/N 29359 N7261ACassity Michael D · Springfield, MOBuilt 1956 · S/N 29361 N7263AHillside Farms · Elaine, ARBuilt 1956 · S/N 29363 N7264ABridge Creek Logging Inc · Mount Vernon, ORBuilt 1956 · S/N 29364 N7266ABrooks David A · East Dorset, VTBuilt 1956 · S/N 29366 N7266TNobles Gary Allen · Winnsboro, LAS/N 46866 N7271AEinck Matthew J · Fort Worth, TXS/N 29371 N7272AOpen Air Ltd Co DBA · Pella, IABuilt 1956 · S/N 29372 N7273AMartin Randal O · Oak Point, TXBuilt 1956 · S/N 29373 N7275AZelinski Jeffrey C · Watersmeet, MIS/N 29375 N7276AAved Consulting LLC · Edgewater, FLBuilt 1956 · S/N 29376 N7277ADrzewiecki Chad M · Cuyahoga Falls, OHBuilt 1952 · S/N 29377 N7279AGoerger Allan E · Barney, NDBuilt 1956 · S/N 29379 N7280AWarren Holland S · Princeville, ILFirst renewal noticeBuilt 1956 · S/N 29380 N7281AWindsock Capital LLC · Bertram, TXBuilt 1956 · S/N 29381 N7286ALipp James Oliver · Nesconset, NYBuilt 1956 · S/N 29386 N7287ADean William D · Jasper, GABuilt 1956 · S/N 29387 N7288AHeard Benjamin A · Ellensburg, WABuilt 1956 · S/N 29388 N7290ARipp Fred G · Eagle River, AKBuilt 1956 · S/N 29390 N7291AWarren Mark W · Arlington, WAS/N 29391 N7294APiston Aviation LLC · Saint Charles, MOBuilt 1956 · S/N 29394 N7296AStoup Lyndal K · Cordell, OKBuilt 1956 · S/N 29396 N7297AMyers Maxwell D · Salt Lake City, UTS/N 29397 N7302ASkywagon Aero LLC · Wilmington, DEBuilt 1956 · S/N 29402 N7303ALogajan James M · Rapid City, SDBuilt 1956 · S/N 29403 N7305AK&M Aviation LLC · West Liberty, KYS/N 29405 N7306AFloyd Ckyler Don · Bowman, NDS/N 29406 N7307ACook Raymond L · Clarksville, TNBuilt 1956 · S/N 29407 N7312AJohnson Thomas F · Buckeye, AZS/N 29412 N7313APerkins David A · Locust Grove, OKS/N 29413 N7314ASchultz David · Middleton, IDBuilt 1956 · S/N 29414 N7316ALangley Russell M · Adair, OKBuilt 1956 · S/N 29416 N7325AJaeger Howard E · Claremore, OKBuilt 1957 · S/N 29425 N7328AToribio LLC · San Antonio, TXBuilt 1957 · S/N 29428 N7331AAviation 98374 LLC · Bonney Lake, WABuilt 1957 · S/N 29431 N7336ARanger Aviation Inc · Burlington, COBuilt 1957 · S/N 29436 N7339ARentfrow Jack D · Lake City, MIBuilt 1957 · S/N 29439 N7342ANewberry Ernest B Jr · Crawfordville, FLBuilt 1957 · S/N 29442 N7347ATalkeetna Build A Plane Inc · Talkeetna, AKS/N 29447 N7349ANorwood Brian B · Conway, ARBuilt 1956 · S/N 29449 N7351ALandis Aviation Inc · Valdosta, GABuilt 1956 · S/N 29451 N7352ABotts Benjamin R · Ketchikan, AKS/N 29452 N7355AOwens Duane Curtis · Spirit Lake, IDBuilt 1956 · S/N 29455 N7356ALittrell Thomas W · Galax, VABuilt 1956 · S/N 29456 N7357AHultquist David D · Anchorage, AKBuilt 1956 · S/N 29457 N7358AWells Jason T · Mt Hood Prkdl, ORBuilt 1956 · S/N 29458 N7360ABurton Justin Blake · Jenks, OKS/N 29460 N7362AParker Brian A · Waco, TXBuilt 1956 · S/N 29462 N7363AF D P Aviation Inc · Irwin, PABuilt 1956 · S/N 29463 N7364ACerullo Joe A · Oak Harbor, WABuilt 1956 · S/N 29464

Back to Cessna 172