Skip to content

Taylorcraft BC12D-85

Registered aircraft · 28

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

N22657Mountain Air · Cody, WYBuilt 1939 · S/N 1304 N22CDMccaman Brock G · Marana, AZBuilt 1946 · S/N 10260 N36423Skysurfer Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1941 · S/N 3239 N39982Brown James A · Fairbanks, AKBuilt 1946 · S/N 6641 N43133Freeman Christopher D · Kingsbury, TXS/N 6792 N43726Wallis Bruce W · Kingwood, TXBuilt 1946 · S/N 7385 N44068Slagle Tyler J · Sunbury, OHBuilt 1946 · S/N 9868 N44321Flynn David H · Anchorage, AKBuilt 1946 · S/N 10121 N44404O Bryant Jeffrey A · Fairbanks, AKBuilt 1946 · S/N 10204 N5043MHaggan Allan C · Phillips, MEBuilt 1946 · S/N 10343 N5243MStrahm Ralph E · Holtville, CABuilt 1947 · S/N 10543 N5602MStedingh Dakota M · Anchorage, AKBuilt 1948 · S/N 12001 N5604MGray Shane C · Interlochen, MIS/N 12003 N5612MNelson Harold G · Pendleton, ORBuilt 1948 · S/N 12011 N5614MBachman Ernest J · New Brighton, PABuilt 1948 · S/N 12013 N5619MHardy Lee E · Dundee, NYBuilt 1948 · S/N 12019 N5629MReihing Randall S · Whitehouse, OHBuilt 1948 · S/N 12030 N6604NBakken Carl S · Kettle Falls, WAS/N 3-13004 N6608NBooth James L · Bozeman, MTBuilt 1949 · S/N 3-13008 N6612NHauer James D · Winthrop, MNBuilt 1949 · S/N 13012 N907TCDavis Randal V · Juneau, AKBuilt 1949 · S/N 12033 N94997Fast Bill B · Anchorage, AKS/N 9397 N95051Koelsch Benjamin N · Nome, AKS/N 9451 N95308Mcguire Robert E · Arrey, NMBuilt 1946 · S/N 9708 N95632Reid Robert W · Independence, ORBuilt 1946 · S/N 7932 N96012Alsworth Chandelle S · Port Alsworth, AKBuilt 1946 · S/N 8312 N96861Mizer James D · Hailey, IDBuilt 1946 · S/N 9161 N96925Bamford Bert W · Wasilla, AKS/N 9225

Back to Taylorcraft BC12D-85