Skip to content

Taylorcraft BC12-D

Registered aircraft · 1,010

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

N1023DGregg John I Jr · Glendale, AZS/N 10520 N10JLSmith Loren D · Great Falls, MTBuilt 1946 · S/N 6681 N1182KUllrich Sandy J · Haskell, OKS/N 8309 N121BXEnglish Dexter · Syracuse, KSS/N 8960 N128ZKammer Frank B · Ringgold, GAS/N 7149 N175JBWhitcher Garrick L · Woodburn, ORS/N 1607 N19461Bouchard Jason A · Carmel Valley, CAS/N 9820 N194KJCollins Richard F · Lake Wales, FLBuilt 1948 · S/N 12010 N1951JDelaney John D · Mineral Point, WIBuilt 1946 · S/N 9902 N19JLPodeweltz Dana A · Merrill, WIBuilt 1946 · S/N 6719 N20VHale Leland Wayne Jr · Van Alstyne, TXBuilt 1946 · S/N 7891 N23880Hustak Michael G Jr · Granbury, TXBuilt 1946 · S/N 7682 N24443Dopfel Bruce E · Belle Plaine, KSBuilt 1940 · S/N 1780 N244MLLevonowich Michael J · Pleasant Prairie, WIS/N 6815 N246DSAbbett Farms LLC · La Crosse, INBuilt 1945 · S/N 6576 N24TMoore David R · Apple Valley, CABuilt 1946 · S/N 7890 N27500Stoos Robert A · Lakeland, FLS/N 2142 N27510Rustad Scott · Minot, NDS/N 6563 N2754XAngell Lane C · Blackfoot, IDS/N 9232 N27599Cushway Michael J · Trout Creek, MIBuilt 1940 · S/N 2240 N29694Poage James A · Fairbanks, AKBuilt 1941 · S/N 2538 N29753Balow Bregory S · Durand, WIBuilt 1946 · S/N 10288 N313EFFaith Jeffrey · Louisville, KYBuilt 1946 · S/N 8771 N321LDFitzgerald Fred Lee · Shelton, WABuilt 1947 · S/N 10544 N3377DWalden Joncy T · Millsap, TXBuilt 1946 · S/N 7432 N33942Dale Isaac F · Soldotna, AKBuilt 1941 · S/N 2792 N33989Gorreck August A · Lisbon, CTBuilt 1941 · S/N 2841 N34236Worcester Phillip · Tabor, IABuilt 1946 · S/N 7699 N34237Egdorf H W · White Rock, NMBuilt 1946 · S/N 7700 N34238Young Donald D · Salem, ARBuilt 1946 · S/N 7701 N34246Edley John H · New Iberia, LAS/N 7710 N3536TLuebke David M · Canton, SDS/N 6973 N36078Molek Jon · Warren, OHBuilt 1941 · S/N 3045 N36290Black Wallace D · Tuttle, OKS/N 3208 N36322Bensen John A · Greenville, NYBuilt 1945 · S/N 6402 N36483Kreloff Richard L · Petaluma, CABuilt 1945 · S/N 6412 N3742URockwell Tyler W · Maquoketa, IAS/N 6896 N39119Mcconnell Mark S · Paxton, NEBuilt 1945 · S/N 6414 N39120Leishman Randy R · Albin, WYBuilt 1945 · S/N 6415 N39141Vetter Dennis A · Manson, IABuilt 1945 · S/N 6425 N39150Lumb Alan S · Lancaster, NYBuilt 1945 · S/N 6431 N39156Craver Pete F IV · Colleyville, TXBuilt 1945 · S/N 6436 N39158Bauer Power LLC · Russellville, ARBuilt 1945 · S/N 6438 N39203Krv LLC · Los Altos, CABuilt 1945 · S/N 6457 N39216Price John DBA · Bennington, KSS/N 6470 N39223Weber Joseph P · Cuba City, WIBuilt 1945 · S/N 6477 N39228Jensen Zane K · Pingree, IDS/N 6483 N39230Frerichs Kevini M · Ogallala, NEBuilt 1945 · S/N 6484 N39232Baker Ronald K Jr · Dayton, OHBuilt 1945 · S/N 6486 N39233Kirik Paul J · Moline, ILBuilt 1945 · S/N 6487

Back to Taylorcraft BC12-D