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.

N43029Barnes Roger A · Rogers, ARBuilt 1946 · S/N 6688 N43033Perdue Sandy L · Asheboro, NCBuilt 1946 · S/N 6692 N43036Pollard Lacy L · Alma, MIBuilt 1946 · S/N 6695 N43039Mocniak Michael J · Washington, PAS/N 6698 N43040Krueger Robert C · Glenburn, MEBuilt 1946 · S/N 6699 N43042Merrell Jon P · Wolcott, NYBuilt 1946 · S/N 6701 N43052Vetterkind Lavern M · New Auburn, WIBuilt 1946 · S/N 6711 N43066Leblanc David F · Westminster, MABuilt 1946 · S/N 6725 N43067Thompson Brandon C · Windsor, MEBuilt 1946 · S/N 6726 N43072Meis Joseph M · Elgin, NEBuilt 1946 · S/N 6731 N43082Cal Aerofab Flight Academy · Chino, CABuilt 1946 · S/N 6741 N43083Haley Billie Jo · San Martin, CABuilt 1946 · S/N 6742 N43085Edgington Quinn A · Friday Harbor, WABuilt 1946 · S/N 6744 N43087Trident Resources LLC · Chino Valley, AZS/N 9887 N43092Weiser William B · Nampa, IDBuilt 1946 · S/N 6751 N43093Kryzanowicz Susan · Bay City, MIBuilt 1946 · S/N 6752 N43096Kornfield Edward A · Anchorage, AKBuilt 1946 · S/N 6755 N43101Sale Reported · Arlington, TNSale reported, pending cancellationBuilt 1946 · S/N 6760 N43104Mingledorff Eric G · Cordova, TNBuilt 1946 · S/N 6763 N43107Sopwith Nicholas J · Sacramento, CABuilt 1946 · S/N 6766 N43110Grantonic Richard F · Mingo Junction, OHBuilt 1946 · S/N 6769 N43112Dudley Michael L · Gilbertville, IABuilt 1946 · S/N 6771 N43114Becker Brian K · Wallace, IDS/N 6773 N43115Cannaday Clint J · Matthews, NCBuilt 1946 · S/N 6774 N43119Shadwick Clarence R · Tunnel Hill, GABuilt 1946 · S/N 6778 N43121Hanson Rod D · Wasilla, AKBuilt 1946 · S/N 6780 N43122Velez Carlos A · Cave Creek, AZBuilt 1946 · S/N 6781 N43127Rhodes Cary W · Taylorsville, GABuilt 1946 · S/N 6786 N43140G & J Enterprises · Wasilla, AKBuilt 1946 · S/N 6799 N43143Andrews Jon L Jr · Seward, AKS/N 6802 N43145Holler Curtis E · Wasilla, AKBuilt 1946 · S/N 6804 N43146Carmicheal Donald L · Carlisle, INBuilt 1946 · S/N 6805 N43150Hein Timothy J · West Allis, WIBuilt 1946 · S/N 6809 N43153Mcdaniel Ronnie J · Starkville, MSBuilt 1946 · S/N 6812 N43163Kramer Jerry J · Fort Recovery, OHBuilt 1946 · S/N 6822 N43166Gillitzer Dave G · Fresno, CAS/N 6825 N43172De Leon Carlos H · San Antonio, TXS/N 6831 N43178Barnstormers Aviation Club LLC · Bay City, MIBuilt 1946 · S/N 6837 N43189Holte Brian J · Monticello, MNBuilt 1946 · S/N 6848 N43190Persels Lyle · Osceola, IABuilt 1946 · S/N 6849 N43196Jarrett Henry W III · Virginia Beach, VABuilt 1946 · S/N 6855 N43199Norman Donald G · Oak Harbor, WABuilt 1946 · S/N 6858 N43202Lingl Herb · Lakeport, CABuilt 1946 · S/N 6861 N43203Hardy Lee E · Dundee, NYBuilt 1946 · S/N 6862 N43209Schaible John F · Palmerton, PABuilt 1946 · S/N 6868 N43210Wagner Lynn T · Valrico, FLBuilt 1946 · S/N 6869 N43211Gates Leo V III · Seguin, TXBuilt 1946 · S/N 6870 N43213Baker David M · Corning, NYS/N 6872 N43217Silva Michael M · Fairbanks, AKBuilt 1946 · S/N 6876 N43220Neal Alan B · Cherry Valley, CABuilt 1946 · S/N 6879

Back to Taylorcraft BC12-D