Skip to content

Registered aircraft · 39

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

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839 N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835 N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876 N210SCSpence C Jason · New Braunfels, TXBuilt 1967 · S/N 21058888 N30444Crapnell Mark · Huntington Beach, CAS/N 210-58861 N5821FFlite Five Inc · Kiowa, KSBuilt 1966 · S/N 21058821 N5822FGrein David A · Mokena, ILS/N 21058822 N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827 N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828 N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829 N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830 N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833 N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842 N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843 N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850 N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852 N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855 N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860 N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864 N5867FIndigo Of South Fl Inc · Sunrise, FLS/N 21058867 N5869FCavanaugh Gerald R · Friendswood, TXBuilt 1967 · S/N 21058869 N5872FStearns Edwin B Jr · Chandler, AZBuilt 1967 · S/N 21058872 N5873FWehrman George · Covina, CABuilt 1967 · S/N 21058873 N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878 N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887 N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902 N5904FRegistered aircraftBuilt 1967 · S/N 21058904 N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907 N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908 N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909 N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915 N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916 N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928 N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930 N66DTTucker Family Agricultural Co LLC · Kiowa, KSS/N 21058931 N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912 N7RDSchipper Properties Inc · San Jose, CABuilt 1967 · S/N 21058847

Back to Cessna 210G