Continental C145 series
Registered aircraft · 1,828
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 ('17012')
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 ('17012')
ORDER BY n_numberRun 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.
N1639DVoigt Don M · Palmer, AKN163WDavis Paul J Jr · Springdale, ARN1640DRoessler Larry J · Groveland, CAN1643DMaselko Jacek · Juneau, AKN1646DDraggin Tail Pilots · Prospect, PAN1647DExpress Aviation Management LLC · Dover, DEN1651DWeber Donald B · Chugiak, AKN1652DFischer Andrew G · Hopkins, MNN1655DAcosta Antonio A · Campbell Hall, NYN1657DFlying Aces LLC · Scappoose, ORN1658DClement Aircraft LLC · Anchorage, AKN1664DScud Air Solutions LLC · South Weber, UTN1665DDinstel Delbert F · Park City, MTN166LJWilcoxen Paul · Wichita, KSN167Palmer Michael · Crystal Lake, ILN1675DRatcliff Whitcomb T · Carnation, WAN1676DJohnston Brent A · Galena, OHN1680DTrade Winds Aviation Holdings LLC · Lewes, DEN1681DKaiserauer Brian · Longmont, CON1685DAngrisani Robert J · Sacramento, CAN1688DIsburgh Andrew N · Conyers, GAN1689DHumphreys Richard P · Sequim, WAN1691DSchaak James D · Billings, MTN1698DFandler Ron · Gresham, WIN170Schaffer Grant B · Springfield, ORN1700DJohnson Robert Kenneth · Monte Rio, CAN1704DSykes Gregory P · Arlington, WAN17053Rough Joseph W · Priest Lake, IDN1705DSchultz Jeffrey J · Wasilla, AKN1706DMaser Matt P · Junction City, ORN1707DMorse David M · Kernersville, NCN170AGHuber David C · Victoria, TXN170AKPerry John E · Kenai, AKN170ARSmith Edward T · Bradenton, FLN170ASBowe Rick J Trustee · Chippewa Falls, WIN170BRegistered aircraftN170BBSmothers Joey D · Dwight, ILN170BGFinley Rory P · Loon Lake, WAN170BKDugan Robert J · Boulder City, NVN170BSMcintyre James C · Bethlehem, PAN170CFAbes Erika · El Paso, TXN170CLHickle William H · Inyokern, CAN170CWHohmann Courtney P · Jacksonville, FLN170DFWilliams John S · Cleveland, TXN170DWBelden George B · Sonoma, CAN170ECMueller Brent · Saint Maries, IDN170EEDowd Darin R · Gainesville, TXN170ERBowles Brent J · Iraan, TXN170FMMain Freddie L II · Trophy Club, TXN170GAOtey Neil F · White Bear Lake, MN
Back to Continental C145 series