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.
N1271HAmundson Kimber L · Eagle River, AKN1273DJones William J · Villa Grove, ILN1276DLehr Denis J · Sacramento, CAN1277DEllison Phillip · Castle Hayne, NCN1277HRegistered aircraftN1279HRichmond Brian G · Rhome, TXN1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYN1285HWoodford John E · Madison, WIN1286DPolicani Desmond M · Tacoma, WAN1287HNelson Chester C · Little Falls, MNN1289DAeronautical Technical Service Inc · Collierville, TNN1289HTranby Wayne A · Fargo, NDN1292DKlaerner John D · San Antonio, TXN1293DAlder George A · Palmer, AKN1293HAyers Mark T · Whitney, TXN1294HWolbert Joseph P · Canton, GAN1295DBlessum Jay A · Minot, NDN1297DPerk LLC · Glendale, AZN1298DGlaser Gerald A · Sebastopol, CAN1301HFair David E · Anchorage, AKFirst renewal noticeN1302HN1302h LLC · Levering, MIN1303DTail Dragn Tn LLC · Adams, TNN1304HShade Eric L · Dillingham, AKN1309DOld Buzzard Aviation Inc · Middleburg, FLN1309HBrodie James W · Lind, WAN1311DAntkowiak Colton C · Chugiak, AKN1313DPlowman Benjamin · Raleigh, NCN13149Dughman Tim A · Willow, AKN1317DBaer Monte Wayne · Ronan, MTN1318DBott Christopher L · Pilot Point, TXN1320DHarlan Dale L · Big Lake, AKN1322HSynnes Greggory M · Killdeer, NDN1323HMcginnis John W · Strawberry Plains, TNN1324HHudson Aircraft Service · Tallahassee, FLN1329HDetwiler Chad R · Urbana, OHN1330HNelson Chester C · Little Falls, MNN1331HQualitair LLC · MichelstadtN1332HDrake Tyler M · Fairbanks, AKN1337DThompson Taylor A · Highland Park, ILN1340HJacobs Robert C · Eureka, MTN1341DBuilders Guild Inc · Mesa, AZN1342DCaso Joseph J · Amity Harbor, NYN1343DHaanen Jeffrey J · Browns Valley, MNN1344DWolf Ronald T · Abbeville, LAN1345DBraner Richard C Trustee · Oakdale, CAN1346HSchwing Emily E · Girdwood, AKN1348HKoepplinger Dawn M · Chesaning, MIN1349DBishop Donald Joseph · Cary, NCN1349HRose Randy James · Egg Harbor, WIN1350DBock Ray P · Alpena, MI
Back to Continental C145 series