Skip to content

Schleicher KA 6 CR

Registered aircraft · 28

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

N10DVStringer Jeffrey H · Niskayuna, NYBuilt 1963 · S/N 6023 N10LSLund Clayton L · Cheboygan, MIBuilt 1963 · S/N 6169 N1200Carpenter James M · Harrisburg, NCBuilt 1966 · S/N 6521 N1825Powell Chuck E · Benton, KSBuilt 1967 · S/N 6619 N196PLMidwestern Soaring Assoc · Peculiar, MOBuilt 1964 · S/N 6282 N3038KPfeiffer Neal J · Wichita, KSBuilt 1966 · S/N 6554 N374TGPeterson Thomas J Jr · Newtown, PABuilt 1961 · S/N 1002 N4029ALeonard Steven E · Wichita, KSBuilt 1961 · S/N 944 N4099CPasquantonio Raymond · Canton, MIS/N 6058 N412XLAbercrombie David R · Eatonton, GABuilt 1967 · S/N 6608 N4296CManeely Roy H · Wadsworth, OHBuilt 1965 · S/N 6403 N458BKClosson Luke E Jr · Valdosta, GAS/N 6043 N4600TDevine Steven C · Doylestown, PAS/N 6315 N4793TVon Tresckow Peter M · Madison, WIBuilt 1963 · S/N 6141 N4938CShockey Jason M · Wharton, TXBuilt 1963 · S/N 6166 N5066Markowitz Neal S · Pittsfield, MABuilt 1961 · S/N 958 N5597AKolberg Rocky · Kelso, WABuilt 1960 · S/N 846 N5756DMiner Daniel E · Columbus, OHS/N 247 N6363TWatkins Dale A · Buffalo Grove, ILBuilt 1960 · S/N 726 N6384TToth Frank L · Schenevus, NYBuilt 1961 · S/N 1124 N6501DLeonard Steven E · Wichita, KSBuilt 1959 · S/N 652 N6ZSColby Robert D · Bigfork, MTS/N 6028 N70703Kennin Christiane M · Killeen, TXBuilt 1962 · S/N 1133 N86CRBender John L · N Richlnd Hls, TXBuilt 1962 · S/N 6015 N8705RBitikofer Dawid K · Kansas City, KSBuilt 1963 · S/N 6165 N9044RNelson Erik · Exeter, NHBuilt 1963 · S/N 6167 N9188XGreater Houston Soaring Assoc · Needville, TXBuilt 1965 · S/N 6357 N9431HSamson Philip C · Nashville, TNBuilt 1962 · S/N 6013

Back to Schleicher KA 6 CR