Skip to content

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

N17390Taylor Douglas B · New Middletown, OHBuilt 1936 · S/N 25 N18305Morozowsky Anthony M · Zanesville, OHS/N 36 N18312Black Wallace D · Tuttle, OKBuilt 1937 · S/N 45 N18336Davis Trenten E · Brodhead, WIBuilt 1937 · S/N 69 N18339Strine Russell A · Reading, PABuilt 1937 · S/N 72 N18340Hannam Michael J · Runnells, IABuilt 1937 · S/N 73 N18345Baker Lowell T · Effingham, ILBuilt 1937 · S/N 78 N18365Mann Thomas A · Ford, WABuilt 1937 · S/N 97 N19008Martin Allan E · Suquamish, WABuilt 1937 · S/N 114 N19028Cannard Marius A · Shullsburg, WIS/N 134 N19062Coffman Donald E · Heber, AZBuilt 1937 · S/N 168 N19608Petro Jerry R · Williamsburg, VABuilt 1937 · S/N 214 N19612Braness Jim G · Richmond, MNS/N 219 N19615Pearlman Aircraft Co · Orlando, FLBuilt 1937 · S/N 222 N19649Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 256 N19653Ranger Airfield Foundation · Ranger, TXBuilt 1937 · S/N 260 N19660Meyer Jeremy · Conway Springs, KSBuilt 1937 · S/N 267 N19693Byrd David J · Greensboro, NCBuilt 1937 · S/N 300 N19826Poorman Benjamin T · Wauseon, OHBuilt 1937 · S/N 331 N19829Pope Andrew W · New Boston, TXS/N 334 N19832Helgerson David · Ottumwa, IAS/N 337 N19844Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 349 N1985WKaplanov Kervin Rebecca A · Grosse Pointe, MIBuilt 1937 · S/N 360 N20304Rougeau Derek E · Florida, MABuilt 1937 · S/N 405 N20524Pflegl David H · Oregon City, ORBuilt 1937 · S/N 529 N20546Perry Aaron O · Piqua, OHS/N 554 N78353Ollerton Robert P · Patagonia, AZBuilt 1937 · S/N 85 N9014RDeakyne Carl T · Federalsburg, MDS/N 34

Back to Taylorcraft A