Skip to content

Registered aircraft · 305

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

N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905 N100YNEnrique Angulo · San Diego, CAS/N 21061236 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779 N10SBSackett Michael · Nordman, IDBuilt 1975 · S/N 21060920 N10YTN10yt LLC · Missoula, MTBuilt 1976 · S/N 21061460 N110HPColt 45 LLC · Tulsa, OKS/N 21059810 N111SHRobinson Doyle K · Panhandle, TXBuilt 1976 · S/N 21061270 N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504 N1173QMoon Mitchell L · Covington, GAS/N 21059673 N117PCalvin Kyle · Wichita, KSBuilt 1976 · S/N 21061407 N1181QFly 4 Food Inc · Wilmington, DEBuilt 1972 · S/N 21059681 N1183QMacfarlane Robert D · San Diego, CABuilt 1972 · S/N 21059683 N1184QStone Gary K · Santa Ana, CABuilt 1972 · S/N 21059684 N118RSMc Namara William M · Rancho Cucamonga, CABuilt 1974 · S/N 21060583 N11APAp Aero LLC · Oklahoma City, OKBuilt 1974 · S/N 21060168 N11KRDawson Gray N · Roseburg, ORBuilt 1976 · S/N 21061249 N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735 N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900 N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792 N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861 N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676 N1600XLd&B LLC · Show Low, AZS/N 21060636 N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687 N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690 N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711 N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713 N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714 N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979 N2012S9791m LLC · Tacoma, WAS/N 21060980 N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987 N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996 N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005 N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006 N2042SGausman Grace K · Lompoc, CABuilt 1975 · S/N 21061009

Back to Cessna T210L