Skip to content

Continental E225 series

Registered aircraft · 980

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

N3894BBishop Ernie · Los Angeles, CABuilt 1955 · S/N D-4179 N3896BAlden K Butcher Autioneering LLC · Jane Lew, WVBuilt 1955 · S/N D-4146 N3897BDiamond Stephen C · West Bloomfield, MIBuilt 1955 · S/N D-4304 N3898BHenson Larry B · Haslet, TXBuilt 1955 · S/N D-4376 N38RDBowser Adam L · Lake City, FLBuilt 1954 · S/N D-3868 N3943NHunt John A · Marion, KYBuilt 1948 · S/N D-1290 N4008KOlson Eric C · Seattle, WABuilt 1947 · S/N NAV-4-1008 N4012KKane Robert F · Wilton, CAFirst renewal noticeBuilt 1947 · S/N NAV-4-1012 N4016KHatch David G · Clovis, CABuilt 1947 · S/N NAV-4-1016 N4030QLemons Brooks D · Visalia, CABuilt 1968 · S/N 201513B N4045KCincy Warbirds LLC · West Chester, OHBuilt 1947 · S/N NAV-4-1045 N4135KBurlace Thomas J III · Aurora, COBuilt 1948 · S/N NAV-4-1135 N4158KHester Jesse S · Mclean, VAS/N NAV-4-1158 N4169KAndersen Nicholas · Logan, UTS/N NAV-4-1169 N4172KRegistration Pending · Lebanon, CTRegistration pendingBuilt 1948 · S/N NAV-4-1172 N417BCBain Eric Josh · Quinlan, TXBuilt 1956 · S/N D-4792 N418BRobb Steven G · Riverside, CABuilt 1948 · S/N D-1424R8 N41XEMedic Choppers LLC · Springdale, ARS/N D-2871 N4200DHarding Jeromy · Port Richey, FLBuilt 1955 · S/N D-4408 N4201DPhilpott Stuart · Taylorsville, KYBuilt 1955 · S/N D-4398 N4208DWiley Robert S · Fayetteville, TNBuilt 1955 · S/N D-4411 N4210DKeefer C Paul · Venus, TXS/N D-4415 N4211BAdair Edward A · Hemet, CAS/N D-4222 N4214BCoburn Brooks · Leesburg, VABuilt 1955 · S/N D-4167 N4215DTench William C · Belton, SCBuilt 1955 · S/N D-4421 N4216BRasmussen Nathan A · River Falls, WIBuilt 1955 · S/N D-4175 N4217DNation Linda S · Sanford, FLBuilt 1955 · S/N D-4426 N4218DHarris Beth · Albuquerque, NMBuilt 1955 · S/N D-4412 N4224DBurgher Ronald · Fallbrook, CABuilt 1955 · S/N D-4432 N4225BJobelle Albert M · Los Angeles, CABuilt 1955 · S/N D-4193 N4226DClark Douglas E · Petal, MSBuilt 1955 · S/N D-4435 N4226KTroeleman Adrian John · Naples, FLBuilt 1948 · S/N NAV-4-1226 N4228BKcuce LLC · Kalispell, MTS/N D-4197 N4230BYonge Chase L · Summerfield, FLS/N D-4201 N4230DKoski John M · Wichita Falls, TXBuilt 1955 · S/N D-4438 N4232DRuppel Robert E · New Orleans, LAS/N D-4441 N4233DLaine John J · Katy, TXBuilt 1955 · S/N D-4442 N4234BLionudakis Mike Alan · Scotts Valley, CABuilt 1955 · S/N D-4207 N4236BFisher Timothy G · Goddard, KSBuilt 1955 · S/N D-4209 N4236DMatthew S Mcgaugh · Denton, NCBuilt 1956 · S/N D-4448 N4237BKruger Kurt D · Delano, CABuilt 1955 · S/N D-4210 N4240BKent Ronald M · Fallon, NVFirst renewal noticeBuilt 1955 · S/N D-4214 N4240DSummit Coastal Pllc · Carrboro, NCBuilt 1956 · S/N D-4460 N4241DHilton Allen J A Jr · Justin, TXBuilt 1956 · S/N D-4461 N4242BKingsbury Raymond S · Farmington, MNBuilt 1955 · S/N D-4216 N4242DNielson Erik J · Erie, COBuilt 1956 · S/N D-4462 N4242KNaviation LLC · Kalispell, MTBuilt 1948 · S/N NAV-4-1242 N4244BHft Enterprises LLC · Wilburton, OKBuilt 1955 · S/N D-4218 N4244DWarner Michael · Lexington, KYBuilt 1956 · S/N D-4459 N4244KKlungle William C · Grand Haven, MIBuilt 1948 · S/N NAV-4-1244

Back to Continental E225 series