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.

N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294 N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N2501SGonzales Gerald · Dallas, TXS/N 21061307 N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311 N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322 N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333 N2616SMontana Alpha Omega Ranch LLC · Miles City, MTBuilt 1976 · S/N 21061342 N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108 N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778 N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798 N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806 N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815 N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828 N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830 N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866 N29631Registered aircraftBuilt 1973 · S/N 21059873 N29674Snflk Leasing LLC · Andrews, TXBuilt 1973 · S/N 21059875 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903 N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907 N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918 N30453Lehman Land Management LLC · Vernon, TXBuilt 1973 · S/N 21059923 N30516J A Sutherland Inc · Ukiah, CABuilt 1973 · S/N 21059927 N30530Banegas Jose C Zankiz · Fort Myers, FLBuilt 1973 · S/N 21059929 N30644Registered aircraftBuilt 1973 · S/N 21059949 N30777Huff Charles Christopher · Midland, TXBuilt 1973 · S/N 21059959 N30942Polar Bear Aviation LLC · Batesville, MSBuilt 1973 · S/N 21059979 N322LKFindley Air LLC · Temecula, CABuilt 1974 · S/N 21060344 N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452 N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166 N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482 N333DAFavor Michael D · Chico, CABuilt 1976 · S/N 21061289 N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282 N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412 N333PSDoran Jeffrey T · Westerville, OHS/N 21060834 N33UT402wd Holdings LLC · Corpus Christi, TXS/N 21061177 N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130 N35443Registered aircraftBuilt 1973 · S/N 21059992 N354BSStevenson Bill · Sunrise Beach, TXS/N 210-60381 N37DPTurbo Time LLC · Mesa, AZBuilt 1976 · S/N 210-61452

Back to Cessna T210L