Skip to content

Continental O-470R

Registered aircraft · 107

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

N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693 N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535 N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505 N11896Mcginty Flying Service LLC · Jones, LABuilt 1977 · S/N 18052921 N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N180AXNoyes Abigail · North Pole, AKBuilt 1969 · S/N 18051910 N180GHAbbott Christopher J · Gordon, NEBuilt 1965 · S/N 18051607 N180HRRoberts Leon Thomas Trustee · Noxon, MTBuilt 1966 · S/N 18051633 N180SGM&S Equipment Leasing LLC · Dalhart, TXBuilt 1973 · S/N 18052380 N180WYTorgerson Co LLC · Almena, WIBuilt 1955 · S/N 31437 N180YKnudson Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18051187 N180YYHastings Jamie · Vancouver, WAS/N 18052485 N1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1964 · S/N 18255911 N182GEGmr Leasing LLC · Lincoln, DEBuilt 1962 · S/N 18254299 N182SCMiller Michael C · Coon Rapids, MNBuilt 1974 · S/N 182-62864 N182WVMayo Ray Cody Jr · Shreveport, LABuilt 1966 · S/N 18256971 N184AKDe Man Cameron T · Bend, ORBuilt 1963 · S/N 18051302 N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374 N2015XAircraft Trade Group LLC · Scandia, MNS/N 18256115 N20791L A M Capital Management LLC · Sheridan, WYBuilt 1972 · S/N 18261207 N2198ROlson Darryld A · Buckley, WAS/N 18255398 N2341XYale LLC · Watford City, NDS/N 18256241 N2393CKocon Tyler · Puyallup, WABuilt 1954 · S/N 30693 N2404FDe Vries James S · Pacific, MOS/N 18051604 N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311 N2483GLenox Mark W · Idaho Falls, IDS/N 51783 N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139 N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893 N260DHStephens Ryan J · Dallas, PABuilt 1987 · S/N 20 N2619QHoman Edward L · Cincinnati, OHBuilt 1967 · S/N 18257819 N2700PSean Steward Md Pc · Hillsboro, ORS/N 18257803 N2708QElkhorn Aviation Inc DBA · Baker City, ORBuilt 1967 · S/N 18257908 N270KCLeyva Kevin S · Wilbur, WABuilt 1955 · S/N 31505 N2743XErb Weston Scott Trustee · Wasilla, AKBuilt 1965 · S/N 18051543 N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863 N2772XBratten Douglas D · North Pole, AKBuilt 1965 · S/N 18051572 N2776FBabovic Slobodan · Elm Grove, WIS/N 18256876 N2788QKahle Matthew N · Paw Paw, MIBuilt 1967 · S/N 18257988 N289WRBradbury Douglas W · Pedro Bay, AKBuilt 1957 · S/N 32864 N2948CTundra House Tailwheel Club LLC · Willow, AKBuilt 1955 · S/N 31730 N2958CKaralunas David · Anchorage, AKBuilt 1954 · S/N 30858 N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631 N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018 N3065FHinds Frank E · San Angelo, TXBuilt 1966 · S/N 18257165 N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646 N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714 N3349DWeninger Gregory M · Burrton, KSBuilt 1955 · S/N 32147

Back to Continental O-470R