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.

N43228Webb Charles E · Cleburne, TXBuilt 1946 · S/N 6887 N43236Linzey Joshua T · Valley Springs, CABuilt 1946 · S/N 6895 N43242W&L Aviation LLC · Dover, DEBuilt 1946 · S/N 6901 N43245Kanae Clarence K · Kapolei, HIBuilt 1946 · S/N 6904 N43255Bell Brian T · Hummelstown, PABuilt 1946 · S/N 6914 N43258Mccormick Matthew S · Elk Grove, CABuilt 1946 · S/N 6917 N43261Haley Billie Jo · San Martin, CABuilt 1946 · S/N 6920 N43264Engebretson Eric T · Medford, ORBuilt 1947 · S/N 6923 N43269C & S Aerial Photography LLC · Ponca, NEBuilt 1946 · S/N 6928 N43271Hill Chad M · Makinen, MNS/N 6930 N43272Isaacson Arthur T · Hillsboro, MOBuilt 1946 · S/N 6931 N43277Dougherty Paul · Bethel, PABuilt 1946 · S/N 6936 N43278Dubbe James R · Jordan, MNBuilt 1946 · S/N 6937 N43279Wood Matthew M · Craigmont, IDS/N 6938 N43281Barnes Melinda L · Wilton Manors, FLBuilt 1946 · S/N 6940 N43283Holbrook Joel P · Delta Junction, AKBuilt 1946 · S/N 6942 N43290Stephenson R Glen · Southport, NCBuilt 1946 · S/N 6949 N43294Breezy Flight LLC · Northport, NYBuilt 1946 · S/N 6953 N43295Walker Ray A · Sanger, TXBuilt 1946 · S/N 6954 N43296Christenson Phillip C · Suring, WIBuilt 1946 · S/N 6955 N43300Bethke Matthew P · Girdwood, AKBuilt 1946 · S/N 6959 N43303Hanft Alan K · Twentynine Palms, CABuilt 1946 · S/N 6962 N43306Assend Dragon Aviation LLC · San Antonio, TXBuilt 1946 · S/N 6965 N43307Ashley James M · Greenwood, SCBuilt 1946 · S/N 6966 N43315Air Kraft Spraying Inc · Timber Lake, SDBuilt 1946 · S/N 6974 N43319Hazelbrook Robert E · Startup, WAS/N 6978 N43323Peters Robert W Jr · Cassville, NYBuilt 1946 · S/N 6982 N43324Moore Eugene K · Portsmouth, OHS/N 6983 N43328Ct Sales Of Southern Il LLC · Noble, ILBuilt 1946 · S/N 6987 N43329Songbird LLC · Columbus, GABuilt 1946 · S/N 6988 N43336Torkelson Gary G · Bloomington, MNBuilt 1946 · S/N 6995 N43338Leroy Philippe G · Willcox, AZBuilt 1946 · S/N 6997 N43345Advanced Airplanes Associates Inc · Keller, TXBuilt 1946 · S/N 7004 N43346Nuss Thomas J · Conway Springs, KSBuilt 1946 · S/N 7005 N43349Kiser Aviation LLC · Grottoes, VABuilt 1946 · S/N 7008 N43354Registration Pending · New Philadelphia, OHRegistration pending, pending cancellationBuilt 1946 · S/N 7013 N43356Watkins John C · West Grove, PABuilt 1946 · S/N 7015 N43366Morgan Jeff P · Justin, TXS/N 7025 N43371Price John DBA · Bennington, KSBuilt 1946 · S/N 7030 N43372Schaeffer Nolan J · Wasilla, AKBuilt 1946 · S/N 7031 N43381Smith Eric L · Amherst, NYBuilt 1946 · S/N 7040 N43382Hayes Terry L · San Andreas, CABuilt 1946 · S/N 7041 N43384Esau Raymond J Trustee · Atwater, CABuilt 1946 · S/N 7043 N43389Cate Lyndle K Trustee · Medford, ORBuilt 1946 · S/N 7048 N43392Ivy James H · Seligman, AZBuilt 1946 · S/N 7051 N43396James Zoraida K · Paulden, AZBuilt 1946 · S/N 7055 N43402Baker Rory W · Angleton, TXBuilt 1946 · S/N 7061 N43407Lesky Gregory · Farmdale, OHS/N 7066 N43409Doll John M · Austin, TXBuilt 1946 · S/N 7068 N43410Solinski Thomas · Oklahoma City, OKS/N 7069

Back to Taylorcraft BC12-D