Skip to content

Continental 0-300 series

Registered aircraft · 6,623

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

N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479 N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599 N100KHLefevers Adam · Pineville, KYS/N 28529 N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N1023BLeguia Augusto A · Kathleen, GAS/N 28524 N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221 N107PSLadies In Aviation LLC · Mocksville, NCBuilt 1965 · S/N 17253618 N108TSHesser Dale W · Cardington, OHBuilt 1952 · S/N 20328 N10BFCruz Keoni K · The Woodlands, TXBuilt 1958 · S/N 36672 N1100Souchet Brian · Fleming Island, FLBuilt 1956 · S/N 29178 N1102FGrant County State Bank · Carson, NDBuilt 1966 · S/N 17254697 N1104FMiller Jonathan A · Apo, APBuilt 1966 · S/N 17254699 N1105FGibbard Donald R · Walla Walla, WABuilt 1966 · S/N 17254700 N1108FAom Aircraft LLC · Wilmington, DES/N 17254703 N1114FRegistration Pending · Florence, SCRegistration pendingBuilt 1966 · S/N 17254709 N1117THimes Austin M · Wentworth, MOBuilt 1965 · S/N 17252759 N111MFField Monica · Los Angeles, CABuilt 1963 · S/N 17250162 N1120DCompher Charles D · Berryville, VABuilt 1966 · S/N 17254131 N1120FHaidle Wayne M · Bismarck, NDBuilt 1966 · S/N 17254715 N1122FDollosso Frank G · Lakeport, CABuilt 1966 · S/N 17254717 N1125FAeropark LLC · Michigan City, INBuilt 1966 · S/N 17254720 N1125HClark David D · Nenana, AKBuilt 1948 · S/N 15AC-140 N1127FPricemeyer Aviation LLC · St Pete Beach, FLS/N 17254722 N1128FLockridge James · Adairsville, GAS/N 17254723 N1129FKoch Bradley D · Billings, MTBuilt 1966 · S/N 17254724 N1129MTechair LLC · Playa Vista, CAS/N 17252240 N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584 N112QBFloyd Austin · Searcy, ARBuilt 1955 · S/N 26952 N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725 N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1137FSale Reported · New Hudson, MISale reported, canceledBuilt 1966 · S/N 17254732 N1139FGifford Kenneth A · Appleton, WIBuilt 1966 · S/N 17254734 N1142FHart James A · Arlington, VABuilt 1966 · S/N 17254737 N1143FWilson Dan · Saginaw, TXS/N 17254738 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N1155FDejesus Rodolfo B · Murfreesboro, TNBuilt 1966 · S/N 17254750 N1157FKiss George C · Bangor, PAS/N 17254752 N1158FAmerican Pride Aviation LLC · Newport Beach, CABuilt 1966 · S/N 17254753 N1159FRodimel Troy R · Greenwood, INS/N 17254754 N115MBChalet Suzanne Aviation Inc · Lake Wales, FLS/N 17248936 N1160FOcala Aviation Services Inc · Ocala, FLS/N 17254755 N1161FBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254756 N1166FMortensen Alex · Burley, IDBuilt 1966 · S/N 17254761 N1167FRegistration Pending · Cotter, ARRegistration pendingBuilt 1966 · S/N 17254762

Back to Continental 0-300 series