Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N81093Samson Joseph R · Eagle, WIBuilt 1946 · S/N 10387 N812KWHart Paul E · El Macero, CAS/N 8752 N813WPay It Forward Aviation LLC · Ione, CABuilt 1947 · S/N 12729 N813XCColley Douglas W · Spokane, WABuilt 1946 · S/N 8080 N81LFloyd Craig W · Glendale, AZBuilt 1946 · S/N 10061 N83NStromberg Lee W · Rochester, NHBuilt 1946 · S/N 11607 N84BCBerglund Mark · Rockwall, TXBuilt 1946 · S/N 10255 N872KBBruner Kevin G · Vandalia, OHBuilt 1946 · S/N 11220 N888JSmith Aviation LLC · Springer, OKBuilt 1946 · S/N 8422 N88TQAllsop Jennifer M · Flourtown, PABuilt 1946 · S/N 8450 N89004Mason Alvin W · Fort Worth, TXBuilt 1946 · S/N 8008 N89007Point Lavinia Commercial Charters Inc · Seattle, WAS/N 8011 N89009Mitchell Beau Phillip · Sedro Woolley, WABuilt 1946 · S/N 8013 N89010Carlson Jonathan J · Hernando, MSBuilt 1946 · S/N 8014 N89011Surratt Larry N · Victoria, TXBuilt 1946 · S/N 8015 N89017Phillips Stephen G · Sandwich, MABuilt 1946 · S/N 8021 N89019Haag Benjamin L · Mooresville, NCBuilt 1946 · S/N 8023 N89025Taylor Robert P · Bothell, WABuilt 1946 · S/N 8029 N89030Shank William R · Sandusky, OHBuilt 1946 · S/N 8034 N89033Flying Jib LLC · Washington, DCBuilt 1946 · S/N 8037 N89039Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N 8043 N89042Welborn Mitchell G · Hamptonville, NCS/N 8046 N89046Spitler Scott M · Maryville, TNBuilt 1946 · S/N 8050 N89047Schutt Michael J · Kimberling City, MOS/N 8051 N89052Gateway Tailwheel Club LLC · Columbia, ILBuilt 1946 · S/N 8056 N89053Hiller Heather L · Bismarck, ARBuilt 1946 · S/N 8057 N89062Jones Melvin T · Sunrise Beach, TXBuilt 1946 · S/N 8066 N89066Wilson Caleb F · Cheney, KSS/N 8070 N89067Mcclain Aviation LLC · Roanoke, TXBuilt 1946 · S/N 8071 N89069Sondey Charles S · Stow, MABuilt 1946 · S/N 8073 N89078Thompson R Bruce · Topton, PABuilt 1946 · S/N 8082 N89104Ricchio Thomas A · Manawa, WIBuilt 1946 · S/N 8108 N89105Registration Pending · Brodhead, WIRegistration pendingBuilt 1946 · S/N 8109 N89107N89107 Inc · Saratoga Springs, NYBuilt 1946 · S/N 8111 N89109Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1946 · S/N 8117 N89111Minette C M · Dallas, TXBuilt 1946 · S/N 8119 N89115Owens David C · Rome, GABuilt 1946 · S/N 8123 N89118Kelley William P · Herron, MIBuilt 1946 · S/N 8126 N89123Largo Sound Holdings LLC · Key Largo, FLS/N 8131 N89127Mayfield Bruce J · Pendleton, ORBuilt 1946 · S/N 8135 N89128Moss Gregg A · Sierra Blanca, TXS/N 8136 N89129Buell Randy L · Spokane, WABuilt 1946 · S/N 8137 N89134Hobson Michael W · Goodyear, AZBuilt 1946 · S/N 8142 N89139Kelp Jeanne L · Greenacres, WAS/N 8147 N89140Walters Ryan D · Culloden, GABuilt 1946 · S/N 8148 N89141Grover Jan L · Weatherly, PABuilt 1946 · S/N 8149 N89145Dunn Gary M · Galesburg, MIS/N 8153 N89151Margart Kristopher W · Walla Walla, WABuilt 1946 · S/N 8159 N89152Kitts Ryan B · Fromberg, MTS/N 8160 N89155Ely Roger J · Chandler, AZBuilt 1946 · S/N 8167

Back to Cessna 140