Skip to content

Continental I0-470 series

Registered aircraft · 4,499

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

N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000 N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104 N1000QErnest Obregon · Oakley, CAS/N 310P0195 N1001QRegistered aircraftBuilt 1962 · S/N 310H0001 N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002 N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N100BMarshall Xavier T · Carson, CAS/N 57114 N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158 N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922 N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015 N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076 N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722 N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932 N1024Calgonaire LLC · Seminole, TXS/N 57425 N1028WArt Air Partners LLC · Louisburg, NCBuilt 1973 · S/N TC-1533 N102FAMedic Choppers LLC · Springdale, ARS/N TC-483 N102JRRutkosky John J DBA · Palm Coast, FLBuilt 1961 · S/N 310-0041 N102XRidley Benjamin · Jamesville, NYBuilt 1966 · S/N 310L-0034 N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318 N1042RSale Reported · Los Angeles, CASale reportedBuilt 1971 · S/N TC-1414 N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045 N1045WButler Richard S · Poplar Grove, ILBuilt 1973 · S/N TC-1535 N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046 N1047W1047w LLC · Oakland, TNBuilt 1973 · S/N TC-1536 N104MMBaron 104mm LLC · Rohnert Park, CABuilt 1962 · S/N TC-289 N1052QNighthawk Air Systems Inc · Miami, FLS/N 310H0052 N1056QAerotrack Inc · Hemet, CABuilt 1963 · S/N 310H0056 N105BCKlauber Robert A · Athens, TNBuilt 1966 · S/N 310K0232 N105FADebbie Air LLC · Perkasie, PABuilt 1965 · S/N CD-853 N105LRegistered aircraftBuilt 1959 · S/N 35981 N105MCMathison John M · Del Norte, COBuilt 1964 · S/N 310I0162 N105XSaalwaechter John J · Lebanon, INBuilt 1960 · S/N D-6436 N1060WHarvey Ara Jr · Hernando, MSBuilt 1973 · S/N TC-1539 N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009 N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59 N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073 N1079QGriffin Marcus · Houston, TXBuilt 1963 · S/N 310H0079 N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946 N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N108GBLooney Jordan · Trumann, ARBuilt 1960 · S/N D-6422 N108JHInternational Air Services Inc Trustee · Carson City, NVS/N TC-1530 N108MLosey Thomas L · Ft Myers, FLBuilt 1963 · S/N 281 N1092WAmerican Aviation LLC · Waterville, MEBuilt 1973 · S/N TC-1549 N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921

Back to Continental I0-470 series