Skip to content

Continental W670 series

Registered aircraft · 987

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

N1004Glover William S · Mount Pleasant, TXBuilt 1928 · S/N 416 N1006DObrian Laurence J · Northridge, CAS/N 7614 N10218Porter Wade R · Chico, CABuilt 1959 · S/N 18 N10250Adcock Colton L · Dustin, OKBuilt 1960 · S/N 50 N10256Triple F Flying Inc · Benton, PAS/N 56 N10294Miller Andy · Marana, AZS/N 94 N1042MDusters And Sprayers Supply Inc · Chickasha, OKS/N 75-7136 N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656 N1046MStoos Robert A · Lakeland, FLBuilt 1943 · S/N 75-7204 N10471Dyson Keith A · Port Townsend, WABuilt 1929 · S/N 2 N1048MMccullough Carol Charlene Trustee · Tulsa, OKBuilt 1942 · S/N 75-6669 N104HAir Cav Helicopters LLC · Wilmington, DES/N 75-2820 N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670 N1066MN1066m LLC · Vero Beach, FLBuilt 1942 · S/N 75-7932 N1068NTravis Brent N · Hayden Lake, IDBuilt 1943 · S/N 75-5364 N107PRDownwind Flight LLC · San Antonio, TXBuilt 1941 · S/N 75-829 N1080DLindsey Paul Robert · Quinlan, TXBuilt 1951 · S/N 7692 N10QHammerle Tye F · Kenosha, WIBuilt 1940 · S/N 75-301 N11253Patterson John Miles II · Frankfort, KYBuilt 1931 · S/N 3212 N11274Vintage Aero Inc · Duncan, OKBuilt 1933 · S/N 3690 N11427Murray Thomas J · South Hampton, NHBuilt 1931 · S/N 3488 N11440Aerojet Services Inc · Aurora, COS/N 3497 N11453Callis Aviation LLC · Roanoke, VABuilt 1931 · S/N 3539 N11468Maples Charles S · Fairfax, VAS/N 3541 N11470Lovley Forrest T · Jordan, MNBuilt 1931 · S/N 3513 N11478Taylor Daniel J · Dandridge, TNBuilt 1932 · S/N 3559 N11490Pietsch Warren A · Minot, NDBuilt 1931 · S/N 3572 N11XSink Lendon V · Lexington, NCBuilt 1941 · S/N 1418 N1203MHeritage Aviation LLC · Shannon, ILBuilt 1943 · S/N 75-8167 N12237Mone Brent C · Santa Rosa, CABuilt 1936 · S/N 3 N12374Swindle Don K · Collinsville, TXBuilt 2006 · S/N 3764 N12428Flying Barefoot Ranch LLC · Wilmington, DEBuilt 1940 · S/N 3569 N12438Sale Reported · Groveland, CASale reportedBuilt 1932 · S/N 3579 N12443Steeves Brian · Wahpeton, NDBuilt 1932 · S/N 3606 N124BHMccusker Marina · Stuart, FLS/N 75-7606 N12557Collins Roger D · Woodinville, WABuilt 1941 · S/N 75-2625 N129LOld Goat LLC · Wilmington, DEBuilt 1943 · S/N 75-8581 N12FRWeston David · Burke, VAS/N 75-4581 N13027Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1932 · S/N 3660 N13050Plane Fun Inc Tr Trustee · Snellville, GABuilt 1932 · S/N 3678 N13071Period Aviation LLC · Babylon, NYBuilt 1933 · S/N 3689 N13072Bonafide Investments LLC · Dover, DEBuilt 1933 · S/N 3724 N1307NWeir Ryan L · Buckley, WAS/N 75-5135 N130PTMount Glenn W · Modesto, CABuilt 1942 · S/N 325H0 N1315NDevries Douglas F · Everett, WABuilt 1942 · S/N 75-5453 N13244Alacoast Vintage Biplanes LLC · Irvington, ALBuilt 1941 · S/N 75-908 N1327MMbs Aviation LLC · Topsail Beach, NCBuilt 1943 · S/N 75-8125 N1329MStahl John · Union Dale, PABuilt 1943 · S/N 758623 N1333DBaldock Patrick M · Carleton, MIBuilt 1942 · S/N 5838 N133RKent Carroll G · Newborn, GABuilt 1942 · S/N 75-6881

Back to Continental W670 series