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.
N1164HHall Nathan M · Shepherd, MTN1170HBeckman Thomas J · Pocahontas, ARN1175HKrummrey Steven C · Munith, MIFirst renewal noticeN1178HLarter Edward A · Franklin, NHN1179HMann Thomas A · Ford, WAN1182HWitherspoon Alexander · Sandy, ORN1183HMelby Justin D · Stoughton, WIN1186HLozier Jesse E · Coudersport, PAN1188HWitteveen Mark J · Kodiak, AKN118FRemington William J · Decorah, IAN1192HEberhardt William G · Orland, MEN1203HZimmer Dennis DBA · Pennock, MNN1204HCompton Adam J · Wasilla, AKN1208DMusgrove James F · Burien, WAN1209HNelson Chester C · Little Falls, MNN1211HSchelde Jack D · Cook, MNN1212DN1212d LLC · Boise, IDN1221DJamison Tim · Oklahoma City, OKN1224DByrer Jesse A · Monrovia, INN1224HCorcoran Timothy J · Aurora, ORFirst renewal noticeN1227DWhite Michael D · Willow Springs, MON1227HSutton Aircraft Salvage LLC · Palmer, AKN1228DBell Stephen R · Carleton, MIN1229HMattfield Weldon D · Bovey, MNFirst renewal noticeN1231DNeel Aviation LLC · Lakeland, FLN1233HRamberg Stephen Jon · Saint Louis Park, MNN1235DStates Douglas S · Geneseo, ILN1235HTravis Michael D · Anchorage, AKN1240DBaeder Mark A · Mesa, AZN1240HDestefano Patrick S · Bryan, TXN1244DBackcountry Aviation LLC · Ankeny, IAN1245DChism Jerry · Austin, ARN1247DWroe Daniel C · Denton, MDN1250DSmith Christopher R · Manvel, TXN1253HTschepen Leo R · Bisbee, NDN1256DYoung Robert J · Conroe, TXN1257DKendrick Ross M · Sycamore, GAN1258DInternational Air Services Inc Trustee · Carson City, NVN1259HSibley Dean R · Arcadia, CAN1261DEpstein Neal R · Medway, MAN1262DBohanan Robert C · Denali Park, AKN1263DSellers Kevin D · Baytown, TXN1264DReason Cole · Yakima, WAN1264HSaladino Matthew G · Katy, TXN1265DWiseth Devin · Grand Rapids, MNN1266DFinal Approch Flight Co LLC · Oviedo, FLN1266HStoker Paul M · Wasilla, AKN1267HRetroair Restoration LLC · Big Lake, AKN1268HBbl LLC · Louisville, KYN1270HBuehlman Peter · Laveen, AZ
Back to Continental C145 series