Skip to content

Continental IO-470 series

Registered aircraft · 225

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

N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005 N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4 N111KFrizzell Kim F · Lakeville, MNBuilt 1961 · S/N D6786 N112GBN112gb LLC · Oldsmar, FLBuilt 1964 · S/N CD796 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N11669Cummings Arthur · Delta Junction, AKBuilt 1963 · S/N 185-0493 N1189MQuality Aviation Inc · Marana, AZS/N 39180 N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698 N11SYRautiola Erik · Cresson, TXS/N TC-1468 N126SAS2 Aviation LLC · Biloxi, MSBuilt 1959 · S/N D5817 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119 N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307 N1313XM & S Airsupply DBA · Hawthorne, CAS/N 4223 N135ANegative Ghost Rider LLC · Bangor, MEBuilt 1966 · S/N 185-0986 N1365ZSkans David K · Henderson, NVBuilt 1961 · S/N TC-160 N13WBRodgers Harold Lynn Jr · Mckinney, TXBuilt 1956 · S/N BG-145 N141DEEssex Lisa · Oceanside, CABuilt 1973 · S/N 310Q-0805 N142MCCassen Mark E · Wilson, WYBuilt 1973 · S/N TC-1579 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N14DRRandall Adam M · Doylestown, PABuilt 1980 · S/N TC-2310 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1531FWrangell Mountain Air Inc · Palmer, AKS/N 185-0874 N155KKSmith Clifford Bryan · Newnan, GABuilt 1973 · S/N TC-1606 N157CCWhite David W · South Fulton, TNS/N 310I0157 N158DNiehaus James O · Erie, COBuilt 1961 · S/N 1850232 N1599ZBurks Aviation Inc · Hattiesburg, MSBuilt 1962 · S/N TC-216 N15BHHammer Robert H · Kirkland, WABuilt 1997 · S/N HW-1 N162WBN162wb LLC · Benton, KSBuilt 1957 · S/N BG-362JS N1655BIdle Acres Aviation LLC · Ridgeland, MSBuilt 1981 · S/N TC-2416 N1659WTrim Aire Aviation Inc · Mexia, TXBuilt 1973 · S/N TC-1475 N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875 N16YBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N TC-1688 N1728GMeyer Fred F · Hampshire, ILBuilt 1962 · S/N D-6946 N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025 N182PVGoble Robert G · Bellefontaine, OHBuilt 1975 · S/N 18263869 N182VVPlane Envy Aviation LLC · Winter Park, FLBuilt 1976 · S/N 18264973 N184FFranklin Joe · Vancouver, WABuilt 1988 · S/N 184 N185CQAndreshak John L · Soldotna, AKBuilt 1962 · S/N 1850400 N185CRRegistered aircraftBuilt 1962 · S/N 185-0335 N185EEThinair Ventures LLC · Kalispell, MTBuilt 1961 · S/N 1850105 N185EMAikins Laurie R · Bonners Ferry, IDBuilt 1961 · S/N 1850078 N185GBelz John W · Salt Lake City, UTBuilt 1961 · S/N 1850163 N185HHCoyne Greg · Hondo, TXBuilt 1961 · S/N 1850049 N185MKVermillion Brandt T · Amarillo, TXBuilt 1962 · S/N 1850455 N185ZAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 185-0983 N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068 N18PSSelect Airparts · Weyers Cave, VABuilt 1957 · S/N BG-327 N1904LJones William D · Argyle, TXBuilt 1963 · S/N D-7174 N1961DMulligan Kevin S · Port Alexander, AKBuilt 1961 · S/N 1850286

Back to Continental IO-470 series