Skip to content

Registered aircraft · 11

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

N1536MTuttle Ronald A · College Grove, TNBuilt 1942 · S/N 93 N318YZSorensen Bennett · Wichita, KSS/N 42 52993 73 N52183Mid Atlantic Air Museum · Reading, PABuilt 1942 · S/N 87 N59688Knerr Joshua D · Tehachapi, CABuilt 1942 · S/N 25 N60434Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1942 · S/N 88 N63904Tuttle Ronald A · College Grove, TNBuilt 1946 · S/N 26 N64381Henderson Colin D · Norman, OKBuilt 1942 · S/N 65 N67972Commemorative Air Force · Dallas, TXBuilt 1942 · S/N 38 N73488Warbirds Of The World Air Museum · Los Lunas, NMBuilt 1943 · S/N 77 N73494Ruble Jr Frederick Warren · Denver, CORegistration revokedBuilt 1942 · S/N 43931C N75698Washington Buddy K · Ten Sleep, WYBuilt 1942 · S/N 6

Back to Schweizer TG3A