Skip to content

Glasflugel KESTREL

Registered aircraft · 13

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

N1124WDe Young Robert Erwin · Napa, CABuilt 1969 · S/N 7 N11UUFisch Gregory Z · Charlotte, NCBuilt 1971 · S/N 42 N12JHLeonard Steven E · Wichita, KSS/N 31 N194FSeronello John F · San Francisco, CABuilt 1969 · S/N 5 N2306Sanders Dennis R · Ione, CABuilt 1971 · S/N 34 N2540Huelle Thomas M · Yucca Valley, CABuilt 1970 · S/N 29 N2867Marek John M · Tucson, AZS/N 33 N2898Rouw Calvin Cuin · Menifee, CABuilt 1970 · S/N 30 N401GFGrant Richard M · Eugene, ORS/N 73 N493AHutchins David J · Sherwood, ORBuilt 1971 · S/N 35 N59LLLeonard Steven E · Wichita, KSBuilt 1971 · S/N 32 N832SMChidekel Philip M · Chadds Ford, PABuilt 1972 · S/N 48 N9919Phelps Thomas L · Raleigh, NCBuilt 1969 · S/N 4

Back to Glasflugel KESTREL