Skip to content

Schempp-Hirth STANDARD CIRRUS

Registered aircraft · 64

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

N108AClayton Harry L · Wichita, KSBuilt 1971 · S/N 140 N10LACondon Anthony B · Wichita, KSBuilt 1972 · S/N 280 N1117Lipe James E · Rossville, TNBuilt 1969 · S/N 14 N13DHenshaw Fritz H · Napa, CABuilt 1971 · S/N 171 N14JSMcnett Eric V · Topsham, MEBuilt 1972 · S/N 177 N1524TYoung Dennis N · Glen Mills, PABuilt 1970 · S/N 41 N177RFJones Gary R · Albany, NYBuilt 1972 · S/N 272 N184NHarper Robert J · Broken Arrow, OKBuilt 1969 · S/N 9 N1UDSpontak James S · Etters, PABuilt 1970 · S/N 34 N22FFWillat Garret I · Warner Springs, CABuilt 1973 · S/N 330 N230XFWalker Neiman J · Denton, TXBuilt 1972 · S/N 209 N2429Bittner Charles K · Maize, KSBuilt 1971 · S/N 118 N26TEStandish Jason L · Brook, INBuilt 1971 · S/N 101 N271BLVinarub Marc R · Webster, FLBuilt 1972 · S/N 271 N27826Bowen Stephen T · Englewood, TNBuilt 1970 · S/N 84 N279PN279p LLC · Homestead, FLBuilt 1971 · S/N 144 N2866Arnold David A · Jeffersonville, INBuilt 1970 · S/N 60 N3247Bartels Lance R · Freetown, INBuilt 1970 · S/N 17 N333UMason Steven K · Rolla, MOBuilt 1974 · S/N 528 N3450GSalmons James B · Oklahoma City, OKS/N 345G N3488Russell Tipton J · Muncie, INBuilt 1970 · S/N 32 N3698Abair Alan A · Cromwell, INBuilt 1972 · S/N 297G N3BJFrazin Michael B · Bend, ORBuilt 1972 · S/N 178 N3WHNorthern California Soaring Association · Livermore, CABuilt 1973 · S/N 324 N3XACentral Ohio Soaring Association · Columbus, OHBuilt 1982 · S/N 252 N4024Stoltz Charles T · Trenton, MIBuilt 1972 · S/N 206 N411JRCollegiate Soaring Association Inc · Greeley, COBuilt 1970 · S/N 35 N446EOngstad Clifford C · Surprise, AZBuilt 1973 · S/N 446 N468EMoore Michael D · Durham, MES/N 356G N49765Preston Shane M · Tuttle, OKBuilt 1973 · S/N 353 N4990GHigh Alpine Restaurant Ahcs Inc · Snowmass Village, COBuilt 1972 · S/N 267 N4CCBrown Leslie Albert · Saint Clair Shores, MIBuilt 1972 · S/N 187 N4RFJurado Alfonso E · Miami, FLS/N 338 N511XMackenzie Franklin F Trustee · Cary, NCBuilt 1970 · S/N 36 N55YRArmstrong Gregory A · Bonita, CABuilt 1970 · S/N 79 N5668Beltz Thomas G Jr · Lehighton, PABuilt 1972 · S/N 207 N56LSSouthern Eagles Soaring Inc · Butler, GABuilt 1973 · S/N 399 N581AGMiner Daniel E · Columbus, OHS/N 51 N6483Mrozinski Eric · Westford, MABuilt 1971 · S/N 124 N6484Gray Thomas M · Magnetic Springs, OHBuilt 1971 · S/N 125 N6485Atkinson Gary R · Pine Grove, PABuilt 1971 · S/N 127 N6486Rippy Robert · Wichita, KSBuilt 1971 · S/N 129 N6MSStafford Linda J DBA · Ann Arbor, MIBuilt 1973 · S/N 337 N71LSLundin Michael A · Ellensburg, WABuilt 1971 · S/N 119 N726MCOkeson Trent J · Spring, TXBuilt 1973 · S/N 289G N72ZZRavanfar Kia N · Redondo Beach, CABuilt 1972 · S/N 221 N777BDFranke Adam M · Eagle, IDBuilt 1972 · S/N 266 N7898Everson John · Providence, RIBuilt 1970 · S/N 45 N8082Worthen David · Las Vegas, NVBuilt 1971 · S/N 152 N8085Oklahoma Soaring Association · Mustang, OKBuilt 1971 · S/N 161

Back to Schempp-Hirth STANDARD CIRRUS