Skip to content

Travel Air 4000

Registered aircraft · 26

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

N1339Brandt Terry R · Hood River, ORBuilt 1929 · S/N 214 N158VGl Leonard Aviation LLC · Anacortes, WAS/N 1397 N31439Parker O'Malley Corporation · Chatham, NYBuilt 1929 · S/N 868 N3945Bikle Michael Trustee · Prunedale, CABuilt 1926 · S/N 319 N3979Trebon Gregory · Port Orange, FLBuilt 1928 · S/N 328 N4251NZeiler Richard Trustee · Thousand Oaks, CAS/N 808 N427WPemberton Ryan A · Valleyford, WAS/N 1418 N4369PZeiler Richard Trustee · Thousand Oaks, CAS/N 264 N4419Pinsky Harold · Ann Arbor, MIS/N 379 N4421Ward James G · Bonita, CABuilt 1928 · S/N 381 N469NDynamic Aviation Group Inc · Bridgewater, VABuilt 1929 · S/N 1383 N4834Dalton Brian W · Dallas, ORBuilt 1928 · S/N 418 N501VWalker Ray A · Sanger, TXBuilt 1929 · S/N A-1 N510EZeiler Richard Trustee · Thousand Oaks, CAS/N 146 N5427Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1928 · S/N 516 N5433David Lee Bradley Productions Inc · Temecula, CABuilt 1928 · S/N 522 N6479Waco Of Cross LLC · Cross, SCBuilt 1928 · S/N 799 N8719Federal Aerial Applicators LLC · Wilmington, DEBuilt 1929 · S/N 1003 N8870East Hampton Air LLC · Wainscott, NYBuilt 1929 · S/N 937 N9021Daacke Michael L · Glen Rock, PABuilt 1929 · S/N 821 N9031Schooler Harold L · Chico, CABuilt 1929 · S/N 832 N9049Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1928 · S/N 850 N90539Dickerson Harman C · Columbia, MOBuilt 1929 · S/N 867 N9820Oppegard Nicholas D · Dunedin, FLBuilt 1929 · S/N 1019 N9831Travel Air 4000 N9831 LLC · Clackamas, ORS/N 1052 N9908Price Christopher R · Shullsburg, WIBuilt 1929 · S/N 1118

Back to Travel Air 4000