Skip to content

Fairchild KR-21

Registered aircraft · 11

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

N107MReid Robert W · Independence, ORBuilt 1930 · S/N 1011 N202VPearlman Aircraft Co · Orlando, FLBuilt 1930 · S/N 1028 N204VAirpower Museum Inc · Ottumwa, IAS/N 1026 N206VYochelson Jerome C · Cranbury, NJS/N 1030 N207VMcnerney Patrick J · Cincinnati, OHBuilt 1930 · S/N 1 N209VBowe Walter C Trustee · Sonoma, CABuilt 1930 · S/N 1032 N230VRobidoux Raymond A III · Somers, CTBuilt 1930 · S/N 1037 N235VRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1930 · S/N 1042 N236VReid Daniel G · Klamath Falls, ORBuilt 1930 · S/N 1043 N362NWaco Of Cross LLC · Cross, SCBuilt 1930 · S/N 1017 N962VStix Albert I · St Louis, MOBuilt 1929 · S/N 1053

Back to Fairchild KR-21