Skip to content

Continental O-470-U

Registered aircraft · 56

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

N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579 N165NHExpert Aircraft Thinking & Restoration LLC · Wilmington, DEBuilt 1984 · S/N 18268382 N180DUSchlegel Mark O · Kingman, KSBuilt 1979 · S/N 18053012 N180ELInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 18053121 N182GCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N F18200068 N215RGGonzalez Rogiero A · San Antonio, TXBuilt 1979 · S/N 18266883 N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988 N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897 N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923 N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490 N33MLDaedalean Inc · Chandler, AZBuilt 1978 · S/N 18266626 N34CWRegistered aircraftBuilt 2018 · S/N 1170 N3679UPowerhouse Coach Inc · Idaho Falls, IDBuilt 1963 · S/N 18255079 N36STGriffith Joshua S · Breckenridge, TXBuilt 1979 · S/N 18267282 N4133YBlain Gerhart · Billings, MTS/N 18052828 N425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNS/N 18268454 N459THHlavaty Troy Edward · Columbus, NEBuilt 1980 · S/N 18267544 N4743ERegistered aircraftBuilt 1982 · S/N 18268265 N5089V89v LLC · Bethlehem, PABuilt 1980 · S/N 18267506 N5112NRcr Aviation LLC · Cave Creek, AZBuilt 1980 · S/N 18267524 N525LRSkywalker Leasing LLC · Wilmington, DEBuilt 1980 · S/N 18267356 N5383NCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1980 · S/N 18267678 N570JSRust James P · Seymour, INBuilt 1979 · S/N 18053041 N5946JMillett Paul B · Claremore, OKBuilt 1979 · S/N 18267024 N5HRRay Tanner Motors Inc · Phoenix, AZBuilt 1980 · S/N 18267523 N613TLSams Aircraft LLC · Fredonia, KYBuilt 1980 · S/N 18267613 N634NCN634nc LLC · Apopka, FLBuilt 1977 · S/N 18266008 N63579Ollmann Paul W · Poplar Grove, ILBuilt 1977 · S/N 18052855 N65RHHall Robert · Rapid City, SDBuilt 1977 · S/N 18052869 N699XMBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 182-67158 N6KKUey Aviation Group LLC · Newtown, CTBuilt 1979 · S/N 18267153 N6URAvidyne Corp · Melbourne, FLBuilt 1978 · S/N 18265967 N710GHAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N 18267470 N721AEmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 1978 · S/N 18266259 N73211Tc International Inc · Whittier, CABuilt 1978 · S/N 182-66301 N735LHBoeing Employees Flying Association Inc · Renton, WABuilt 1977 · S/N 18265505 N735YAMinnillo Vincent C · Ocala, FLBuilt 1977 · S/N 18265780 N735YTVenturini Renato A Jr · Friendswood, TXBuilt 1977 · S/N 18265797 N759APMccann Eric David · South Jordan, UTBuilt 1977 · S/N 18265841 N759LVJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266087 N759RPSayum LLC · Gonzales, CABuilt 1978 · S/N 18266155 N76DLSpur-N-Rotor Inc · Great Falls, MTBuilt 1978 · S/N 18266298 N782CB182q LLC · Anthem, AZBuilt 1979 · S/N 18267192 N7878WRegistered aircraftBuilt 1978 · S/N 18052936 N8276YVrem Kevin · Anchorage, AKBuilt 1977 · S/N 18052778 N882QHowell Andrew · Pinedale, WYBuilt 1980 · S/N 18266331 N9291Henderson Charles B · Houston, TXBuilt 1980 · S/N 18265332 N9359XNorthstar Management Inc · Clovis, CABuilt 1985 · S/N 18268503 N9378XWhitewater Aviation LLC · Lansing, WVBuilt 1985 · S/N 18268505

Back to Continental O-470-U