Skip to content

Registered aircraft · 34

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

N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721 N1828FDrew Kevin · Fredonia, PABuilt 1965 · S/N 21058728 N1833FHale Jay · Corpus Christi, TXS/N 21058733 N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739 N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743 N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745 N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749 N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752 N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754 N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759 N1863FAndersen Dana K · Scappoose, ORS/N 21058763 N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764 N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767 N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769 N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761 N1870FWilliams Aviation LLC · Indianola, IAS/N 21058770 N1871FGorham Neil M · Memphis, TNBuilt 1966 · S/N 21058771 N1875FMcfadin T E · San Antonio, TXBuilt 1966 · S/N 21058775 N1877FHoots Kent B · Macon, GABuilt 1966 · S/N 21058777 N1879FKris Noone Air LLC · Wilmington, DES/N 21058779 N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783 N1887FHeadings Kevin · Echo, ORS/N 21058787 N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789 N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792 N1893FKleeman Mark · Kearney, MOS/N 21058793 N210GGWiegler Michael · Austin, TXBuilt 1966 · S/N 21058790 N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034 N5806FJones Flying Association · Wilmington, DEBuilt 1966 · S/N 21058806 N5809FDonnelly Robert J · Edwardsburg, MIBuilt 1966 · S/N 21058809 N5815FHubbard Scott N · New Brighton, MNBuilt 1966 · S/N 21058815 N6114RJstream Lc · Sheridan, WYS/N T210-0014 N6155RPlane + Simple LLC · Salt Lake City, UTBuilt 1965 · S/N T210-0055 N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766

Back to Cessna 210F