Skip to content

Registered aircraft · 37

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

N1238NRidilla Eric R · Palmyra, PABuilt 1941 · S/N 1632 N1261NBibber Eugene A · Anchorage, AKBuilt 1949 · S/N 42 13635 N184ENAttwood Eiron B · Fairbanks, AKBuilt 1943 · S/N 6247 N266CRag Wings And Radials Aircraft Leasing LLC · Wilmington, DEBuilt 1943 · S/N 6582 N30023Alaska Aviation Museum · Anchorage, AKBuilt 1942 · S/N 4629 N30FGrismer Jeff Trustee · Hemet, CAS/N 6183 N30LAerojet Services Inc · Poplar Grove, ILBuilt 1942 · S/N 3772 N41793Mid Atlantic Air Museum · Reading, PABuilt 1944 · S/N 5855 N44795American Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 6516 N46617Nichols Charles F Trustee · Baldwin Park, CABuilt 1943 · S/N 5193 N47155Grossberg Matthew D · Jacksonville, FLBuilt 1943 · S/N 5264 N51354Harmon Aviation LLC · Exeter, NHBuilt 1945 · S/N 3829 N51469Portland City Temple Inc · Oregon City, ORBuilt 1944 · S/N 6644 N51760Military Aviation Museum · Virginia Beach, VABuilt 1944 · S/N 5703 N51838Nichols Jan L · Bonham, TXBuilt 1943 · S/N 6531 N52703Onstott Norman V · Mt Pleasant, MIBuilt 1943 · S/N 6579 N53378Mid Atlantic Air Museum · Reading, PABuilt 1943 · S/N 4510 N53664Mid Atlantic Air Museum · Reading, PAS/N 5873 N54625Shallow Joseph · Inkster, MIRegistration revokedBuilt 1943 · S/N 454722 N578EKDavis Lloyd L Jr · Brackettville, TXBuilt 1942 · S/N 2581 N58542Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1943 · S/N 4203 N58XDavis Lloyd L Jr · Brackettville, TXBuilt 1944 · S/N 5933 N59188Newberg Edgar T · Hector, MNBuilt 1942 · S/N 3084 N60010Siderwicz Christopher J · Marstons Mills, MABuilt 1943 · S/N 3968 N60453Plane Fun Inc Tr Trustee · Snellville, GABuilt 1943 · S/N 5199 N64410Airpower Museum Inc · Ottumwa, IAS/N 6184 N6443CBig Sky Enterprises LLC · Oregon City, ORS/N 1122 N65203Smith David C · Brewster, WABuilt 1942 · S/N 3124 N66671National Wasp Wwii Museum Inc · Sweetwater, TXBuilt 1943 · S/N 6487 N672Morales Jason · Chagrin Falls, OHBuilt 1944 · S/N 5921 N67832Ferro Winifred J · Clinton, MOS/N 6117 N69072Someday Flight Foundation · Lockhart, TXBuilt 1945 · S/N 3105 N6HSCollings Foundation Inc DBA · Hudson, MABuilt 1942 · S/N 3696 N733T J Air Service Inc · Middletown, DEBuilt 1943 · S/N 4832 N73580T J Air Service Inc · Middletown, DEBuilt 1942 · S/N 2060 N88878Morgan Richard D · Belton, TXS/N 4121 N99NFleeman Joseph R · Lawrenceburg, TNBuilt 1943 · S/N 5165

Back to Cessna T-50