Skip to content

Taylorcraft F21

Registered aircraft · 14

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

N2004HMolek Jon · Warren, OHS/N F-1004 N2004VLindeman Jack E · Berlin, NYBuilt 1980 · S/N F-1007 N2004YAmorelli Leon D · River Falls, WIBuilt 1980 · S/N F-1008 N2005EShaw Brian W · Bemidji, MNBuilt 1981 · S/N F-1015 N2005JGray Shane Charles · Interlochen, MIS/N F-1014 N2005KBiornstad John A · Big Lake, AKBuilt 1981 · S/N F-1016 N2005RMapes Rocky A · Thornton, COBuilt 1981 · S/N F-1012 N2005SBaker James W · Rochester, NYBuilt 1982 · S/N F-1002 N2005UArcand David R · Forest Lake, MNBuilt 1981 · S/N F-1013 N2005ZKornstad Vern A · Kenai, AKBuilt 1982 · S/N F-1018 N2006JGlendinning William O · South Bristol, MEBuilt 1982 · S/N F-1021 N2006TDanford Michael S · Chickamauga, GAS/N F-1503 N2006UAllred Robert B · Anthem, AZBuilt 1983 · S/N F-1020 N4417EDeaton David B · De Berry, TXBuilt 1985 · S/N F-1022

Back to Taylorcraft F21