Skip to content

Consolidated Vultee BT-13A

Registered aircraft · 56

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

N113BTAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 1624 N118BGBrothers Aviation LLC · Black Rock, ARS/N 11876 N11FWRegistration Pending · Kingsford, MIRegistration pendingBuilt 1942 · S/N 5274 N130BTYandik Stephen E · Hudson, NYBuilt 1941 · S/N 1891 N213BDHoefly Christopher S · Belleview, FLBuilt 1941 · S/N 2514 N27003American Airpower Heritage Fly Museu · Dallas, TXBuilt 1942 · S/N 5017 N313BTEastern Stearman Inc Trustee · Leesburg, VABuilt 1943 · S/N 10425 N3571Shackelford John S Jr · Roanoke, TXS/N 3571 N369BTCargill James R II · Blaine, MNS/N 2379 N4043Elliott Dave P · Boulder, COS/N 5712 N4566VWalnut Ridge Army Flying School Museum Inc DBA · Walnut Ridge, ARS/N 2960 N4794NActs Aviation LLC · Fulton, TXS/N 5798 N52411American Airpower Heritage Flying · Dallas, TXBuilt 1941 · S/N 2548 N54679Norman Royce Kelly · La Feria, TXBuilt 1941 · S/N 2990 N54841N54841 LLC · Granite Falls, MNBuilt 1941 · S/N 5225 N55579Old Aeroplane Co LLC · Lake Suzy, FLBuilt 1942 · S/N 3307 N55759Brown Michael E Jr · Timmonsville, SCBuilt 1943 · S/N 9920 N5582NKoch Bruce R · Goodrich, MIBuilt 1942 · S/N 7543 N56319Lineage Flight LLC · Holly Springs, NCBuilt 1941 · S/N 2167 N56330Egmond Aircraft LLC · Lewes, DEBuilt 1941 · S/N 2088 N56478American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N 7356 N56642Meyer Jeffrey · Metamora, ILBuilt 1941 · S/N 6097 N56985Hurst Thomas Brooks · Tarkio, MOBuilt 1943 · S/N 8557 N57387Cousineau Paul J · San Clemente, CABuilt 1942 · S/N 3075 N57425Groshong Tedd D · Incline Village, NVS/N 3127 N57486American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1942 · S/N 5665 N58698Valiant Air Group LLC · Hamburg, NYS/N 5836 N59572Group 44 Vultee LLC · Dallas, TXS/N 1904 N59840Landis Kurt M · Canyon, TXBuilt 1946 · S/N 2459 N59842Valiant Effort LLC · Monte Vista, CABuilt 1942 · S/N 5057 N59961Bishop Nicholas E · Ukiah, CABuilt 1942 · S/N 7722 N60277Mid Atlantic Air Museum Inc · Reading, PABuilt 1942 · S/N 6519 N60795National Wasp Wwii Museum Inc · Sweetwater, TXBuilt 1943 · S/N 10514 N60799Hester Richard H · Carthage, NCS/N 7712 N61372Heitz Angel Air Services LLC · Manvel, TXBuilt 1943 · S/N 9642 N63824Lenerville Richard L · Adelanto, CABuilt 1946 · S/N 1340 N63838Von Graff Kurt · Pennington, NJBuilt 1941 · S/N 2276 N63884Williams Jay J · Marceline, MOFirst renewal noticeBuilt 1941 · S/N 1833 N67208American Airpower Heritage Flying Museum · Dallas, TXBuilt 1941 · S/N 2307 N67496Florida Keys Flight Academy LLC · Marathon, FLBuilt 1942 · S/N 8042 N67598Collins John · El Cajon, CAS/N 1621 N67868Biggs Bill · Temple, TXS/N 1421 N68144Egmond Aircraft LLC · Lewes, DEBuilt 1941 · S/N 1691 N68178Howard Mark C · Edmond, OKBuilt 1941 · S/N 3131 N68955Presby Aire LLC · Berlin, NHBuilt 1942 · S/N 5414 N69041Texas Warbirds LLC · Lewes, DEBuilt 1942 · S/N 6462 N69695C & G Air · Wilmington, DEBuilt 1941 · S/N 1860 N69915Barrie Robert W · Tonawanda, NYBuilt 1941 · S/N 2671 N726LPPratt Louis F · Nampa, IDS/N 5565 N73731Brothers Aviation LLC · Black Rock, ARBuilt 1953 · S/N 11230

Back to Consolidated Vultee BT-13A