Skip to content

Registered aircraft · 123

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

N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418 N13BJSevcik Clint · Medford, MNS/N 21058486 N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360 N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499 N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492 N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365 N210KEKampel Thomas E · Wellsville, PAS/N 21058505 N210WMBryan-Kennedy LLC · Tulsa, OKBuilt 1963 · S/N 21058287 N210XXRegistration Pending · Porter, TXRegistration pendingBuilt 1964 · S/N 21058402 N2306FBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058506 N2307FEads Kevin · Arley, ALBuilt 1964 · S/N 21058507 N2747VDavis Brady L · Monument, COS/N 21058458 N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228 N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231 N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233 N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238 N3739YCessna 210 LLC · Ogden, UTBuilt 1963 · S/N 21058239 N3743YCooper Jess D · Spanaway, WAS/N 21058243 N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246 N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247 N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248 N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249 N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250 N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253 N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254 N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255 N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259 N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251 N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252 N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260 N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265 N3766YPyanov Mark · Clinton, MSS/N 21058266 N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270 N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272 N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274 N3779YJoiner Matthew A · Temple, GABuilt 1963 · S/N 21058279 N3783YThompson Arthur H Jr · Hereford, AZBuilt 1963 · S/N 21058283 N3784YQualitair LLC · MichelstadtS/N 21058284 N3785YNational Snake Team LLC · Benton, LABuilt 1964 · S/N 21058285 N3786YWilliams John D · Geneva, OHBuilt 1963 · S/N 21058286 N3791YSatanta Flying Service Inc · Satanta, KSBuilt 1964 · S/N 21058291 N3793YBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1964 · S/N 21058293 N3797YCockroft Roger · Baltimore, MDBuilt 1964 · S/N 21058297 N3804YChelmo Jed E · Kimball, SDBuilt 1964 · S/N 21058304 N3805YMacys Flying Service Inc · Tulelake, CABuilt 1964 · S/N 21058305 N3806YOnion Crest Air LLC · Arcadia, NEBuilt 1964 · S/N 21058306 N3813YSheppard David A · Jackson, CABuilt 1964 · S/N 21058313 N3814YLadner Donald E · Centerville, TXS/N 21058314 N3815YBorean Anthony J · Olathe, COBuilt 1964 · S/N 21058315 N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319

Back to Cessna 210D