Skip to content

Continental TSI0-470-B

Registered aircraft · 75

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

N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008 N1500LLandolt Gregg E · Moreno Valley, CABuilt 1968 · S/N TC-1120 N1605LBarbour Maria E · Owensboro, KYS/N 1021 N1704LCulver Marc D · Anchorage, AKS/N 10/6155 N22PTGuy Transportation Ltd · Wilmington, DEBuilt 1963 · S/N 320B0039 N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736 N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119 N2971QOn The Beam Aviation Inc · Hampton, GABuilt 1974 · S/N 310Q1074 N299AOverman Robert W · Fairfield, OHBuilt 1964 · S/N 320B-0057 N2LSNiec Steven M · Clio, MIBuilt 1975 · S/N 3 N3008RPerguson Robert C · Converse, TXBuilt 1962 · S/N 320A0008 N3011TBranson West Development Inc · Paso Robles, CABuilt 1964 · S/N 320C0011 N3012TCain James W · Big Rapids, MIBuilt 1964 · S/N 320C0012 N3020RHill James C · Grand Saline, TXBuilt 1962 · S/N 320A0020 N3021TGolden Arrow Transportation · Plainfield, NJBuilt 1964 · S/N 320C0021 N3026TBox William C · Goldsby, OKS/N 320C0026 N3027RLedford James · Broad Run, VABuilt 1962 · S/N 320A0027 N3027TPlane Services LLC · Twin Falls, IDBuilt 1964 · S/N 320C0027 N3029TConsolidated Resource Imaging LLC · Grand Rapids, MIBuilt 1964 · S/N 320C-0029 N3034TVelez Investments LLC · Orlando, FLS/N 320C0034 N3039TDdc Investments LLC · Hot Springs, ARBuilt 1964 · S/N 320C0039 N3040RSturgeon Newton Charles · Midland, TXBuilt 1963 · S/N 320A-0040 N3042TKls Enterprises Inc · Cave Creek, AZBuilt 1964 · S/N 320C0042 N3043TJwt Aviation LLC · Yancey, TXBuilt 1964 · S/N 320C0043 N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050 N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051 N3055TTechnical Education Services · Virginia Beach, VABuilt 1965 · S/N 320C0055 N314DBrantley Hugh Lawton · Hazlehurst, GABuilt 1965 · S/N 320C-0067 N320BTThomas Lance E Trustee · Mesa, AZBuilt 1965 · S/N 320C0048 N320CRBas Part Sales LLC · Greeley, COBuilt 1962 · S/N 320A0003 N320DBBodian Aakil · Martinez, GAS/N 320B0015 N320HHartwell John E · Pleasanton, CABuilt 1964 · S/N 320B0060 N320JZBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 320-0051 N320KChisum Robert W · Lorenzo, TXS/N 320-0018 N320PPIpock Brian P · Tulsa, OKS/N 320B0018 N320RDBurwell Michael · W Bloomfield, MIBuilt 1963 · S/N 320B0035 N322CCoffman Robert P · Bigfork, MTS/N 320C0073 N4154TNunya Business LLC · Middletown, DES/N 320D0054 N4154YMehling Robert C · Hardin, MTS/N 185-0354 N4207NHoover Brian A · Warsaw, INBuilt 1964 · S/N 320B0047 N4500VBales Philip J · Chandler, AZBuilt 1964 · S/N 320B0053 N454RBDan Cox LLC · Troutdale, ORBuilt 1966 · S/N D-8242 N5207XGreat Oaks Cdc · Cincinnati, OHBuilt 1962 · S/N 320-1-0107 N522LNomura Christopher · Riverside, CABuilt 1960 · S/N 57516 N543MPayne Jon R · Danville, PABuilt 1961 · S/N 320-0030 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N56VPGoulette Bryan · Fort Worth, TXBuilt 1961 · S/N 320-0036 N5701XCoan Mark A · Berthoud, COBuilt 1961 · S/N 320-0001 N5714XKulon Andrew · Wyanet, ILS/N 3200014 N5716XFlanegan Charles E Jr · Jonesboro, GABuilt 1961 · S/N 320-0016

Back to Continental TSI0-470-B