Skip to content

Continental TSIO-520-C

Registered aircraft · 17

Aircraft with this engine 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 engine_model_code IN ('17251')
  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 engine_model_code IN ('17251')
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.

N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644 N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034 N2443TN2443t LLC · High Springs, FLBuilt 1962 · S/N NAV-4-2443 N2704WSpillman David T · Flagstaff, AZBuilt 1967 · S/N U2060690 N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818 N448AKN448ak LLC · Helena, MTBuilt 1974 · S/N U20602295 N4831FWillis Rodney S · Wasilla, AKBuilt 1966 · S/N U206-0531 N6214VRegistered aircraftBuilt 1968 · S/N U206-1189 N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729 N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112 N673ATCitizen Air LLC · Port Angeles, WABuilt 1976 · S/N U20603513 N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346 N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226 N769BSWells Donald T · Seattle, WABuilt 1968 · S/N U206-1251 N8225QCartoflight Inc · Willoughby, OHBuilt 1976 · S/N U20603109 N8491SOgrin Kirk V · Bigfork, MTBuilt 1965 · S/N 18256591 N858JAAms Aviation LLC · South Bend, INBuilt 1976 · S/N U20603437

Back to Continental TSIO-520-C